Fwd: Travel Assistance applications open. Please inform your communities

2018-02-14 Thread Michael Mior
See information below on travel assistance for ApacheCon 2018. It would be great to see some representation for Calcite. I'm hoping to attend myself, although not yet confirmed. -- Michael Mior mm...@apache.org -- Forwarded message -- From: Gavin McDonald

Multi Product support in a single RelNode tree

2018-02-14 Thread Abbas Gadhia
Hi, I want to build a RelNode tree with different conventions on different RelNodes (for example: in the following select query "select * from t1,t2", t1 is a table from Oracle and t2 is a table from SqlServer). I'm confused whether i should be using a single SchemaPlus to hold table

Apache EU Roadshow CFP Closing Soon (23 February)

2018-02-14 Thread Sharan F
Hello Everyone This is an initial reminder to let you all know that we are holding an Apache EU Roadshow co-located with FOSS Backstage in Berlin on 13^th and 14^th June 2018. https://s.apache.org/tCHx The Call for Proposals (CFP) for the Apache EU Roadshow is currently open and will close

Using Calcite for query planning

2018-02-14 Thread Guohui Xiao
Hi, We are considering using Calcite to perform cost-based query optimization in our project. Specifically, we can already generate some SQL queries expressed in some relational algebra expression through our API, and we want to optimize the generated expressions using Calcite. We have a cost

[jira] [Created] (CALCITE-2179) General improvements for materialized view rewriting rule

2018-02-14 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-2179: Summary: General improvements for materialized view rewriting rule Key: CALCITE-2179 URL: https://issues.apache.org/jira/browse/CALCITE-2179

Re: "org.codehaus.commons.compiler.CompileException"

2018-02-14 Thread Alessandro Solimando
Hi again, I have re-checked more carefully, the issue has indeed been fixed, sorry about that. On 14 February 2018 at 23:14, Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hi Julian, > I exclude that because in that branch I have got the two mentioned in the > JIRA ticket (+ ~28

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

2018-02-14 Thread Alessandro Solimando
Hello, while executing this query Calcite tries to cast the subquery (RexSubQuery) to a local reference (RexLocalRef), resulting in a ClassCastException. Here is the query: > > *select ** > *from (values (1, 'a'), (2, 'b'), (3, 'b'), (4, 'c'), (2, 'c')) as t(x, y)* > *where exists (* > * select

[jira] [Created] (CALCITE-2177) TUMBLE_START does not respect AS when SELECT and GROUP BY match

2018-02-14 Thread Andrew Pilloud (JIRA)
Andrew Pilloud created CALCITE-2177: --- Summary: TUMBLE_START does not respect AS when SELECT and GROUP BY match Key: CALCITE-2177 URL: https://issues.apache.org/jira/browse/CALCITE-2177 Project:

Use Calcite adapter with Elastic search and Java

2018-02-14 Thread Saurabh Pathak
Hello, I want to use calcite adapter with elastic search and java. But i haven't idea how to use calcite elastic search adapter could you please let us know how to use calcite adapter with elastic search and java. Thanks in advance for your co operation Thanks & Regards Saurabh Pathak

Re: Using Calcite for query planning

2018-02-14 Thread Julian Hyde
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 in mind, you may be able to achieve it without a cost model. Or, as you propose, a simple model based on cardinality. To

Re: "org.codehaus.commons.compiler.CompileException"

2018-02-14 Thread Alessandro Solimando
Hi Julian, I exclude that because in that branch I have got the two mentioned in the JIRA ticket (+ ~28 new tests) passing, and this one failing. Also the exception is different, in the ticket it was an assertion on the plan/resultset failing, while in this new case it is the code compilation

[jira] [Created] (CALCITE-2178) Extend expression simplifier to work on datetime FLOOR functions

2018-02-14 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-2178: Summary: Extend expression simplifier to work on datetime FLOOR functions Key: CALCITE-2178 URL: https://issues.apache.org/jira/browse/CALCITE-2178

Re: copy method in RelSubset class

2018-02-14 Thread Alessandro Solimando
Hi, while preparing some additional unit tests for the spark adapter ( https://github.com/asolimando/calcite/tree/SPARK-TESTS) I have stumbled upon the issue several times. This is the list of the tests that in my opinion should be succeeding but are failing because of an invocation of *copy*

Jekyll container configured for Github site generation

2018-02-14 Thread Edmon Begoli
Does anyone have a docker container with Jekyll configured for Github site generation like described in site/ readme.md and published? If not, would it make sense to build few containers and publish them official on Dockerhub for various development and testing tasks?

Re: Jekyll container configured for Github site generation

2018-02-14 Thread Enrico Olivelli
Il gio 15 feb 2018, 04:34 Edmon Begoli ha scritto: > Does anyone have a docker container with > > Jekyll configured for Github site generation like described in site/ > readme.md and published? > > > If not, would it make sense to build few containers and publish them >