Elasticsearch + SQL

[dioptre]

What's the best (current) way to get SQL working?

https://github.com/NLPchina/elasticsearch-sql/ mentions x-pack-sql and opendistro (but 6.8.4 isn't supported)
https://opendistro.github.io/for-elasticsearch-docs/docs/sql/

[vroyer]

Right now, there is no solution for 6.8.4, we are adapting a version of the SQL from opendistro for Elassandra.

…

On 4 Sep 2020, at 04:03, Andrew Grosser ***@***.***> wrote: What's the best (current) way to get SQL working? https://github.com/NLPchina/elasticsearch-sql/ <https://github.com/NLPchina/elasticsearch-sql/> mentions x-pack-sql and opendistro (but 6.8.4 isn't supported) https://opendistro.github.io/for-elasticsearch-docs/docs/sql/ <https://opendistro.github.io/for-elasticsearch-docs/docs/sql/> — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#368>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACOMPGIVBOSAGWUGGM5SM5LSEBDIZANCNFSM4QWXJRUA>.

[dioptre]

Can I help with this? What's needed?

[dioptre]

Can you give us an estimate for this?

[vroyer]

Hi Andrew, Here is a first release of the Opendistro SQL plugin for Elassandra : https://github.com/strapdata/sql/releases. It does not support JOIN and DELETE right now because Elassandra 6.8.4 does not support parent-child join and reindex. Let us now if this works for you.

…

On 12 Sep 2020, at 21:59, Andrew Grosser ***@***.***> wrote: Can you give us an estimate for this? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#368 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACOMPGOYRKASMWTLCPIUGOTSFPHKBANCNFSM4QWXJRUA>.

[dioptre]

Thanks mate will take a look.

[dioptre]

Working thanks mate. What do you think about merged indexes? This could tide us over until we can do joins?

Ex.:

https://github.com/sfproductlabs/msgxc/blob/86ecc8e787e96881c80232a28d7b94ed527847da/xcs/.setup/schema/cassandra/elastic.1.sh#L136-L143