Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Xiening Dai
Actually we solved this problem in our setup using a mechanism called “Pull-Up Traits”, which explores the possible trait set of children’s input to decide parent’s physical properties. In order to determine child input trait, you would have to look at child’s children, and all the way to the

[jira] [Created] (CALCITE-3468) Oracle cast to varchar does not use precision when it should

2019-10-31 Thread Lindsey Meyer (Jira)
Lindsey Meyer created CALCITE-3468: -- Summary: Oracle cast to varchar does not use precision when it should Key: CALCITE-3468 URL: https://issues.apache.org/jira/browse/CALCITE-3468 Project: Calcite

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Jinfeng Ni
Hi Vladimir, The SubsetTransformer interface and the iterating over the RelNodes within a RelSubset in Drill is exactly implemented to do the trait propagation. We also had to rely on AbstractConverter to fire necessary rule to avoid the CanNotPlan issue. At some point, Calcite community chooses

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Vladimir Ozerov
Hi Xiening, Yes, I think that the manual creation of converters to trigger parent rules should be enough at the moment. I'll try to explore this possibility. Thank you. Regards, Vladimir чт, 31 окт. 2019 г. в 20:11, Xiening Dai : > Hi Vladimir, > > I think for short/mid term, #2 way (using

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Xiening Dai
Hi Vladimir, I think for short/mid term, #2 way (using AbstractConverter) should work after we fix CALCITE-2970. We already understand the root cause, now are looking at the best way to fix it. If you cannot wait, you can also create your own converter rule so it won’t generate logical node,

[jira] [Created] (CALCITE-3467) fix PartialMapping mistake and Cosmetic Change

2019-10-31 Thread xzh_dz (Jira)
xzh_dz created CALCITE-3467: --- Summary: fix PartialMapping mistake and Cosmetic Change Key: CALCITE-3467 URL: https://issues.apache.org/jira/browse/CALCITE-3467 Project: Calcite Issue Type: Wish

[jira] [Created] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

2019-10-31 Thread Wang Weidong (Jira)
Wang Weidong created CALCITE-3466: - Summary: JDBC adapter dropped group by statement in subquery Key: CALCITE-3466 URL: https://issues.apache.org/jira/browse/CALCITE-3466 Project: Calcite

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Vladimir Ozerov
Hi Danny, Thank you very much for the links. What is described here is pretty much similar to the problem I describe. Especially the discussion about trait propagation, as this is basically what I need - to explore potential traits of children before optimizing parents. And this is basically what

Re: CassandraAdapter (Add Type) and WHERE statement.

2019-10-31 Thread Alessandro Solimando
Hello, I have logged a Jira ticket for this: https://issues.apache.org/jira/browse/CALCITE-3465 I have listed all the data types for Cassandra 3.x, and I have tried to compile a table with the current status, but there are few entries for which I am not sure. If you have time to contribute to

[jira] [Created] (CALCITE-3465) Cover Cassandra 3.x data types

2019-10-31 Thread Alessandro Solimando (Jira)
Alessandro Solimando created CALCITE-3465: - Summary: Cover Cassandra 3.x data types Key: CALCITE-3465 URL: https://issues.apache.org/jira/browse/CALCITE-3465 Project: Calcite Issue

[jira] [Created] (CALCITE-3464) RexSimplify simplifies plan having filter with NULL to empty values

2019-10-31 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3464: Summary: RexSimplify simplifies plan having filter with NULL to empty values Key: CALCITE-3464 URL: https://issues.apache.org/jira/browse/CALCITE-3464 Project:

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Danny Chan
Thanks Vladimir for bringing up this discussion ! Did you notice that there is a JIRA issue about this problem ? [1] Also a discussion about how to propagate the traits [2] [1] https://issues.apache.org/jira/browse/CALCITE-2970 [2] 

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Seliverstov Igor
Not only "fireRule" method is needed, but the way to get all parents of a set, containing a subset, produced by the transformation. Or a way to fire rules without traits satisfaction check. чт, 31 окт. 2019 г., 10:56 Vladimir Ozerov : > Hi colleagues, > > I would like to discuss with the

[jira] [Created] (CALCITE-3463) Parse SQL Query - Non-query expression encountered in illegal context

2019-10-31 Thread Yunpeng Niu (Jira)
Yunpeng Niu created CALCITE-3463: Summary: Parse SQL Query - Non-query expression encountered in illegal context Key: CALCITE-3463 URL: https://issues.apache.org/jira/browse/CALCITE-3463 Project:

[DISCUSS] Proposal to add API to force rules matching specific rels

2019-10-31 Thread Vladimir Ozerov
Hi colleagues, I would like to discuss with the community the possibility of adding a new public method to VolcanoPlanner which will forcefully re-trigger the rules for the specific rel. This is a follow up of a discussion started in the other thread [1]. **Problem statement** When converting