[jira] [Comment Edited] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007941#comment-17007941 ] Vladimir Sitnikov edited comment on CALCITE-3668 at 1/4/20 7:47 AM: -

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007941#comment-17007941 ] Vladimir Sitnikov commented on CALCITE-3668: {quote} It has been there for

[jira] [Comment Edited] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007940#comment-17007940 ] Haisheng Yuan edited comment on CALCITE-3668 at 1/4/20 7:36 AM: -

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007940#comment-17007940 ] Haisheng Yuan commented on CALCITE-3668: {quote}It won't if LogicalFilter uses

[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: https://issues.apache.org/jir

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007927#comment-17007927 ] Vladimir Sitnikov commented on CALCITE-3668: {quote} Will a rule with patte

[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: Calcit

[jira] [Comment Edited] (CALCITE-3667) EnumerableMergeJoin should not use take-while enumerator

2020-01-03 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007901#comment-17007901 ] Jin Xing edited comment on CALCITE-3667 at 1/4/20 3:37 AM: --- H

[jira] [Commented] (CALCITE-3667) EnumerableMergeJoin should not use take-while enumerator

2020-01-03 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007901#comment-17007901 ] Jin Xing commented on CALCITE-3667: --- Hi Julian ~ Thanks for look into this ~ I think

[jira] [Commented] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-03 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007899#comment-17007899 ] Jin Xing commented on CALCITE-3285: --- Hi, [~vladimirsitnikov] ~ Thanks a lot for the f

[jira] [Comment Edited] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007796#comment-17007796 ] Haisheng Yuan edited comment on CALCITE-3285 at 1/3/20 10:20 PM:

[jira] [Commented] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007796#comment-17007796 ] Haisheng Yuan commented on CALCITE-3285: [~vladimirsitnikov] I checked your fix

[jira] [Commented] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

2020-01-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007788#comment-17007788 ] Julian Hyde commented on CALCITE-3285: -- In order to increase the capabilities of E

[jira] [Commented] (CALCITE-3667) EnumerableMergeJoin should not use take-while enumerator

2020-01-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007787#comment-17007787 ] Julian Hyde commented on CALCITE-3667: -- This change would change the complexity of

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2020-01-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007780#comment-17007780 ] Julian Hyde commented on CALCITE-3531: -- I get confused what 'dynamic' means. But C

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

2020-01-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007778#comment-17007778 ] Julian Hyde commented on CALCITE-3670: -- Schemas live longer than connections. Clos

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1700#comment-1700 ] Haisheng Yuan commented on CALCITE-3668: Will a rule with pattern {{operand(Fil

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

2020-01-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3675: - Affects Version/s: (was: next) > SQL to Rel conversion is broken for coalesce on nullable f

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007742#comment-17007742 ] Vladimir Sitnikov commented on CALCITE-3668: It still does not sound like a

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007663#comment-17007663 ] Haisheng Yuan commented on CALCITE-3668: Say we have a rule {{operand(Filter.cl

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007658#comment-17007658 ] Vladimir Sitnikov commented on CALCITE-3668: Please provide a use-case > V

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007655#comment-17007655 ] Haisheng Yuan commented on CALCITE-3668: I had seen the discussion. If a RelNod

[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: C

[jira] [Updated] (CALCITE-3673) ListTransientTable should not leave tables in the schema

2020-01-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3673: Labels: pull-request-available (was: ) > ListTransientTable should not leave tables in t

[jira] [Created] (CALCITE-3673) ListTransientTable should not leave tables in the schema

2020-01-03 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-3673: -- Summary: ListTransientTable should not leave tables in the schema Key: CALCITE-3673 URL: https://issues.apache.org/jira/browse/CALCITE-3673 Project: Calcit

[jira] [Updated] (CALCITE-3672) Support implicit type coercion for insert and update

2020-01-03 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3672: Labels: pull-request-available (was: ) > Support implicit type coercion for insert and u

[jira] [Created] (CALCITE-3672) Support implicit type coercion for insert and update

2020-01-03 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3672: --- Summary: Support implicit type coercion for insert and update Key: CALCITE-3672 URL: https://issues.apache.org/jira/browse/CALCITE-3672 Project: Calcite Issue

[jira] [Commented] (CALCITE-3657) EnumerableHashJoin should not use NLogN for costing

2020-01-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007326#comment-17007326 ] Ruben Q L commented on CALCITE-3657: Ok [~vladimirsitnikov], I have created CALCITE

[jira] [Created] (CALCITE-3671) Join cost computation should consider join condition (equi vs non-equi)

2020-01-03 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-3671: -- Summary: Join cost computation should consider join condition (equi vs non-equi) Key: CALCITE-3671 URL: https://issues.apache.org/jira/browse/CALCITE-3671 Project: Calcit

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

2020-01-03 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007316#comment-17007316 ] Feng Zhu commented on CALCITE-3670: --- Schema may be involved with resource, +1 for the

[jira] [Commented] (CALCITE-3668) VolcanoPlanner doesn't match all the RelSubSet in matchRecursive

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007315#comment-17007315 ] Vladimir Sitnikov commented on CALCITE-3668: Relevant discussion: https://

[jira] [Updated] (CALCITE-3654) Use single Elasticsearch instance for all elasticsearch tests

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-3654: --- Summary: Use single Elasticsearch instance for all elasticsearch tests (was: Elast

[jira] [Resolved] (CALCITE-3654) Use single Elasticsearch instance for all elasticsearch tests

2020-01-03 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov resolved CALCITE-3654. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in https://github.com/apach

[jira] [Closed] (CALCITE-3664) Sort in subquery is lost when converting SqlNode to Relnode

2020-01-03 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin closed CALCITE-3664. Resolution: Not A Problem > Sort in subquery is lost when converting SqlNode to Relnode > ---

[jira] [Commented] (CALCITE-3664) Sort in subquery is lost when converting SqlNode to Relnode

2020-01-03 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007306#comment-17007306 ] Wang Yanlin commented on CALCITE-3664: -- Thanks [~hyuan]  , now I got.  I'll just c

[jira] [Commented] (CALCITE-3669) logical plan optimizer test not correct

2020-01-03 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007303#comment-17007303 ] Feng Zhu commented on CALCITE-3669: --- Hi, [~jackylau], I update your description for t

[jira] [Updated] (CALCITE-3669) logical plan optimizer test not correct

2020-01-03 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu updated CALCITE-3669: -- Description: We can see test blow from RelOptRulesTest.java It validates for testEmptySort, but this

[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: Calc

[jira] [Created] (CALCITE-3669) logical plan optimizer test not correct

2020-01-03 Thread jackylau (Jira)
jackylau created CALCITE-3669: - Summary: logical plan optimizer test not correct Key: CALCITE-3669 URL: https://issues.apache.org/jira/browse/CALCITE-3669 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-3669) logical plan optimizer test not correct

2020-01-03 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17007288#comment-17007288 ] jackylau commented on CALCITE-3669: --- can this issue assigned to me? > logical plan o