Opendistro SQL plugin for Elassandra

Vincent RoyerSep 14·1 min readElassandra is a distribution of Apache Cassandra including an Elasticsearch engine. The SQL plugin for Elasticsearch from OpenDistro is now running with Elassandra 6.8.4, allowing to query your Cassandra database through regular SQL.On each of your Elassandra 6.8.4.10 nodes, install the SQL Elasticsearch plugin available at https://github.com/strapdata/sql and restart the nodes.bin/elasticsearch-plugin install file:///path/to/opendistro_sql-0.10.0.0.zipUsing the Kibana DevTool, insert some sample dataOnce you inserted data through Kibana, you can check the underlying Cassandra table content:You can now query your Cassandra table through an SQL query with support for aggregation.Install and start the SQL CLI from OpenDistro, and query you Cassandra:Have fun with the SQL support for Elassandra and thanks in advance for your feedback !Elassandra: https://github.com/strapdata/elassandraSQL plugin for Elassandra : https://github.com/strapdata/sqlOpenDistro for Elasticsearch SQL : https://opendistro.github.io/for-elasticsearch-docs/docs/sql/