Re: Draft board report for April 2020

2020-04-01 Thread Chunwei Lei
Nice job, Stamatis! LGTM~ Best, Chunwei On Thu, Apr 2, 2020 at 6:11 AM Francis Chuang wrote: > Looks good to me, Stamatis! One very minor thing is a typo in "pull > requests" in the very last sentence. > > Francis > > On 2/04/2020 9:07 am, Stamatis Zampetakis wrote: > > (~174 open > >

Re: Re: Join Pruning/Rewrites

2020-04-01 Thread Haisheng Yuan
In many cases, they are not equivalent, unless the top level join is a semi-join, e.g. (T1⋈T2)⋉(T2⟖T3) on T1.a=T3.a can be optimized to (T1⋈T2)⋉T3 on T1.a=T3.a It is better to give a concrete example, so that we can discuss case by case. - Haisheng

[jira] [Created] (CALCITE-3892) Make junit test classes and methods non-public

2020-04-01 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-3892: Summary: Make junit test classes and methods non-public Key: CALCITE-3892 URL: https://issues.apache.org/jira/browse/CALCITE-3892 Project: Calcite Issue

[jira] [Created] (CALCITE-3891) Remove use of Pair.zip in RelTraitSet.satisfies

2020-04-01 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-3891: -- Summary: Remove use of Pair.zip in RelTraitSet.satisfies Key: CALCITE-3891 URL: https://issues.apache.org/jira/browse/CALCITE-3891 Project: Calcite

Re: Query planning takes forever on TPC-H queries #5 and #7

2020-04-01 Thread Haisheng Yuan
They are known issues. Calcite isn't doing well on join reordering, there are multiple reasons contributing to the inefficiency. Try to turn off the rule that does join associativity. - Haisheng -- 发件人:Boyan Kolev 日 期:2020年04月01日

Re: Draft board report for April 2020

2020-04-01 Thread Francis Chuang
Looks good to me, Stamatis! One very minor thing is a typo in "pull requests" in the very last sentence. Francis On 2/04/2020 9:07 am, Stamatis Zampetakis wrote: (~174 open pullvrequests),

Draft board report for April 2020

2020-04-01 Thread Stamatis Zampetakis
Attached below is a draft of this month's board report. I plan to submit it on April 6. Please let me know if you have any additions or corrections. ## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows

Query planning takes forever on TPC-H queries #5 and #7

2020-04-01 Thread Boyan Kolev
Hello, I am running a TPC-H benchmark on a database system that uses Calcite as query engine. However, two of the TPC-H queries (please see attached Query05.sql and Query07.sql) are failing to get planned by Calcite. After waiting one hour for the result of the EXPLAIN, I simply interrupted. To

Calcite geode adapter query

2020-04-01 Thread aashish choudhary
Hi, I am trying to setup querying geode using calcite geode adapter. So far i am successfully able to connect to geode cluster which is SSL enabled after making few changes in the adapter and query data for regions which are having flat hierarchy. However I am not able to run any query for