Re: Use Calcite adapter with Elastic search and Java

2018-02-15 Thread Christian Beikov
Did you take a look into the documentation? https://calcite.apache.org/docs/elasticsearch_adapter.html If you use ES5+ you have to use an empty userConfig as the ES Client doesn't support the properties that are listed in the example. You can also take a look at the tests(https://github.com/

Re: Multi Product support in a single RelNode tree

2018-02-15 Thread Abbas Gadhia
These are great inputs. Thank you! On Thursday 15 February 2018, 1:04:18 AM IST, Julian Hyde wrote: Schema (and SchemaPlus) is a namespace used to look up object names when validating a SQL query. It is not strictly required if you are building the query manually, or using RelBuilde

Re: Using Calcite for query planning

2018-02-15 Thread Davide Lanti
Ok, thank you very much Julian, we'll try it out. Best regards, Davide and Guohui. On 14/02/18 19:42, Julian Hyde wrote: It sounds like a good fit. Parse the SQL, translate to relational algebra, apply some query transformation rules on the algebra. If you have a few simple transformations

Re: subquery leading to a "java.lang.ClassCastException: RexSubQuery cannot be cast to RexLocalRef"

2018-02-15 Thread Julian Hyde
If this still occurs in the latest master then yes, definitely log a JIRA case. On Wed, Feb 14, 2018 at 3:41 PM, Alessandro Solimando wrote: > Hello, > while executing this query Calcite tries to cast the subquery (RexSubQuery) > to a local reference (RexLocalRef), resulting in a ClassCastExcepti

Re: copy method in RelSubset class

2018-02-15 Thread Julian Hyde
Yes, log a JIRA case. Making RelSubset.copy return this, rather than throw, seems pragmatic. Long-term I would like to get rid of copy, so we might reverse this change at some point. But by that time, these tests will be enabled. Julian > On Feb 14, 2018, at 4:04 PM, Alessandro Solimando >

[jira] [Created] (CALCITE-2180) Invalid code generated for negative of byte and short values

2018-02-15 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-2180: Summary: Invalid code generated for negative of byte and short values Key: CALCITE-2180 URL: https://issues.apache.org/jira/browse/CALCITE-2180 Project: Calcite

missing file on Calcite?

2018-02-15 Thread joyjoy
Hi, I am trying to use Calcite for my project. But found that in SqlParser.java, one of the import package is missing in the Calcite--in apache-calcite-1.15.0-src_core, in the package of org.apache.calcite.sql.parser.SqlParser.java. The missing file is: org.apache.calcite.sql.parser.impl.SqlPar

Re: missing file on Calcite?

2018-02-15 Thread Shuyi Chen
SqlParserImpl.java is javaCC generated code from the parser.jj. You need to to "mvn install" to compile the project to generate the file. It is under calcite/core/target/generated-sources/javacc/org/apache/calcite/sql/parser/impl/SqlParserImpl.java. Hope it helps. On Thu, Feb 15, 2018 at 2:39 PM,