[jira] [Commented] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16955719#comment-16955719 ] jin xing commented on CALCITE-3428: --- Thanks a lot [~julianhyde] ~ I will refine the P

[jira] [Commented] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct on join keys

2019-10-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16955705#comment-16955705 ] jin xing commented on CALCITE-3431: --- Thanks for comment [~julianhyde] I updated the

[jira] [Updated] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct on join keys

2019-10-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3431: -- Summary: SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct on join keys (

[jira] [Updated] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is natural distinct on join keys

2019-10-19 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3431: -- Description: Calcite generate semi-join by SemiJoinRule, which only works on pattern of Join(RelNode

[jira] [Created] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is natural distinct on join keys

2019-10-19 Thread jin xing (Jira)
jin xing created CALCITE-3431: - Summary: SemiJoinRule doesn't work when right-hand side is natural distinct on join keys Key: CALCITE-3431 URL: https://issues.apache.org/jira/browse/CALCITE-3431 Project:

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select m

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select m

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select m

[jira] [Updated] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3428: -- Description: AggregateRemoveRule fails to remove the top Aggregate for below SQL {code:java} select m

[jira] [Created] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

2019-10-18 Thread jin xing (Jira)
jin xing created CALCITE-3428: - Summary: Refine RelMdColumnUniqueness for Filter by considering constant columns Key: CALCITE-3428 URL: https://issues.apache.org/jira/browse/CALCITE-3428 Project: Calcite

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-10-16 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16953355#comment-16953355 ] jin xing commented on CALCITE-3334: --- Thanks a lot for your shepherd [~julianhyde] ~

[jira] [Updated] (CALCITE-3399) Field-pruning for set operators (except UNION ALL) changes query semantics

2019-10-15 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3399: -- Summary: Field-pruning for set operators (except UNION ALL) changes query semantics (was: RelFieldTr

[jira] [Commented] (CALCITE-3399) RelFieldTrimmer trim fields for UNION, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL

2019-10-15 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16952472#comment-16952472 ] jin xing commented on CALCITE-3399: --- [~julianhyde] That would be much better ~ Than

[jira] [Assigned] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-10-15 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3334: - Assignee: jin xing > Refinement for Substitution-Based MV Matching > -

[jira] [Assigned] (CALCITE-3403) WindowReduceExpressionsRule does not reuse RelMetadataQuery

2019-10-15 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3403: - Assignee: jin xing > WindowReduceExpressionsRule does not reuse RelMetadataQuery > ---

[jira] [Updated] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2019-10-14 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3409: -- Description: In current code of MaterializedViewSubstitutionVisitor, all matching rules are internal

[jira] [Updated] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2019-10-14 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3409: -- Description: In current code of  > Add an interface in MaterializedViewSubstitutionVisitor to allow r

[jira] [Created] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

2019-10-14 Thread jin xing (Jira)
jin xing created CALCITE-3409: - Summary: Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule Key: CALCITE-3409 URL: https://issues.apache.org/jira/browse/CALCITE-3409 Pr

[jira] [Updated] (CALCITE-3405) Prune columns for ProjectableFilterableTable when project is not simple mapping

2019-10-12 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3405: -- Summary: Prune columns for ProjectableFilterableTable when project is not simple mapping (was: Prune

[jira] [Updated] (CALCITE-3405) Prune columns for ProjectableFilterableTable when Project is not simple mapping

2019-10-12 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3405: -- Summary: Prune columns for ProjectableFilterableTable when Project is not simple mapping (was: Prune

[jira] [Updated] (CALCITE-3405) Prune columns for ProjectableFilterable when project is not simple mapping

2019-10-11 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3405: -- Description: Say *beatles* is a *ProjectableFilterableTable*, below Sqls fail to do column pruning b

[jira] [Updated] (CALCITE-3405) Prune columns for ProjectableFilterable when project is not simple mapping

2019-10-11 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3405: -- Summary: Prune columns for ProjectableFilterable when project is not simple mapping (was: Pruning co

[jira] [Created] (CALCITE-3405) Pruning columns for ProjectableFilterable when project is not simple mapping

2019-10-11 Thread jin xing (Jira)
jin xing created CALCITE-3405: - Summary: Pruning columns for ProjectableFilterable when project is not simple mapping Key: CALCITE-3405 URL: https://issues.apache.org/jira/browse/CALCITE-3405 Project: Cal

[jira] [Updated] (CALCITE-3399) RelFieldTrimmer trim fields for UNION, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL

2019-10-10 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3399: -- Description: *RelFieldTrimmer#trimFields* provides functionality to trim fields for  *UNION, UNION A

[jira] [Created] (CALCITE-3399) RelFieldTrimmer trim fields for UNION, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL

2019-10-10 Thread jin xing (Jira)
jin xing created CALCITE-3399: - Summary: RelFieldTrimmer trim fields for UNION, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL Key: CALCITE-3399 URL: https://issues.apache.org/jira/browse/CALCITE-3399 Proje

[jira] [Updated] (CALCITE-3396) Materialization matching succeeds when query and view are both of UNION but have different 'all' property

2019-10-10 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3396: -- Description: {code:java} Materialized-View: select * from emps where empid < 300 union select * from

[jira] [Updated] (CALCITE-3396) Materialization matching succeeds when query and view are both of UNION but have different 'all' property

2019-10-10 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3396: -- Description:   {code:java} {code} *Materialized View:* {code:java} select * from emps where empid <

[jira] [Updated] (CALCITE-3396) Materialization matching succeeds when query and view are both of UNION but have different 'all' property

2019-10-10 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3396: -- Description: *Materialized View:* select * from emps where empid < 300 union  select * from emps w

[jira] [Closed] (CALCITE-2997) Avoid pushing down join condition in SqlToRelConverter

2019-10-10 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing closed CALCITE-2997. - Resolution: Invalid > Avoid pushing down join condition in SqlToRelConverter >

[jira] [Created] (CALCITE-3396) Materialization matching succeeds when query and view are both of UNION but have different 'all' property

2019-10-10 Thread jin xing (Jira)
jin xing created CALCITE-3396: - Summary: Materialization matching succeeds when query and view are both of UNION but have different 'all' property Key: CALCITE-3396 URL: https://issues.apache.org/jira/browse/CALCITE-3

[jira] [Comment Edited] (CALCITE-3390) ITEM expression does not get pushed to the right input of left-outer-join

2019-10-08 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946903#comment-16946903 ] jin xing edited comment on CALCITE-3390 at 10/8/19 1:52 PM:

[jira] [Commented] (CALCITE-3390) ITEM expression does not get pushed to the right input of left-outer-join

2019-10-08 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946903#comment-16946903 ] jin xing commented on CALCITE-3390: --- A test case for reproduction   {code:java} @Tes

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-10-08 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946650#comment-16946650 ] jin xing commented on CALCITE-3334: --- Hi [~hyuan] Thanks a lot for advice ~ I remove

[jira] [Comment Edited] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-10-08 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946625#comment-16946625 ] jin xing edited comment on CALCITE-3334 at 10/8/19 8:47 AM:

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-10-08 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946625#comment-16946625 ] jin xing commented on CALCITE-3334: --- Hi, Haisheng There are two strategies for mater

[jira] [Comment Edited] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-07 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946519#comment-16946519 ] jin xing edited comment on CALCITE-3379 at 10/8/19 6:08 AM:

[jira] [Commented] (CALCITE-3379) Support expand STRING column expression in table during sql-to-rel conversion

2019-10-07 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946519#comment-16946519 ] jin xing commented on CALCITE-3379: --- As Danny explained by the first point, I have on

[jira] [Issue Comment Deleted] (CALCITE-3378) AssertionError for checking RexNode implify

2019-09-29 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3378: -- Comment: was deleted (was: [~donnyzone]  FYI Is this related to CALCITE-3224 ?) > AssertionError fo

[jira] [Commented] (CALCITE-3378) AssertionError for checking RexNode implify

2019-09-29 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16940288#comment-16940288 ] jin xing commented on CALCITE-3378: --- [~donnyzone]  FYI Is this related to CALCITE-32

[jira] [Commented] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

2019-09-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16938226#comment-16938226 ] jin xing commented on CALCITE-3373: --- SemiJoinRule will also be kept as discussed in 

[jira] [Closed] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing closed CALCITE-3367. - Resolution: Duplicate > Add AntiJoinRule to convert project-filter-join-aggregate into anti-join >

[jira] [Commented] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16938204#comment-16938204 ] jin xing commented on CALCITE-3367: --- I will close this Jira for now. The reason is t

[jira] [Updated] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

2019-09-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3373: -- Description: The current approach to generate semi-join from IN/EXISTS is as below: # Decorrelation

[jira] [Created] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

2019-09-25 Thread jin xing (Jira)
jin xing created CALCITE-3373: - Summary: Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join Key: CALCITE-3373 URL: https://issues.apache.org/jira/browse/CALCITE-3373 Proje

[jira] [Updated] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

2019-09-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3373: -- Description: The current approach to generate semi-join from IN/EXISTS is as below: # Decorrelation

[jira] [Updated] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-23 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3367: -- Description: This Jira proposes to add AntiJoinRule to convert project-filter-join-aggregate into an

[jira] [Updated] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-23 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3367: -- Description: This Jira proposes to add AntiJoinRule to convert project-filter-join-aggregate into an

[jira] [Updated] (CALCITE-3366) RelDecorrelator supports Union

2019-09-23 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3366: -- Description: This issue proposes to support decorrelation for below sql {code:java} SELECT deptno FRO

[jira] [Updated] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-22 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3367: -- Description: This Jira proposes to add AntiJoinRule to convert project-filter-join-aggregate into ant

[jira] [Created] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

2019-09-22 Thread jin xing (Jira)
jin xing created CALCITE-3367: - Summary: Add AntiJoinRule to convert project-filter-join-aggregate into anti-join Key: CALCITE-3367 URL: https://issues.apache.org/jira/browse/CALCITE-3367 Project: Calcite

[jira] [Updated] (CALCITE-3366) RelDecorrelator supports Union

2019-09-22 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3366: -- Description: This issue proposes to support decorrelation for below sql {code:java} SELECT deptno FRO

[jira] [Created] (CALCITE-3366) RelDecorrelator supports Union

2019-09-22 Thread jin xing (Jira)
jin xing created CALCITE-3366: - Summary: RelDecorrelator supports Union Key: CALCITE-3366 URL: https://issues.apache.org/jira/browse/CALCITE-3366 Project: Calcite Issue Type: Improvement

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

2019-09-19 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1691#comment-1691 ] jin xing commented on CALCITE-3224: --- When you san – – "For each RexNode, the visitor

[jira] [Updated] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3363: -- Description: JoinUnionTransposeRule works by pull up union from below to top of join. Thus it should

[jira] [Comment Edited] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933093#comment-16933093 ] jin xing edited comment on CALCITE-3363 at 9/19/19 6:25 AM:

[jira] [Updated] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3363: -- Summary: JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join (was: JoinUnionTransposeRule.

[jira] [Commented] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933093#comment-16933093 ] jin xing commented on CALCITE-3363: --- Check my PR please; For sql like below: select

[jira] [Commented] (CALCITE-3353) ProjectJoinTransposeRule caused AssertionError when creating a new Join

2019-09-18 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933090#comment-16933090 ] jin xing commented on CALCITE-3353: --- [~danny0405] It sometime comes to me that it mi

[jira] [Created] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

2019-09-18 Thread jin xing (Jira)
jin xing created CALCITE-3363: - Summary: JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join Key: CALCITE-3363 URL: https://issues.apache.org/jira/browse/CALCITE-3363 Project: Calcite

[jira] [Updated] (CALCITE-3357) Trivial null checking in RelSet#addAbstractConverters

2019-09-17 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3357: -- Description: In current code of *RelSet#addAbstractConverters*, null checking of *curRelTrait* happe

[jira] [Updated] (CALCITE-3357) Trivial null checking in RelSet#addAbstractConverters

2019-09-17 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3357: -- Description: In current code of *RelSet#addAbstractConverters*, null checking of *curRelTrait* happe

[jira] [Created] (CALCITE-3357) Trivial null checking in RelSet#addAbstractConverters

2019-09-17 Thread jin xing (Jira)
jin xing created CALCITE-3357: - Summary: Trivial null checking in RelSet#addAbstractConverters Key: CALCITE-3357 URL: https://issues.apache.org/jira/browse/CALCITE-3357 Project: Calcite Issue Typ

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-16 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16930535#comment-16930535 ] jin xing commented on CALCITE-3334: --- Thanks for comment [~lishuming] I raised a PR a

[jira] [Comment Edited] (CALCITE-3338) Error with executeBatch and preparedStatement.

2019-09-12 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16928416#comment-16928416 ] jin xing edited comment on CALCITE-3338 at 9/12/19 9:55 AM:

[jira] [Commented] (CALCITE-3338) Error with executeBatch and preparedStatement.

2019-09-12 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16928416#comment-16928416 ] jin xing commented on CALCITE-3338: --- CodeGen as below: {code:java} // code placeholde

[jira] [Commented] (CALCITE-3338) Error with executeBatch and preparedStatement.

2019-09-12 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16928408#comment-16928408 ] jin xing commented on CALCITE-3338: --- Yes, the parameter values are not passed into *

[jira] [Comment Edited] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-11 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/11/19 9:46 AM:

[jira] [Commented] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

2019-09-10 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16926461#comment-16926461 ] jin xing commented on CALCITE-3332: --- Thanks ~ [~donnyzone] I left minor comments on

[jira] [Comment Edited] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/9/19 1:30 PM: --- I

[jira] [Comment Edited] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/9/19 1:30 PM: --- I

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16925686#comment-16925686 ] jin xing commented on CALCITE-3334: --- Really hope committers or any people who have in

[jira] [Updated] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3334: -- Description: The approach of substitution-based MV matching is an effective way for its simplicity a

[jira] [Comment Edited] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/9/19 1:05 PM: --- I

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16925666#comment-16925666 ] jin xing commented on CALCITE-3334: --- I have a commit to illustrate the idea shown in

[jira] [Updated] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3334: -- Description: The approach of substitution is an effective way for its simplicity and extensibility. 

[jira] [Updated] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3334: -- Description: The approach of substitution is an effective way for its simplicity and extensibility. 

[jira] [Created] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-09 Thread jin xing (Jira)
jin xing created CALCITE-3334: - Summary: Refinement for Substitution-Based MV Matching Key: CALCITE-3334 URL: https://issues.apache.org/jira/browse/CALCITE-3334 Project: Calcite Issue Type: Impro

[jira] [Commented] (CALCITE-2592) EnumerableMergeJoin is never taken

2019-09-02 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16921118#comment-16921118 ] jin xing commented on CALCITE-2592: --- [~vladimirsitnikov] I made a fix in [https://gi

[jira] [Commented] (CALCITE-3301) View test when it occur java.lang.AssertionError

2019-08-28 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917752#comment-16917752 ] jin xing commented on CALCITE-3301: --- Hi [~Water Cut Off] , Usually we talk about such

[jira] [Commented] (CALCITE-3292) SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate.

2019-08-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915492#comment-16915492 ] jin xing commented on CALCITE-3292: --- If I understand correctly, there's no need to do

[jira] [Updated] (CALCITE-3292) SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate.

2019-08-25 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3292: -- Description: Current code fails below test {code:java} // code placeholder @Test public void testUpda

[jira] [Created] (CALCITE-3292) SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate.

2019-08-25 Thread jin xing (Jira)
jin xing created CALCITE-3292: - Summary: SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate. Key: CALCITE-3292 URL: https://issues.apache.org/jira/browse/CALCITE-3292

[jira] [Assigned] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

2019-08-21 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3276: - Assignee: jin xing > Add MV rules to match Join on compensating Project(s) > -

[jira] [Updated] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

2019-08-21 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3276: -- Description: This issue proposes to handle cases where query and target are *Join*s and query has com

[jira] [Updated] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

2019-08-21 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3276: -- Description: This issue proposes to handle cases where query and target are {{MutableJoin}}s and quer

[jira] [Updated] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

2019-08-21 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3276: -- Description: This issue proposes to handle cases where query and target are {{MutableJoin}}s and quer

[jira] [Created] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

2019-08-21 Thread jin xing (Jira)
jin xing created CALCITE-3276: - Summary: Add MV rules to match Join on compensating Project(s) Key: CALCITE-3276 URL: https://issues.apache.org/jira/browse/CALCITE-3276 Project: Calcite Issue Typ

[jira] [Updated] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

2019-08-21 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3256: -- Priority: Major (was: Minor) > Add ProjectOnProjectToProjectUnifyRule for materialization matching.

[jira] [Commented] (CALCITE-3273) Materialization matching rules that consider compensating MutableProject

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16911945#comment-16911945 ] jin xing commented on CALCITE-3273: --- As far as I know, {{AggregateOnProjectToAggregat

[jira] [Assigned] (CALCITE-3274) Add FilterOnProjectToFilterUnifyRule for materialization matching

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3274: - Assignee: jin xing > Add FilterOnProjectToFilterUnifyRule for materialization matching > -

[jira] [Updated] (CALCITE-3274) Add FilterOnProjectToFilterUnifyRule for materialization matching

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3274: -- Description: With current implementation of MV matching, below case fails {code:java} @Test public

[jira] [Updated] (CALCITE-3274) Add FilterOnProjectToFilterUnifyRule for materialization matching

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3274: -- Description: With current implementation of MV matching, below case fails {code:java} @Test public

[jira] [Created] (CALCITE-3274) Add FilterOnProjectToFilterUnifyRule for materialization matching

2019-08-20 Thread jin xing (Jira)
jin xing created CALCITE-3274: - Summary: Add FilterOnProjectToFilterUnifyRule for materialization matching Key: CALCITE-3274 URL: https://issues.apache.org/jira/browse/CALCITE-3274 Project: Calcite

[jira] [Updated] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3256: -- Description: In current code, below matching fails: {code:java} MV: select deptno, sum(salary) + 2,

[jira] [Updated] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3256: -- Description: In current code, below matching fails: {code:java} MV: select deptno, sum(salary) + 2,

[jira] [Updated] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3256: -- Description: In current code, below matching fails: {code:java} MV: select deptno, sum(salary) + 2,

[jira] [Updated] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3256: -- Description: This issue proposes to add a rule to match a project {code:java} MV: select deptno, sum(

[jira] [Updated] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3256: -- Parent: CALCITE-3273 Issue Type: Sub-task (was: Improvement) > Add ProjectOnProjectToProject

[jira] [Updated] (CALCITE-3273) Materialization matching rules that consider compensating MutableProject

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3273: -- Description: In current implementation of rules in SubstitutionVisitor.java & MaterializedViewSubsti

[jira] [Created] (CALCITE-3273) Materialization matching rules that consider compensating MutableProject

2019-08-20 Thread jin xing (Jira)
jin xing created CALCITE-3273: - Summary: Materialization matching rules that consider compensating MutableProject Key: CALCITE-3273 URL: https://issues.apache.org/jira/browse/CALCITE-3273 Project: Calcite

<    1   2   3   4   >