[jira] [Created] (CALCITE-3677) Add assertion to EnumerableTableScan constructor to validate if the table is suitable for enumerable scan

2020-01-03 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-3677: -- Summary: Add assertion to EnumerableTableScan constructor to validate if the table is suitable for enumerable scan Key: CALCITE-3677 URL:

[jira] [Created] (CALCITE-3676) VolcanoPlanner. dumpGraphviz should handle exception gracefully

2020-01-03 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-3676: -- Summary: VolcanoPlanner. dumpGraphviz should handle exception gracefully Key: CALCITE-3676 URL: https://issues.apache.org/jira/browse/CALCITE-3676 Project:

[DISCUSS] CALCITE-3661, CALCITE-3665, MaterializationTest vs HR schema statistics

2020-01-03 Thread Vladimir Sitnikov
Hi, It looks like MaterializationTest heavily relies on inaccurate statistics for hr.emps and hr.depts tables. I was trying to improve statistic estimation for better join planning (see https://github.com/apache/calcite/pull/1712 ), and it looks like better estimates open the eyes of the

Re: [DISCUSS] Stream tables vs hash joins

2020-01-03 Thread Rui Wang
+1 on having a type of property on Relnode to make know which node is steam or non-stream. In Apache Beam SQL's practice, stream joins are already metadata driven in which if there is one side stream and another side non-stream, we use hash-join like implementation but build that table on the

[DISCUSS] Stream tables vs hash joins

2020-01-03 Thread Vladimir Sitnikov
Hi, Stream tables do not play very well for hash joins. In other words, if hash join would try to build a lookup table out of a stream, it could just run out of memory. Is there metadata or something like that to identify stream-like inputs so hash join would ensure it does not try to build a

[jira] [Created] (CALCITE-3675) SQL to Rel conversion is broken for coalesce on nullable field

2020-01-03 Thread Anton Haidai (Jira)
Anton Haidai created CALCITE-3675: - Summary: SQL to Rel conversion is broken for coalesce on nullable field Key: CALCITE-3675 URL: https://issues.apache.org/jira/browse/CALCITE-3675 Project: Calcite

[jira] [Created] (CALCITE-3674) EnumerableMergeJoinRule fails with NPE on nullable join keys

2020-01-03 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-3674: -- Summary: EnumerableMergeJoinRule fails with NPE on nullable join keys Key: CALCITE-3674 URL: https://issues.apache.org/jira/browse/CALCITE-3674 Project:

[jira] [Created] (CALCITE-3670) Add ability to release resources when connection is closed

2020-01-03 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-3670: -- Summary: Add ability to release resources when connection is closed Key: CALCITE-3670 URL: https://issues.apache.org/jira/browse/CALCITE-3670 Project: