Hi Elasticsearch Ninja Masters, I’ve recently spun up an Elasticsearch v7.4.0 Docker container, and I’m using the “elasticsearch-sql-cli” script to run SQL-like queries off my ES instance. Which is awesome, thank you for implementing that. I have a specific syntax question, however. I need to ru…

Pete, Unfortunately, I think you're hitting a documented limitation of our SQL support: Using aggregation functions on top of scalar functions Aggregation functions like MIN , MAX , etc. can only be used directly on fields, and so queries like SELECT MAX(abs(age)) FROM test are not possible. …

ES SQL :: Syntax for "sum( Value1 * Value2)"?

Elastic Stack Elasticsearch

redapplesonly (RAO) October 24, 2019, 3:11pm 4

No problem, I appreciate the information. Sometimes its nice to know that the thing you want to do isn't possible at the moment. Much appreciated!

Topic		Replies	Views
How to multiply two columns and then sum the result in ElasticSQL? Elasticsearch elastic-stack-sql	3	1351	March 7, 2019
SQL interface to Elasticsearch & Aggregation functions Elasticsearch	3	1255	July 6, 2017
Sum() in elastic search Using SQL Plugin Elasticsearch elastic-stack-sql	2	442	May 24, 2019
Is it possible to perform calculations using multiple fields in a document Elasticsearch	4	16686	July 5, 2017
How to perform Sum of a field to a group by data Elasticsearch	2	423	July 6, 2017

ES SQL :: Syntax for "sum( Value1 * Value2)"?

Related topics