1

I am using Elasticsearch on linux sever but Quering is a little bit difficult

because form of query is not SQL structure.

In crate, there is a sql plugin, so I put this plugin into my own Elasticsearch

Is it possible?

If not, how can I adopt Crate SQL Plugin into Elasticsearch?

Thanks

Jehyun Shim
  • 91
  • 2
  • 11
  • Note: you also can check out the [Elasticsearch 6.3 release, now (June 2018) with native SQL support](https://stackoverflow.com/a/50889538/6309). Not *exactly* Crate SQL though. – VonC Jun 16 '18 at 16:13

1 Answers1

2

Jehyun:

Crate has evolved from being an Elasticsearch plugin to a complete software stack. I don't believe that you can simply add a plugin to Elasticsearch to gain SQL-like queries. You would need to transition your cluster to Crate in order to use SQL queries.

Of course, you should test this process on a non-production system first.

Community
  • 1
  • 1
Spanky
  • 5,608
  • 10
  • 39
  • 45
  • Thank you for answering. I've tried build Crate SQL Plugin which is located in [github](https://github.com/crate/crate/tree/master/sql) but build with gradle doesn't work.. – Jehyun Shim May 15 '15 at 00:04
  • In github - CRATE SQL Plugin, there is a development document. As this guide, it can be build by maven, but no pom.xml file in same folder – Jehyun Shim May 15 '15 at 00:34