Re:Crate: Distributed SQL Database for the Age of Docker
by jodok on Monday April 06, 2015 @03:33PM
(#9330207)
yes, you can enable the elasticsearch API ("es.api.enabled: true" in the crate.yml config file). however, it's not officially supported and we recommend to use it read-only as we store additional information about tables,...
Re:Crate: Distributed SQL Database for the Age of Docker
by naiv on Monday April 06, 2015 @04:39PM
(#9330565)
Read-Only should be fine.
Is there specific "Crate" query syntax for selects that is not supported by the Elasticsearch DSL?
Re:Crate: Distributed SQL Database for the Age of Docker
by jodok on Monday April 06, 2015 @06:18PM
(#9331031)
Crate-only queries - like exact counts, distinct counts, (soon JOINs) - are not exposed via this API. The Crate query engine is accessing Lucene directly and not running on top of the ES query engine.
The beauty of the Elasticsearch query syntax is that you can dynamically create complex JSON dsl objects as you drill down just using push and other methods.
With the crate SQL syntax it looks like it would be a messier dynamic query generation using string functions?
So my question is: Is it possible to query Crate with Elasticsearch syntax?