Executing elasticsearch-sql using painless script

_xpack/sql?format=txt enable to run sql queries using curl.
I was wondering if it is possible to run sql queries using painless script.
If it is possible , kindly share an example

Could you provide some more info? What kind of painless script you'd like to use?
ES SQL doesn't allow to use painless scripting in the query, but it provides a series of functions and operators which are translated to painless scripts where necessary.

You can check the ES API query that your SQL translate to by using the /_sql/translate endpoint. And by the way the /_xpack/sql is deprecated, you should use _sql, what version of Elasticsearch are you using?

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