[jira] [Created] (CALCITE-4169) Release Calcite 1.25.0

2020-08-07 Thread Andrei Sereda (Jira)
Andrei Sereda created CALCITE-4169:
--

 Summary: Release Calcite 1.25.0
 Key: CALCITE-4169
 URL: https://issues.apache.org/jira/browse/CALCITE-4169
 Project: Calcite
  Issue Type: Task
Reporter: Andrei Sereda
Assignee: Andrei Sereda


Created for tracking 1.25.0 release 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (CALCITE-3912) Incorrect mapping parsing when properties have same name as reserved keywords in ElasticSearch

2020-04-10 Thread Andrei Sereda (Jira)
Andrei Sereda created CALCITE-3912:
--

 Summary: Incorrect mapping parsing when properties have same name 
as reserved keywords in ElasticSearch
 Key: CALCITE-3912
 URL: https://issues.apache.org/jira/browse/CALCITE-3912
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Andrei Sereda


If a property has name {{type}} or {{properties}} ES adapter doesn't process 
them correctly



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (CALCITE-3560) Allow generic data source (eg. InputStream) in CSVAdapter or FileAdapter(s)

2019-12-03 Thread Andrei Sereda (Jira)
Andrei Sereda created CALCITE-3560:
--

 Summary: Allow generic data source (eg. InputStream) in CSVAdapter 
or FileAdapter(s)
 Key: CALCITE-3560
 URL: https://issues.apache.org/jira/browse/CALCITE-3560
 Project: Calcite
  Issue Type: Improvement
  Components: csv-adapter, file-adapter
Affects Versions: 1.21.0
Reporter: Andrei Sereda
Assignee: Andrei Sereda


Currently CSV Adapter requires data to be stored on disk or remotely because 
table constructor argument is 
[URL|https://docs.oracle.com/javase/8/docs/api/java/net/URL.html]. 

Change CSV and File adapter to accept more generic source like 
[Readable|https://docs.oracle.com/javase/8/docs/api/java/lang/Readable.html] or 
[InputStream|https://docs.oracle.com/javase/9/docs/api/java/io/InputStream.html]
 so adapters can operate on in-memory elements like String. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (CALCITE-3502) Upgrade Geode 1.6.0 -> 1.9.2

2019-11-13 Thread Andrei Sereda (Jira)
Andrei Sereda created CALCITE-3502:
--

 Summary: Upgrade Geode 1.6.0 -> 1.9.2
 Key: CALCITE-3502
 URL: https://issues.apache.org/jira/browse/CALCITE-3502
 Project: Calcite
  Issue Type: Improvement
  Components: geode-adapter
Reporter: Andrei Sereda


Upgrade geode to 1.9.2 (from 1.6.0)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (CALCITE-3157) Upgrade mongo java driver 3.5.0 -> 3.10.2

2019-06-29 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-3157:
--

 Summary: Upgrade mongo java driver 3.5.0 -> 3.10.2
 Key: CALCITE-3157
 URL: https://issues.apache.org/jira/browse/CALCITE-3157
 Project: Calcite
  Issue Type: Improvement
  Components: mongodb-adapter
Reporter: Andrei Sereda
Assignee: Andrei Sereda


We have quite outdated mongo java 
driver([3.5.0|https://mongodb.github.io/mongo-java-driver/3.5/]).
 Upgrade to [3.10.2|https://mongodb.github.io/mongo-java-driver/3.10/]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-3056) Elasticsearch adapter. Invalid result with cast function on raw queries

2019-05-08 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-3056:
--

 Summary: Elasticsearch adapter. Invalid result with cast function 
on raw queries
 Key: CALCITE-3056
 URL: https://issues.apache.org/jira/browse/CALCITE-3056
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Affects Versions: 1.19.0
Reporter: Andrei Sereda
Assignee: Andrei Sereda


Raw elastic queries (not based on views) return incorrect result when {{cast}} 
function is used.

{code:sql}

-- does not work without view (returns null)
select max(cast(_MAP['foo'] as integer)) from elastic

-- query based on view works
create view elasticview as select cast(_MAP['foo'] as integer) as foo from 
elastic; 
-- works
select max(foo) from elasticview 
{code}




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-3054) ElasticSearch adapter. Avoid scripting for simple projections

2019-05-07 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-3054:
--

 Summary: ElasticSearch adapter. Avoid scripting for simple 
projections
 Key: CALCITE-3054
 URL: https://issues.apache.org/jira/browse/CALCITE-3054
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Affects Versions: 1.19.0
Reporter: Andrei Sereda
Assignee: Andrei Sereda


No 
[scripting|https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-scripting.html]
 should be used for simple field projection(s).

In some cases elastic adapter uses {{script_fields}} instead of {{_source}} for 
simple field projections.

{code:sql}
select  _MAP['a'], _MAP['b.a'] from elastic
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2931) Mongo Adapter. Compare Bson (not string) query representation in tests

2019-03-18 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2931:
--

 Summary: Mongo Adapter. Compare Bson (not string) query 
representation in tests
 Key: CALCITE-2931
 URL: https://issues.apache.org/jira/browse/CALCITE-2931
 Project: Calcite
  Issue Type: Bug
  Components: mongodb
Reporter: Andrei Sereda
Assignee: Andrei Sereda


Some tests currently fail because of wrong order of keys in Bson. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2863) ElasticSearch adapter. Query fails when filtering directly on _MAP

2019-02-23 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2863:
--

 Summary: ElasticSearch adapter. Query fails when filtering 
directly on _MAP
 Key: CALCITE-2863
 URL: https://issues.apache.org/jira/browse/CALCITE-2863
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda


The following query fails:
{code:sql}
select * from elastic where _MAP['state'] = 'NY' order by _MAP['city']
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2814) ElasticSearch adapter. Fix "group by" when using raw item access (eg. _MAP['a.b.c'])

2019-01-28 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2814:
--

 Summary: ElasticSearch adapter. Fix "group by" when using  raw 
item access (eg. _MAP['a.b.c'])
 Key: CALCITE-2814
 URL: https://issues.apache.org/jira/browse/CALCITE-2814
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


The following query is still failing in elastic due to field / item mapping

{code:sql}
select max(_MAP['a']), _MAP['b'] from elastic group by _MAP['b']
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2797) Support APPROX_COUNT_DISTINCT aggregate function in ElasticSearch

2019-01-22 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2797:
--

 Summary: Support APPROX_COUNT_DISTINCT aggregate function in 
ElasticSearch
 Key: CALCITE-2797
 URL: https://issues.apache.org/jira/browse/CALCITE-2797
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Use native elastic 
[cardinality|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-cardinality-aggregation.html]
  aggregation for {{APPROX_COUNT_DISTINCT}} 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2755) expose document _id field when querying ElasticSearch.\

