Re: [ANNOUNCE] Apache Calcite 1.14.0 released

2017-10-05 Thread Chris Baynes
Thanks for the release Michael! Chris On Wed, Oct 4, 2017 at 11:28 PM, Jesus Camacho Rodriguez < jcama...@apache.org> wrote: > Great! Thanks for all the work to make this release happen and improve the > process documentation Michael! > > -Jesús > > > > On 10/4/17, 2:17 PM, "Michael Mior" wrote

[jira] [Created] (CALCITE-1998) Hive - Version specific handling for NULLS FIRST/ NULLS LAST

2017-10-05 Thread Abbas Gadhia (JIRA)
Abbas Gadhia created CALCITE-1998: - Summary: Hive - Version specific handling for NULLS FIRST/ NULLS LAST Key: CALCITE-1998 URL: https://issues.apache.org/jira/browse/CALCITE-1998 Project: Calcite

[jira] [Created] (CALCITE-1999) UNNEST generates a NPE when the parameter is null

2017-10-05 Thread Luis Fernando Kauer (JIRA)
Luis Fernando Kauer created CALCITE-1999: Summary: UNNEST generates a NPE when the parameter is null Key: CALCITE-1999 URL: https://issues.apache.org/jira/browse/CALCITE-1999 Project: Calcite

[jira] [Created] (CALCITE-2000) UNNEST a collection that has a field with nested data generates an Exception

2017-10-05 Thread Luis Fernando Kauer (JIRA)
Luis Fernando Kauer created CALCITE-2000: Summary: UNNEST a collection that has a field with nested data generates an Exception Key: CALCITE-2000 URL: https://issues.apache.org/jira/browse/CALCITE-2000

[jira] [Created] (CALCITE-2001) JDBC driver should return "SYSTEM TABLE" rather than "SYSTEM_TABLE"

2017-10-05 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2001: Summary: JDBC driver should return "SYSTEM TABLE" rather than "SYSTEM_TABLE" Key: CALCITE-2001 URL: https://issues.apache.org/jira/browse/CALCITE-2001 Project: Calcit

Re: Support of query for complex/nested data in calcite

2017-10-05 Thread Luis Fernando Kauer
I created:[CALCITE-1999] UNNEST generates a NPE when the parameter is null - ASF JIRA [CALCITE-2000] UNNEST a collection that has a field with nested data generates an Exception - ASF JIRA The syntax you posted as the equivalent standard query did not work (wrong syntax):  select d.name, e.emp

[jira] [Created] (CALCITE-2002) Distinct query against in-memory values is sometimes wrong

2017-10-05 Thread Marc Prud'hommeaux (JIRA)
Marc Prud'hommeaux created CALCITE-2002: --- Summary: Distinct query against in-memory values is sometimes wrong Key: CALCITE-2002 URL: https://issues.apache.org/jira/browse/CALCITE-2002 Project: Ca

querying elastisearch fields

2017-10-05 Thread AshwinKumar AshwinKumar
Hi devs, I have created an index called Movies and a type called Movie inside it. Below is the structure - curl -XPUT "http://localhost:9200/movies/MOVIE/1"; -d' { "MID" : "1", "TITLE": "The Godfather", "DIRECTOR": "Francis Ford Coppola", "YEAR": 1972 }' sqlline> !connect jdbc

Re: Support of query for complex/nested data in calcite

2017-10-05 Thread Julian Hyde
There's also CROSS APPLY and OUTER APPLY; see https://issues.apache.org/jira/browse/CALCITE-1472. On Thu, Oct 5, 2017 at 11:49 AM, Luis Fernando Kauer wrote: > I created: > [CALCITE-1999] UNNEST generates a NPE when the parameter is null - ASF JIRA > [CALCITE-2000] UNNEST a collection that has a

Assunto: querying elastisearch fields

2017-10-05 Thread Luis Fernando Kauer
Did you take a look in the test cases for some examples of use?  https://github.com/apache/calcite/blob/master/elasticsearch5/src/test/java/org/apache/calcite/test/Elasticsearch5AdapterIT.java What have you tried? 

Re: Re: Assunto: querying elastisearch fields

2017-10-05 Thread Luis Fernando Kauer
Your problem, again, is about the names being case sensitive.  Try using double quotes around column and table names to make sure they are interpreted correctly or use them all in uppercase, both in the json model and in the query.  You can also set a different lex property for the connection

Tables and Views in a query

2017-10-05 Thread Homer
Hello, I am currently trying to gather table and view information out of Calcite for security checking access. I am currently finding it is quite complicated to process through a complex query to get all the tables and views in use. I am processing through the SqlNode returned by the equiva