Hi Experts, Can we use the case when with SUM in one SQL in Elastic Search7.5.1? Does ES support this in SQL or other way? I tried to do this , while there have following issue: sql> select sum(case when model_qi_category=0 then 1 else 0 end) FROM es_voice_model_result where tenant_id = 2 group …

SQL Query with CASE When condition and SUM

system (system) Closed March 3, 2020, 8:58am 3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Elasticsearch SQL - Error when using CASE WHEN with SUM aggregate Elasticsearch elastic-stack-sql	4	1183	June 2, 2020
X-pack sql - summation of case statement does not work Elasticsearch	2	819	August 27, 2019
Query with CASE condition and SUM Elasticsearch	1	1612	January 5, 2018
Sum() in elastic search Using SQL Plugin Elasticsearch elastic-stack-sql	2	449	May 24, 2019
Sql "case" in elasticsearch Elasticsearch	3	1559	February 27, 2019