2018-12-26 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2755:
--

 Summary: expose document _id field when querying ElasticSearch.\
 Key: CALCITE-2755
 URL: https://issues.apache.org/jira/browse/CALCITE-2755
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Elastic exposes 
[_id|https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-id-field.html]
 field for each document (think unique doc ID).

Expose if it is explicitly listed in projection: 
{code:sql}
select _MAP['_id'], _MAP['foo'] from elastic -- available
select * from elastic -- not available
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2689) ES Adapter. Grouping on date / number fields fails

2018-11-20 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2689:
--

 Summary: ES Adapter. Grouping on date / number fields fails
 Key: CALCITE-2689
 URL: https://issues.apache.org/jira/browse/CALCITE-2689
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


For [Terms 
Aggregation|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html]
 missing value has to have same type as group key.

Currently single (text) key is used {{__MISSING__}} which fails when grouping 
on non-string fields (eg. dates, numbers or booleans).

When using {{missing}} (value) query converter should consider field type.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2651) Use scrolling by default in ElasticSearch adapter

2018-10-31 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2651:
--

 Summary: Use scrolling by default in ElasticSearch adapter
 Key: CALCITE-2651
 URL: https://issues.apache.org/jira/browse/CALCITE-2651
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2607) Support streaming in Mongo Adapter

2018-10-03 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2607:
--

 Summary: Support streaming in Mongo Adapter
 Key: CALCITE-2607
 URL: https://issues.apache.org/jira/browse/CALCITE-2607
 Project: Calcite
  Issue Type: Improvement
  Components: mongodb
Reporter: Andrei Sereda
Assignee: Julian Hyde


