search

strapdata / elassandra

Elassandra = Elasticsearch + Apache Cassandra
http://www.elassandra.io
Apache License 2.0
1.72k stars 200 forks source link

Elasticsearch + SQL #368

Open dioptre opened 4 years ago

dioptre commented 4 years ago

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 commented 4 years ago

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 notifications@github.com 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.

dioptre commented 4 years ago

Can I help with this? What's needed?

dioptre commented 4 years ago

Can you give us an estimate for this?

vroyer commented 4 years ago

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 notifications@github.com 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.

dioptre commented 4 years ago

Thanks mate will take a look.

dioptre commented 4 years ago

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