[jira] [Commented] (CALCITE-3929) NullPointerException when deserialize UDAF aggregate call from json string

2020-04-15 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084535#comment-17084535 ] Wang Yanlin commented on CALCITE-3929: -- [~wojustme], OK, thanks for working on this. >

[jira] [Resolved] (CALCITE-3895) When the group sets of Aggregate is not null, union of its members should contain group key

2020-04-15 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu resolved CALCITE-3895. --- Resolution: Not A Problem > When the group sets of Aggregate is not null, union of its members

[jira] [Resolved] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

2020-04-15 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu resolved CALCITE-3893. --- Resolution: Not A Problem > SQL with GROUP_ID may generate wrong plan >

[jira] [Created] (CALCITE-3930) When converting Aggregate to SQL, add Having clause if a group key is not in group sets

2020-04-15 Thread Feng Zhu (Jira)
Feng Zhu created CALCITE-3930: - Summary: When converting Aggregate to SQL, add Having clause if a group key is not in group sets Key: CALCITE-3930 URL: https://issues.apache.org/jira/browse/CALCITE-3930

[jira] [Commented] (CALCITE-3928) Canonicalization doesn't do field trimming before materialized view matching

2020-04-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084527#comment-17084527 ] Danny Chen commented on CALCITE-3928: - The title is really hard to understand, maybe we can try to

[jira] [Commented] (CALCITE-3929) NullPointerException when deserialize UDAF aggregate call from json string

2020-04-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084525#comment-17084525 ] Danny Chen commented on CALCITE-3929: - Thanks [~wojustme] for engage in, you can send a mail to DEV

[jira] [Comment Edited] (CALCITE-3894) The Union operation between DATE with TIMESTAMP returns a wrong result

2020-04-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084520#comment-17084520 ] Danny Chen edited comment on CALCITE-3894 at 4/16/20, 4:10 AM: --- Finally i

[jira] [Updated] (CALCITE-3894) The Union operation between DATE with TIMESTAMP returns a wrong result

2020-04-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3894: Labels: pull-request-available (was: ) > The Union operation between DATE with

[jira] [Commented] (CALCITE-3894) The Union operation between DATE with TIMESTAMP returns a wrong result

2020-04-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084520#comment-17084520 ] Danny Chen commented on CALCITE-3894: - Finally i got the reason: The

[jira] [Commented] (CALCITE-3929) NullPointerException when deserialize UDAF aggregate call from json string