Since v3.6 MongoDB supports [change 
streams|https://docs.mongodb.com/manual/changeStreams/] which allow to listen 
real-time to collection updates.

Check if [calcite streams|https://calcite.apache.org/docs/stream.html] can be 
integrated with mongo streams.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2588) Run Geode Adapter tests with an Embedded Instance

2018-09-23 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2588:
--

 Summary: Run Geode Adapter tests with an Embedded Instance
 Key: CALCITE-2588
 URL: https://issues.apache.org/jira/browse/CALCITE-2588
 Project: Calcite
  Issue Type: Improvement
  Components: geode
Affects Versions: 1.18.0
Reporter: Andrei Sereda
Assignee: Julian Hyde


Similar to what has been done for Mongo / Elastic and Cassandra, allow Geode 
tests to run as part of CI build.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2585) Support NOT operator in ElasticSearch Adapter

2018-09-21 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2585:
--

 Summary: Support NOT operator in ElasticSearch Adapter
 Key: CALCITE-2585
 URL: https://issues.apache.org/jira/browse/CALCITE-2585
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


{{NOT}} boolean expressions should be correctly processed by Calcite (ES 
adapter): 
{code:sql}
select * from elastic where not foo = 1
select * from elastic where not foo in (1, 2, 3)
select * from elastic where foo not in (1, 2, 3)
select * from elastic where not foo in (1, 2, 3) and bar not in (42, 43, 44)
{code}
In elastic, they're converted to 
[must_not|https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html]
 BoolQuery.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2578) Support ANY_VALUE Aggregate Function in ElasticSearch Adapter

2018-09-19 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2578:
--

 Summary: Support ANY_VALUE Aggregate Function in ElasticSearch 
Adapter
 Key: CALCITE-2578
 URL: https://issues.apache.org/jira/browse/CALCITE-2578
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Sometimes it is useful to return a single value from a multi-set (bucket).

{code:sql}
SELECT foo, ANY_VALUE(bar) FROM elastic GROUP BY foo
{code}




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2557) Support pagination for buckets aggregations in ElasticSearch adapter

2018-09-14 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2557:
--

 Summary: Support pagination for buckets aggregations in 
ElasticSearch adapter
 Key: CALCITE-2557
 URL: https://issues.apache.org/jira/browse/CALCITE-2557
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Elastic doesn't normally support pagination with aggregates (see 
 [4915|https://github.com/elastic/elasticsearch/issues/4915]).


 Starting with v6.1 there is [bucket aggregation sorting 
|https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-pipeline-bucket-sort-aggregation.html]
 which can possibly be leveraged. However we have to support older versions of 
elastic like 2,5 and 6. Christian suggested to fetch larger dataset {{offset + 
limit}} and manually trim the result set on application side.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2553) Support NullDirection in Sorting for ElasticSearch Adapter

2018-09-12 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2553:
--

 Summary: Support NullDirection in Sorting for ElasticSearch Adapter
 Key: CALCITE-2553
 URL: https://issues.apache.org/jira/browse/CALCITE-2553
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Allow {{NULLS FIRST / LAST}} in {{ORDER BY}} clauses in ES adapter. Currently 
they're ignored.

This can be possibly achieved with [Bucket aggregation 
sorting|https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-pipeline-bucket-sort-aggregation.html]
 (for aggregations) and/or [Script Based 
Sorting|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-sort.html#_script_based_sorting]
 (for regular queries). 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2528) support for aggregations in ElasticSearch adapter

2018-09-04 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2528:
--

 Summary: support for aggregations in ElasticSearch adapter
 Key: CALCITE-2528
 URL: https://issues.apache.org/jira/browse/CALCITE-2528
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Translate SQL to 
[Terms|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html]
 and [Metric 
aggregations|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics.html]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2498) geode adapter quotes booleans as strings ('true' / 'false')

2018-08-28 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2498:
--

 Summary: geode adapter quotes booleans as strings ('true' / 
'false')
 Key: CALCITE-2498
 URL: https://issues.apache.org/jira/browse/CALCITE-2498
 Project: Calcite
  Issue Type: Bug
  Components: geode
Reporter: Andrei Sereda
Assignee: Julian Hyde


Having simple query:

{code:sql}
// SQL (calcite)
select * from geode where isActive = true
// OQL (geode)
select * from /region where isActive = 'true'
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2442) cassandra unit test leaves stale folders in cassandra/ module on Windows

