[jira] [Updated] (CALCITE-3778) Include downstream SQL in EXPLAIN output

2020-02-11 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-3778: --- Summary: Include downstream SQL in EXPLAIN output (was: Provide ways to view the

[jira] [Commented] (CALCITE-3778) Provide ways to view the physical SQLs sent to database

2020-02-11 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035126#comment-17035126 ] Vladimir Sitnikov commented on CALCITE-3778: Calcite's explain should include downstream

[jira] [Updated] (CALCITE-3778) Provide ways to view the physical SQLs sent to database

2020-02-11 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-3778: --- Issue Type: New Feature (was: Wish) > Provide ways to view the physical SQLs sent

[jira] [Reopened] (CALCITE-3778) Provide ways to view the physical SQLs sent to database

2020-02-11 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov reopened CALCITE-3778: > Provide ways to view the physical SQLs sent to database >

[jira] [Commented] (CALCITE-2442) Cassandra unit test intermittent failures

2020-02-11 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035104#comment-17035104 ] Vladimir Sitnikov commented on CALCITE-2442: Gradle itself does not use {{.toDelete}} file,

[jira] [Closed] (CALCITE-3778) Provide ways to view the physical SQLs sent to database

2020-02-11 Thread jerryleooo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jerryleooo closed CALCITE-3778. --- Resolution: Fixed [~zabetak] thanks so much! Closing this issue to stop making the mail group

[jira] [Comment Edited] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Ravi Kapoor (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035034#comment-17035034 ] Ravi Kapoor edited comment on CALCITE-3784 at 2/12/20 4:22 AM: ---

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Ravi Kapoor (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035034#comment-17035034 ] Ravi Kapoor commented on CALCITE-3784: -- [~julianhyde] [~hyuan] It seems shocking to me as well

[jira] [Updated] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Ravi Kapoor (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ravi Kapoor updated CALCITE-3784: - Attachment: OOM Screenshot.png > RexCall toString digest gives OOM while huge expression is

[jira] [Commented] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-02-11 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035027#comment-17035027 ] Feng Zhu commented on CALCITE-3224: --- This patch does not cover the 64kb problem. But the new

[jira] [Commented] (CALCITE-3224) New RexNode-to-Expression CodeGen Implementation

2020-02-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035023#comment-17035023 ] Danny Chen commented on CALCITE-3224: - Can this patch solve the problem for generating methods with

[jira] [Commented] (CALCITE-3761) How to write a rule with optional intermediate operands?

2020-02-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035019#comment-17035019 ] Danny Chen commented on CALCITE-3761: - I mean for the intermediate operands, can you use the

[jira] [Comment Edited] (CALCITE-2442) Cassandra unit test intermittent failures

2020-02-11 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035012#comment-17035012 ] Feng Zhu edited comment on CALCITE-2442 at 2/12/20 3:11 AM: Unfortunately,

[jira] [Commented] (CALCITE-2442) Cassandra unit test intermittent failures

2020-02-11 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035012#comment-17035012 ] Feng Zhu commented on CALCITE-2442: --- Unfortunately, it does not work. I guess the file might be

[jira] [Commented] (CALCITE-3192) Simplification may weaken OR conditions containing inequalities

2020-02-11 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17035003#comment-17035003 ] Chunwei Lei commented on CALCITE-3192: -- Thanks [~julianhyde], [~hyuan]. What [~hyuan] said is

[jira] [Resolved] (CALCITE-3781) HintStrategy can specify excluded rules for planner

2020-02-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3781?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3781. - Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3769) Deprecate TableScanRule

2020-02-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034967#comment-17034967 ] Danny Chen commented on CALCITE-3769: - [~vladimirsitnikov] Do you have any other

[jira] [Updated] (CALCITE-3769) Deprecate TableScanRule

2020-02-11 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3769: Description: The TableScanRule is the only planner rule that for a logical node(e.g. the table

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034947#comment-17034947 ] Julian Hyde commented on CALCITE-3784: -- One thing we can do is not create left-deep expressions.

[jira] [Resolved] (CALCITE-3713) Remove column names from Project#digest

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3713. -- Resolution: Fixed Marking fixed, because it is fixed. Please create a new issue. Copy in

[jira] [Updated] (CALCITE-3785) HepPlanner.belongToDag() doesn't have to use mapDigestToVertex

2020-02-11 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3785: Labels: pull-request-available (was: ) > HepPlanner.belongToDag() doesn't have to use

[jira] [Reopened] (CALCITE-3713) Remove column names from Project#digest

2020-02-11 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiening Dai reopened CALCITE-3713: -- The fix incurs performance overhead when using mapDigestToVertex, mapDigestToRel, since now the

[jira] [Created] (CALCITE-3785) HepPlanner.belongToDag() doesn't have to use mapDigestToVertex

2020-02-11 Thread Xiening Dai (Jira)
Xiening Dai created CALCITE-3785: Summary: HepPlanner.belongToDag() doesn't have to use mapDigestToVertex Key: CALCITE-3785 URL: https://issues.apache.org/jira/browse/CALCITE-3785 Project: Calcite

[jira] [Commented] (CALCITE-2442) Cassandra unit test intermittent failures

2020-02-11 Thread Andrei Sereda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034898#comment-17034898 ] Andrei Sereda commented on CALCITE-2442: [~donnyzone] Can you pls try

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034864#comment-17034864 ] Haisheng Yuan commented on CALCITE-3784: Anyway, with current architecture, I don't think there

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034842#comment-17034842 ] Haisheng Yuan commented on CALCITE-3784: A filter condition with 10,000 expressions, would use

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034815#comment-17034815 ] Julian Hyde commented on CALCITE-3784: -- OK, I agree. If we have many copies of each expression,

[jira] [Commented] (CALCITE-3192) Simplification may weaken OR conditions containing inequalities

2020-02-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034748#comment-17034748 ] Haisheng Yuan commented on CALCITE-3192: If I understand it correctly, [~Chunwei Lei] is

[jira] [Commented] (CALCITE-3192) Simplification may weaken OR conditions containing inequalities

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034725#comment-17034725 ] Julian Hyde commented on CALCITE-3192: -- I'd do a truth table of a = (null, 0, 1, 2, 3, 4) and b =

[jira] [Comment Edited] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034717#comment-17034717 ] Haisheng Yuan edited comment on CALCITE-3784 at 2/11/20 6:53 PM: -

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034717#comment-17034717 ] Haisheng Yuan commented on CALCITE-3784: [~julianhyde] It is not surprising large rexcalls

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034689#comment-17034689 ] Haisheng Yuan commented on CALCITE-3784: unfortunately, the current design of Calcite can't

[jira] [Updated] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3784: - Description: I have some complex query which has tens of thousands of rex expressions and

[jira] [Commented] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034683#comment-17034683 ] Julian Hyde commented on CALCITE-3784: -- First thing you should do is consider whether you need

[jira] [Updated] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3784: - Description: I have some complex query which has tens of thousands of rex expressions and

[jira] [Commented] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034652#comment-17034652 ] Julian Hyde commented on CALCITE-3783: -- +1 The JIRA summary and commit message are a bit out of

[jira] [Updated] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3783: Labels: pull-request-available (was: ) > PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong

[jira] [Updated] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3783: --- Affects Version/s: 1.21.0 > PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for

[jira] [Commented] (CALCITE-3192) Simplification may weaken OR conditions containing inequalities

2020-02-11 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17034463#comment-17034463 ] Chunwei Lei commented on CALCITE-3192: -- Thank you for your clarification. What I am confused with

[jira] [Created] (CALCITE-3784) RexCall toString digest gives OOM while huge expression is evaluated

2020-02-11 Thread Ravi Kapoor (Jira)
Ravi Kapoor created CALCITE-3784: Summary: RexCall toString digest gives OOM while huge expression is evaluated Key: CALCITE-3784 URL: https://issues.apache.org/jira/browse/CALCITE-3784 Project:

[jira] [Updated] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3783: --- Description: The rule PruneEmptyRules#JOIN_RIGHT_INSTANCE "_converts a Join to empty if its right

[jira] [Updated] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3783: --- Description: {{PruneEmptyRules#JOIN_RIGHT_INSTANCE}} "_converts a Join to empty if its right

[jira] [Updated] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3783: --- Description: The rule PruneEmptyRules#JOIN_RIGHT_INSTANCE "_converts a Join to empty if its right

[jira] [Updated] (CALCITE-3783) PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI

2020-02-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3783: --- Summary: PruneEmptyRules#JOIN_RIGHT_INSTANCE wrong behavior for JoinRelType.ANTI (was: Rule to

[jira] [Updated] (CALCITE-3783) Rule to remove Join on top of empty Values

2020-02-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3783: --- Issue Type: Bug (was: Improvement) > Rule to remove Join on top of empty Values >

[jira] [Created] (CALCITE-3783) Rule to remove Join on top of empty Values

2020-02-11 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-3783: -- Summary: Rule to remove Join on top of empty Values Key: CALCITE-3783 URL: https://issues.apache.org/jira/browse/CALCITE-3783 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3782) Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type

2020-02-11 Thread hailong wang (Jira)
hailong wang created CALCITE-3782: - Summary: Bitwise operator Bit_And, Bit_OR and Bit_XOR support binary and varbinary type Key: CALCITE-3782 URL: https://issues.apache.org/jira/browse/CALCITE-3782

[jira] [Updated] (CALCITE-3779) Implement BITAND scalar function

2020-02-11 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3779: Labels: pull-request-available (was: ) > Implement BITAND scalar function >