2020-04-15 Thread Xurenhe (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084517#comment-17084517 ] Xurenhe commented on CALCITE-3929: -- Hi [~yanlin-Lynn] I'm interested in this issue, can you arrange

[jira] [Assigned] (CALCITE-3929) NullPointerException when deserialize UDAF aggregate call from json string

2020-04-15 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3929: Assignee: Wang Yanlin > NullPointerException when deserialize UDAF aggregate call from

[jira] [Updated] (CALCITE-3928) Canonicalization doesn't do field trimming before materialized view matching

2020-04-15 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3928: -- Summary: Canonicalization doesn't do field trimming before materialized view matching (was:

[jira] [Created] (CALCITE-3929) NullPointerException when deserialize UDAF aggregate call from json string

2020-04-15 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3929: Summary: NullPointerException when deserialize UDAF aggregate call from json string Key: CALCITE-3929 URL: https://issues.apache.org/jira/browse/CALCITE-3929

[jira] [Updated] (CALCITE-3928) Canonicalization doesn't do field trimming before materialized matching

2020-04-15 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3928: -- Description: If we have query and materialized view as below: {code:java} query:

[jira] [Created] (CALCITE-3928) Canonicalization doesn't do field trimming before materialized matching

2020-04-15 Thread Jin Xing (Jira)
Jin Xing created CALCITE-3928: - Summary: Canonicalization doesn't do field trimming before materialized matching Key: CALCITE-3928 URL: https://issues.apache.org/jira/browse/CALCITE-3928 Project: Calcite

[jira] [Commented] (CALCITE-3927) RelSubset is not fired for rule when set gets merged

2020-04-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084366#comment-17084366 ] Haisheng Yuan commented on CALCITE-3927: That might be challenging. [~botong] Any easy case? >

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

2020-04-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084326#comment-17084326 ] Julian Hyde commented on CALCITE-3923: -- I have created a prototype in my

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

2020-04-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3923: Assignee: Julian Hyde > Refactor how planner rules are parameterized >

[jira] [Commented] (CALCITE-3927) RelSubset is not fired for rule when set gets merged

2020-04-15 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084302#comment-17084302 ] Xiening Dai commented on CALCITE-3927: -- Can we come up with a test case? Just try to assess the

[jira] [Updated] (CALCITE-3927) RelSubset is not fired for rule when set gets merged

2020-04-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3927: --- Description: In VolcanoPlanner, when set gets merged, planner fires rules again for

[jira] [Created] (CALCITE-3927) RelSubset is not fired for rule when set gets merged

2020-04-15 Thread Haisheng Yuan (Jira)
Haisheng Yuan created CALCITE-3927: -- Summary: RelSubset is not fired for rule when set gets merged Key: CALCITE-3927 URL: https://issues.apache.org/jira/browse/CALCITE-3927 Project: Calcite

[jira] [Commented] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084260#comment-17084260 ] Ruben Q L commented on CALCITE-3926: [~hyuan], I have submitted a PR, please take a look if you

[jira] [Updated] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3926: Labels: pull-request-available (was: ) > CannotPlanException when an empty

[jira] [Commented] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084254#comment-17084254 ] Haisheng Yuan commented on CALCITE-3926: Hi [~rubenql], same conclusion here. Please go ahead

[jira] [Commented] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084247#comment-17084247 ] Ruben Q L commented on CALCITE-3926: Thanks [~hyuan]. I might be able to provide a patch based on

[jira] [Updated] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3926: --- Attachment: (was: image-2020-04-15-11-14-41-581.png) > CannotPlanException when an

[jira] [Updated] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3926: --- Attachment: image-2020-04-15-11-14-41-581.png > CannotPlanException when an empty

[jira] [Commented] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084110#comment-17084110 ] Haisheng Yuan commented on CALCITE-3926: Thanks for reporting, I will take a look. >

[jira] [Updated] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3926: --- Description: The issue can be reproduced with the following test (in RelBuilderTest.java):

[jira] [Comment Edited] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084078#comment-17084078 ] Ruben Q L edited comment on CALCITE-3926 at 4/15/20, 1:25 PM: -- Note that:

[jira] [Comment Edited] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084078#comment-17084078 ] Ruben Q L edited comment on CALCITE-3926 at 4/15/20, 1:24 PM: -- {{Note

[jira] [Commented] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084078#comment-17084078 ] Ruben Q L commented on CALCITE-3926: Note that: if we remove PruneEmptyRules.SORT_INSTANCE from the

[jira] [Commented] (CALCITE-3925) Support materialized view matching for LogicalCorrelate in SubsitutionVisitor

2020-04-15 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084064#comment-17084064 ] Jin Xing commented on CALCITE-3925: --- Sure ~ You can refer to matching implementation for Join when

[jira] [Commented] (CALCITE-3925) Support materialized view matching for LogicalCorrelate in SubsitutionVisitor

2020-04-15 Thread xzh_dz (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17084063#comment-17084063 ] xzh_dz commented on CALCITE-3925: - Hi Jin~ I have much interest on this JIRA and want to work on it ~

[jira] [Updated] (CALCITE-3758) FilterTableScanRule generate wrong mapping for filter condition when underlying is BindableTableScan

2020-04-15 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3758: -- Description: When FilterTableScanRule push filter condition into ProjectableFilterableTable, the

[jira] [Created] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-04-15 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-3926: -- Summary: CannotPlanException when an empty LogicalValues requires a certain collation Key: CALCITE-3926 URL: https://issues.apache.org/jira/browse/CALCITE-3926 Project:

[jira] [Updated] (CALCITE-3925) Support materialized view matching for LogicalCorrelate in SubsitutionVisitor

2020-04-15 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3925: -- Description: LogicalCorrelate is widely used in user SQLs to performs nested-loop join.  We need to

[jira] [Updated] (CALCITE-3925) Support materialized view matching for LogicalCorrelate in SubsitutionVisitor

2020-04-15 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3925: -- Description: LogicalCorrelate is widely used in user SQLs to performs nested-loop join.  We need to

[jira] [Created] (CALCITE-3925) Support materialized view matching for LogicalCorrelate in SubsitutionVisitor

2020-04-15 Thread Jin Xing (Jira)
Jin Xing created CALCITE-3925: - Summary: Support materialized view matching for LogicalCorrelate in SubsitutionVisitor Key: CALCITE-3925 URL: https://issues.apache.org/jira/browse/CALCITE-3925 Project:

[jira] [Resolved] (CALCITE-3924) Fix flakey test to handle TIMESTAMP and TIMESTAMP(0) correctly

2020-04-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3924. - Fix Version/s: 1.23.0 Assignee: Danny Chen Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3881) SqlFunctions#addMonths yields incorrect results in some corner case

2020-04-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3881. - Fix Version/s: 1.23.0 Assignee: Danny Chen Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3910) Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin

2020-04-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3910: Labels: pull-request-available (was: ) > Enhance ProjectJoinTransposeRule to support