2018-08-02 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2442:
--

 Summary: cassandra unit test leaves stale folders in cassandra/ 
module on Windows
 Key: CALCITE-2442
 URL: https://issues.apache.org/jira/browse/CALCITE-2442
 Project: Calcite
  Issue Type: Bug
  Components: cassandra
Reporter: Andrei Sereda


[~Sergey Nuyanzin] reported that 
[CassandraUnit|https://github.com/jsevellec/cassandra-unit] leaves 
{{.toDelete}} folder in maven module folder ({{cassandra/}}) rather than 
{{target/}} where all build and temporary files should be located.

{quote}
There is one more strange thing (at least on Windows): while building a
file with name ".toDelete" is generated under calcite\cassandra and it's
not removed by the end of tests
Is there a way to make cassandra generates these files in target directory
e.g.?
{quote}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2441) Relational algebra doesn't work with SQL views

2018-08-02 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2441:
--

 Summary: Relational algebra doesn't work with SQL views
 Key: CALCITE-2441
 URL: https://issues.apache.org/jira/browse/CALCITE-2441
 Project: Calcite
  Issue Type: Bug
  Components: core
Reporter: Andrei Sereda
Assignee: Julian Hyde


Query execution fails when one tries to use 
[RelBuilder|https://calcite.apache.org/docs/algebra.html] on the top of SQL 
view:

{quote}
Caused by: java.lang.UnsupportedOperationException
 at org.apache.calcite.plan.RelOptUtil$4.expandView(RelOptUtil.java:2805)
 at org.apache.calcite.schema.impl.ViewTable.expandView(ViewTable.java:124)
 ... 36 more
{quote}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2428) cassandra unit test initialization failure

2018-07-30 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2428:
--

 Summary: cassandra unit test initialization failure
 Key: CALCITE-2428
 URL: https://issues.apache.org/jira/browse/CALCITE-2428
 Project: Calcite
  Issue Type: Bug
  Components: cassandra
Reporter: Andrei Sereda


Unit test fails because {{java.version}} string is parsed incorrectly



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2411) expose a table for each ES index (by default)

2018-07-11 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2411:
--

 Summary: expose a table for each ES index (by default)
 Key: CALCITE-2411
 URL: https://issues.apache.org/jira/browse/CALCITE-2411
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Change how ES indexes are exposed in calcite schema
 # Allow multiple indexes to be present in the same schema (current limitation 
is schema per index)
 # Automatically import existing indexes using ES API (with optional regexp 
filtering). Elastic has an API listing all indexes / types / mappings
 # By default, adopt table per index approach. ES types
 [have been 
deprecated|https://www.elastic.co/guide/en/elasticsearch/reference/current/removal-of-types.html].





--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2408) enable aggregate functions in ES adapter

2018-07-09 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2408:
--

 Summary: enable aggregate functions in ES adapter
 Key: CALCITE-2408
 URL: https://issues.apache.org/jira/browse/CALCITE-2408
 Project: Calcite
  Issue Type: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Allow push-down of [aggregate 
functions|https://www.elastic.co/guide/en/elasticsearch/reference/6.3/search-aggregations.html]
 in ElasticSearch adapter.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2380) javadoc failures for some adapters

2018-06-25 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2380:
--

 Summary: javadoc failures for some adapters
 Key: CALCITE-2380
 URL: https://issues.apache.org/jira/browse/CALCITE-2380
 Project: Calcite
  Issue Type: Bug
Reporter: Andrei Sereda
Assignee: Julian Hyde


javadoc generation fails for some adapters.

Commands to reproduce:
{code:java}
$ mvn -DskipTests clean javadoc:javadoc javadoc:test-javadoc
$ mvn -DskipTests clean site{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2376) migrate elastic adapters to (low-level) rest client

2018-06-22 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2376:
--

 Summary: migrate elastic adapters to (low-level) rest client
 Key: CALCITE-2376
 URL: https://issues.apache.org/jira/browse/CALCITE-2376
 Project: Calcite
  Issue Type: Improvement
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


