Use Crate SQL module(plugin) in Elasticsearch

Question

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

Note: you also can check out the Elasticsearch 6.3 release, now (June 2018) with native SQL support. Not exactly Crate SQL though. — VonC
– VonC, Commented Jun 16, 2018 at 16:13

Community · Accepted Answer · 2017-05-23 12:06:07Z

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.

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered May 14, 2015 at 17:41

Spanky

5,80710 gold badges43 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jehyun Shim Over a year ago

Thank you for answering. I've tried build Crate SQL Plugin which is located in github but build with gradle doesn't work..

Jehyun Shim Over a year ago

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

Collectives™ on Stack Overflow

Use Crate SQL module(plugin) in Elasticsearch

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related