[
https://issues.apache.org/jira/browse/CALCITE-1253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15297413#comment-15297413
]
Julian Hyde commented on CALCITE-1253:
--------------------------------------
Indeed. Here's my quick assessment:
[NLPchina|https://github.com/NLPchina/elasticsearch-sql] has tighter
integration with ES (including being a plugin), the ability to query via HTTP,
and a few extensions to SQL ({{matchQuery}}, {{GROUP BY range}}). Calcite
probably has a fuller, more compliant implementation of SQL, a JDBC driver, the
ability to combine ES with other data sources in the same query, and the
ability to use different execution engines (e.g. Drill).
I'd love to hear what other people think. We will definitely consider adding
some of the SQL extensions to Calcite, especially those that relate to ES's
unique features (e.g. search).
> Create Elasticsearch adapter for Calcite
> ----------------------------------------
>
> Key: CALCITE-1253
> URL: https://issues.apache.org/jira/browse/CALCITE-1253
> Project: Calcite
> Issue Type: New Feature
> Reporter: Subhobrata Dey
> Assignee: Julian Hyde
>
> This JIRA ticket is created to propose the addition of the new Elasticsearch
> adapter for Calcite.
> The adapter exposes a SQL interface to elasticsearch which includes
> projection, filtering, sort, fetch, offset queries.
> I have provided a couple of PRs, the first one is for the elasticsearch
> adapter & the second one is for enhancing the Vagrantfile for loading test
> data required for running the Junits.
> Currently, the support for aggregates is not provided. The work on it is in
> progress.
> Kindly evaluate my contribution & please consider it as an addition to the
> calcite project.
> Following PRs are provided:
> https://github.com/apache/calcite/pull/236
> https://github.com/vlsi/calcite-test-dataset/pull/10
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
