Re: RxNode (Filter) / Translator for various adapters (ES, Mongo, Geode etc.). Possible Bug ?

2018-05-28 Thread Andrei Sereda
; method to add to MongoAdapterIT) even better. > > On Mon, May 28, 2018 at 2:47 PM, Andrei Sereda wrote: > > Hello, > > > > Please correct me if my expectations are inaccurate about query > predicates > > in Calcite. > > > > I think there is an issue in

[jira] [Created] (CALCITE-2331) invalid filter evaluation in adapters

2018-05-28 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2331: -- Summary: invalid filter evaluation in adapters Key: CALCITE-2331 URL: https://issues.apache.org/jira/browse/CALCITE-2331 Project: Calcite Issue Type

skipping JDBC API (or ResultSet metadata / pagination)

2018-05-28 Thread Andrei Sereda
Hello, Is there a way to get Enumerator directly from RelNode bypassing JDBC calls like createStatement() / executeQuery() ? I'm looking for something like this: RelBuilder builder = . RelNode filter = builder.scan("mySchema", "myTable").filter().build(); Enumerable result =

RxNode (Filter) / Translator for various adapters (ES, Mongo, Geode etc.). Possible Bug ?

2018-05-28 Thread Andrei Sereda
Hello, Please correct me if my expectations are inaccurate about query predicates in Calcite. I think there is an issue in how expression translators work when AST is more complex (has more depth). Same code / logic is used across different adapters (Mongo / Geode / ES) so multiple data-sources

Re: ElasticSearch use of rest client (instead of TransportClient)

2018-05-18 Thread Andrei Sereda
> > Mit freundlichen Grüßen, > > *Christian Beikov* > Am 18.05.2018 um 21:19 schrieb Andrei Sereda: > > Yes it should be, since it is just an http client (apache http). > > ElasticSearch Rest API (query API) didn't change much > > < > https://www.elastic

Re: ElasticSearch use of rest client (instead of TransportClient)

2018-05-18 Thread Andrei Sereda
> > Mit freundlichen Grüßen, > > *Christian Beikov* > Am 18.05.2018 um 20:45 schrieb Andrei Sereda: > >> Hello, >> >> ES TransportClient is deprecated in 7.0 (to be removed >> <https://www.elastic.co/guide/en/e

ElasticSearch use of rest client (instead of TransportClient)

2018-05-18 Thread Andrei Sereda
Hello, ES TransportClient is deprecated in 7.0 (to be removed in 8.0) in favor of http rest client(s). Would you consider a contribution switching to Rest Low-Level Client

[jira] [Created] (CALCITE-2316) ES adapter converts query to lowercase

2018-05-17 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2316: -- Summary: ES adapter converts query to lowercase Key: CALCITE-2316 URL: https://issues.apache.org/jira/browse/CALCITE-2316 Project: Calcite Issue Type

Re: ElasticSearch. Explicit Definitions, Literals and RelBuilder

2018-05-17 Thread Andrei Sereda
> > > Mit freundlichen Grüßen, > > *Christian Beikov* > Am 17.05.2018 um 17:43 schrieb Andrei Sereda: > >> Regarding (2) Lower-case problem. The issue seems to be in >> ElasticsearchFilter.Translator >> <

Re: ElasticSearch. Explicit Definitions, Literals and RelBuilder

2018-05-17 Thread Andrei Sereda
myself unfortunately. I think > for your ???, you want builder.field(0) although builder.field("_MAP") may > also work. > > -- > Michael Mior > mm...@uwaterloo.ca > > > Le jeu. 17 mai 2018 à 10:39, Andrei Sereda <and...@sereda.cc> a écrit : >

Re: ElasticSearch. Explicit Definitions, Literals and RelBuilder

2018-05-17 Thread Andrei Sereda
;> 3) Whenever you want to see how to build a particular query, you may find >> it helpful to run "EXPLAIN PLAN FOR " in sqlline. >> >> -- >> Michael Mior >> mm...@uwaterloo.ca >> >> >> Le jeu. 17 mai 2018 à 01:26, Andrei Sereda <and...@

ElasticSearch. Explicit Definitions, Literals and RelBuilder

2018-05-16 Thread Andrei Sereda
Hello Calcite Devs, I have some questions about ES adapter and custom predicates / projections in Calcite. Your help is much appreciated. 1) All ES examples use a view (ZIPS ) which

ElasticSearch Adapters. Calcite vs Dremio

2018-05-16 Thread Andrei Sereda
Hello, I've noticed that Dremio implemented their own (calcite) adapters for ElasticSearch. According to documentation those adapters support ES

<    1   2   3   4