amazon web services - aws elasticsearch least and greatest function error

Question

"elasticsearch endpoint /_opendistro/_sql"

Elasticsearch version:7.9

Reference link : https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-conditional.html

least function is n running properly with docker container elastic search but with aws elasticsearch as service it throwing below error.

{ "error": { "reason": "Invalid SQL query", "details": "Function [LEAST] cannot be found or used here. Did you mean [CAST]?", "type": "SemanticAnalysisException" }, "status": 400

question from:https://stackoverflow.com/questions/65850152/aws-elasticsearch-least-and-greatest-function-error

Answer 1

Waitting for answers