Hacker News Reader

Is just SQL query syntax supported?

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?

View on HN

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,...

Read-Only should be fine.

Is there specific "Crate" query syntax for selects that is not supported by the Elasticsearch DSL?

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.

Reply on news.ycombinator.com