Several selects in one query

Elastic Stack Elasticsearch
1 
select ((select count(Call) from "log" where "Call" = 'answered') / (select count(Event) from "log"))

I'm trying to run this query in canvas, but i only get this error message:

[essql] > Unexpected error from Elasticsearch: [unsupported_operation_exception] null

When I run the same query in SQL it works fine. Does canvas support multiple SELECT in the same query?

2

Hi @Andreasky, unfortunately Canvas ES-SQL doesn't fully support every SQL operation. In this case subqueries are not supported in ES-SQL.

3

Thank you for your answer. I used the aggregate filter in the logstash configuration file to extract the values, that way I didn't need the subqueries.