elassandra
elassandra copied to clipboard
strapdata
Elasticsearch + SQL
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/
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 [email protected] 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 https://github.com/strapdata/elassandra/issues/368, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACOMPGIVBOSAGWUGGM5SM5LSEBDIZANCNFSM4QWXJRUA.
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 [email protected] 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 https://github.com/strapdata/elassandra/issues/368#issuecomment-691538179, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACOMPGOYRKASMWTLCPIUGOTSFPHKBANCNFSM4QWXJRUA.
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