This is an effort to migrate existing Elastic Search adapters to use [low-level 
rest 
client|https://www.elastic.co/guide/en/elasticsearch/client/java-rest/current/java-rest-low.html].
 Existing [native transport 
client|https://www.elastic.co/guide/en/elasticsearch/client/java-api/6.3/client.html]
 has been deprecated in 7.0 (to be removed in 8.x).

Another advantage of low-level client is that it is compatible with any ES 
server version and has few (non-core) dependencies. Part of this improvement, 
both ES2 and ES5 adapters will be unified and reside under new maven module 
{{elasticsearch}} (contrary to separate {{elasticsearch2}} and 
{{elasticsearch5}}).
h3. Breaking changes

Using new {{artifactId}} and {{SchemaFactory}} implementation will force 
clients to change their configuration and dependencies. No other breaking 
changes are expected. 
  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2370) Failing mongo IT tests on version 3 without explicit sort

2018-06-19 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2370:
--

 Summary: Failing mongo IT tests on version 3 without explicit sort
 Key: CALCITE-2370
 URL: https://issues.apache.org/jira/browse/CALCITE-2370
 Project: Calcite
  Issue Type: Bug
Reporter: Andrei Sereda
Assignee: Julian Hyde






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (CALCITE-2345) add tests using Fongo to Mongo Adapter

2018-05-30 Thread Andrei Sereda (JIRA)
Andrei Sereda created CALCITE-2345:
--

 Summary: add tests using Fongo to Mongo Adapter
 Key: CALCITE-2345
 URL: https://issues.apache.org/jira/browse/CALCITE-2345
 Project: Calcite
  Issue Type: Improvement
Reporter: Andrei Sereda
Assignee: Julian Hyde


Better test coverage for unit tests using 
[Fongo|https://github.com/fakemongo/fongo] which is in-memory implementation of 
Mongo API.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[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: Bug
  Components: elasticsearch-adapter, geode, mongodb
Reporter: Andrei Sereda
Assignee: Julian Hyde


h2. Working
{code}
select count(*) from "elastic" where _MAP['foo'] in ('1') and true;
select count(*) from "elastic" where _MAP['foo'] ='1' and true;
select count(*) from "elastic" where _MAP['foo'] in ('1', '2');
{code}

h2. Fails
{code}
select count(*) from "elastic" where _MAP['foo'] in ('1', '2') and true;
select count(*) from "elastic" where true and _MAP['foo'] in ('1', '2');
select count(*) from "elastic" where (_MAP['foo'] ='1' or _MAP['foo'] = '2') 
and true;
{code}

h2. Elastic Adapter Exception
{quote}
java.lang.AssertionError: cannot translate OR(=(ITEM($0, 'foo'), '1'),
=(ITEM($0, 'foo'), '2'))
at org.apache.calcite.adapter.elasticsearch.ElasticsearchFilter$
Translator.translateMatch2(ElasticsearchFilter.java:234)
at org.apache.calcite.adapter.elasticsearch.ElasticsearchFilter$
Translator.translateAnd(ElasticsearchFilter.java:158)
at org.apache.calcite.adapter.elasticsearch.ElasticsearchFilter$
Translator.translateOr(ElasticsearchFilter.java:115)
at org.apache.calcite.adapter.elasticsearch.ElasticsearchFilter$
Translator.translateMatch(ElasticsearchFilter.java:101)
at org.apache.calcite.adapter.elasticsearch.ElasticsearchFilter$
Translator.access$000(ElasticsearchFilter.java:87)
at org.apache.calcite.adapter.elasticsearch.
ElasticsearchFilter.implement(ElasticsearchFilter.java:80)
at org.apache.calcite.adapter.elasticsearch.
ElasticsearchRel$Implementor.visitChild(ElasticsearchRel.java:53)
at org.apache.calcite.adapter.elasticsearch.
ElasticsearchToEnumerableConverter.implement(ElasticsearchToEnumerableConve
rter.java:71)
at org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.
visitChild(EnumerableRelImplementor.java:98)
at org.apache.calcite.adapter.enumerable.
EnumerableAggregate.implement(EnumerableAggregate.java:106)
{quote}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[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: Bug
  Components: elasticsearch-adapter
Reporter: Andrei Sereda
Assignee: Julian Hyde


Example of usage

{{SQL: select * from "elastic" where _MAP['Foo'] = 'BAR' (note upper-case) }}

{{ES Query: \{ "term": { "foo" : "bar" }} (note lower-case) }}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)