[jira] [Commented] (CALCITE-3786) Add Digest interface to enable efficient hashCode(equals) for RexNode and RelNode

2020-06-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140958#comment-17140958 ] Haisheng Yuan commented on CALCITE-3786: OK, let me put it in another way. What if my Join and

[jira] [Comment Edited] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140952#comment-17140952 ] Zhixiong Chen edited comment on CALCITE-4074 at 6/20/20, 3:48 AM: -- Hi

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140952#comment-17140952 ] Zhixiong Chen commented on CALCITE-4074: Hi [~danny0405] The join condition I want is   T6.NUM

[jira] [Updated] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhixiong Chen updated CALCITE-4074: --- Description: sql:  {code:java} SELECT count(*) FROM t6 INNER JOIN t5 ON T6.NUM =

[jira] [Assigned] (CALCITE-4075) Mock table 'EMPNULLABLES' should allow nulls in all non-pk columns

2020-06-19 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-4075: Assignee: Stamatis Zampetakis > Mock table 'EMPNULLABLES' should allow

[jira] [Created] (CALCITE-4075) Mock table 'EMPNULLABLES' should allow nulls in all non-pk columns

2020-06-19 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-4075: Summary: Mock table 'EMPNULLABLES' should allow nulls in all non-pk columns Key: CALCITE-4075 URL: https://issues.apache.org/jira/browse/CALCITE-4075

[jira] [Commented] (CALCITE-4073) Add a new component RexNormalize for more effect rex nodes normalization

2020-06-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140810#comment-17140810 ] Haisheng Yuan commented on CALCITE-4073: I would refrain from adding new config params, and I

[jira] [Commented] (CALCITE-3923) Refactor how planner rules are parameterized

2020-06-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140762#comment-17140762 ] Julian Hyde commented on CALCITE-3923: -- {quote}Comparing the new approach, the older one seems

[jira] [Commented] (CALCITE-4071) Make RelNode Immutable

2020-06-19 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140751#comment-17140751 ] Haisheng Yuan commented on CALCITE-4071: lol. HepPlanner is indeed a tricky one, thanks for

[jira] [Commented] (CALCITE-3963) Maintain logical properties at RelSet (equivalent group) instead of RelNode

2020-06-19 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140741#comment-17140741 ] Xiening Dai commented on CALCITE-3963: -- {quote} For sets of predicates and unique keys, the

[jira] [Commented] (CALCITE-4073) Add a new component RexNormalize for more effect rex nodes normalization

2020-06-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140695#comment-17140695 ] Julian Hyde commented on CALCITE-4073: -- My intuition is that there is not 'one true normalization'

[jira] [Commented] (CALCITE-4071) Make RelNode Immutable

2020-06-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140691#comment-17140691 ] Julian Hyde commented on CALCITE-4071: -- [~hyuan] See if you can remove the current uses. Some uses

[jira] [Commented] (CALCITE-3907) CassandraSchema ignores username and password if no port is specified

2020-06-19 Thread Michael Mior (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140657#comment-17140657 ] Michael Mior commented on CALCITE-3907: --- Fixed in

[jira] [Resolved] (CALCITE-3907) CassandraSchema ignores username and password if no port is specified

2020-06-19 Thread Michael Mior (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Mior resolved CALCITE-3907. --- Resolution: Fixed > CassandraSchema ignores username and password if no port is specified

[jira] [Updated] (CALCITE-4008) Implement Code generation for EnumerableSortedAggregate

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4008: --- Labels: pull-request-available (was: ) > Implement Code generation for EnumerableSortedAggregate

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140551#comment-17140551 ] Stamatis Zampetakis commented on CALCITE-4074: -- I am not sure if it is fixed but I would

[jira] [Commented] (CALCITE-3094) Code of method grows beyond 64 KB

2020-06-19 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140508#comment-17140508 ] Thomas Rebele commented on CALCITE-3094: I would not apply a transformation to the generated

[jira] [Updated] (CALCITE-3094) Code of method grows beyond 64 KB

2020-06-19 Thread Thomas Rebele (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-3094: --- Attachment: CTE-3094.zip > Code of method grows beyond 64 KB >

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Zhixiong Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140404#comment-17140404 ] Zhixiong Chen commented on CALCITE-4074: Hi [~zabetak] , my calcite version is 1.16. Could you

[jira] [Commented] (CALCITE-2464) Allow to set nullability for columns of structured types

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140377#comment-17140377 ] Ruben Q L commented on CALCITE-2464: [~danny0405], I think your example cannot be considered as a

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140367#comment-17140367 ] Stamatis Zampetakis commented on CALCITE-4074: -- Hi [~Zhixiong Chen], the plan reminds me a

[jira] [Commented] (CALCITE-2464) Allow to set nullability for columns of structured types

2020-06-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140353#comment-17140353 ] Danny Chen commented on CALCITE-2464: - > If someone declares a column r ROW(x INT NOT NULL, y INT

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Labels: pull-request-available (was: ) > Support AntiJoin in EnumerableMergeJoin >

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Fix Version/s: 1.24.0 > Support AntiJoin in EnumerableMergeJoin >

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Description: Currently, {{EnumerableMergeJoin}} only supports INNER & SEMI joins. The goal of

[jira] [Updated] (CALCITE-3834) Support AntiJoin in EnumerableMergeJoin

2020-06-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3834: --- Description: Currently, {{EnumerableMergeJoin}} only supports INNER joins. The goal of this

[jira] [Commented] (CALCITE-4074) Wrong plan for IS NULL in join query

2020-06-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17140315#comment-17140315 ] Danny Chen commented on CALCITE-4074: - It seems the join condition you want is "is not distinct