Possible to config the SQL in a standalone server to connect to an ElasticSearch server?

[YouXiang-Wang]

Actually, in many cases, we may use the SAAS service provided by AWS/Azure/GCP etc. We could not install the ElasticSearch plugins freely. So I am wondering if it is possible to config the SQL in a standalone server to connect to an ElasticSearch server?

[YouXiang-Wang]

@abbashus Do we have the plan to support this big feature?

[abbashus]

It's right now in a Elasticsearch plugin from, and thus can only be bootstrapped alongside Elasticsearch. We may in the future break down the SQL plugin functionality in a standalone consumable form.

[abbashus]

We will certainly evaluate the need for such a feature. Currently we don't have a ETA on this.

[dai-chen]

@YouXiang-Wang We've added standalone mode in our new query engine in PR #491. You can find sample code in https://github.com/opendistro-for-elasticsearch/sql/blob/develop/integ-test/src/test/java/com/amazon/opendistroforelasticsearch/sql/ppl/StandaloneIT.java, though our engine code is not available on Maven repo yet. We will evaluate how many users need this and put efforts to make it public.