[Feature request]Provide option to get query as locally on client, without connection to ES

[siddv29]

i am trying to use elasticsearch-sql with elasticsearch-knapsack to dump data from index to file/another index/another cluster, without any transfer of data to client.

If I could get the query, as a string locally on the client, the transfer of data on client would be avoided. And using knapsack, the data would be dumped in file/index from the cluster itself.

[shi-yuan]

You could explain your sql to get the elasticsearch query dsl, then export search results

[siddv29]

Thanks for your reply :-)
Yup, that would be the way forward.
I was trying to use ExplainTest.searchSanity to get an idea to explain the query. But it requires connection to ES.
Could you please suggest the way to do that.

[shi-yuan]

SearchDao searchDao = new SearchDao(null);
String dsl = searchDao.explain("SELECT * FROM index").explain().explain();
System.out.println(dsl);

[siddv29]

Worked like a charm!!
Thanks a lot!!...