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 i…

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

Several selects in one query

Elastic Stack Elasticsearch

Andreasky (Andrea) July 10, 2019, 6:14am 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.

Topic		Replies	Views
Sub querying in Elasticsearch Elasticsearch	4	1420	July 6, 2017
SQL - Group values that begin with the same letters with horizontal bar chart in Canvas? Kibana elastic-stack-sql , canvas	2	466	April 4, 2019
Canvas - How to do a nested Query? Kibana	3	948	May 3, 2019
Canvas : is it possible to send varaibles to esql, edocs query argument or is it a limitation in canvas Kibana canvas	6	2825	June 27, 2019
Query and sub query Elasticsearch	2	491	April 29, 2019

Several selects in one query

Related topics