Executing elasticsearch-sql using painless script

Elastic Stack Elasticsearch
1

Hello,
_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
Thanks
Yoav

2

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?

3

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