[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

[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

[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

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

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

[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

[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

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

[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

[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

[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

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

[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=16946903#comment-16946903 ] jin xing edited comment on CALCITE-3390 at 10/8/19 1:52 PM: A test case for

[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=16946903#comment-16946903 ] jin xing commented on CALCITE-3390: --- A test case for reproduction   {code:java} @Test public void

[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=16946650#comment-16946650 ] jin xing commented on CALCITE-3334: --- Hi [~hyuan] Thanks a lot for advice ~ I removed all unused and

[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=16946625#comment-16946625 ] jin xing edited comment on CALCITE-3334 at 10/8/19 8:47 AM: Hi, Haisheng

[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=16946625#comment-16946625 ] jin xing commented on CALCITE-3334: --- Hi, Haisheng There are two strategies for materialized view

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

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

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

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

[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

[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=16940288#comment-16940288 ] jin xing commented on CALCITE-3378: --- [~donnyzone]  FYI Is this related to CALCITE-3224 ? >

[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=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=16938204#comment-16938204 ] jin xing commented on CALCITE-3367: --- I will close this Jira for now. The reason is that  # A more

[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

[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-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-24 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

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

2019-09-24 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

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

2019-09-24 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

[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

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

[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

[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=1691#comment-1691 ] jin xing commented on CALCITE-3224: --- When you san – – "For each RexNode, the visitor will generally

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

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

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

2019-09-19 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] [Updated] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match ANTI Join

2019-09-19 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:

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

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

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

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

[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*

[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*

[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

[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=16930535#comment-16930535 ] jin xing commented on CALCITE-3334: --- Thanks for comment [~lishuming] I raised a PR as above and

[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=16928416#comment-16928416 ] jin xing edited comment on CALCITE-3338 at 9/12/19 9:55 AM: CodeGen as

[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=16928416#comment-16928416 ] jin xing commented on CALCITE-3338: --- CodeGen as below: {code:java} // code placeholder

[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=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=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/11/19 9:46 AM: I have a commit

[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=16926461#comment-16926461 ] jin xing commented on CALCITE-3332: --- Thanks ~ [~donnyzone] I left minor comments on the PR and

[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=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/9/19 1:30 PM: --- I have a commit

[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=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/9/19 1:30 PM: --- I have a commit

[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=16925686#comment-16925686 ] jin xing commented on CALCITE-3334: --- Really hope committers or any people who have interests to leave

[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

[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=16925666#comment-16925666 ] jin xing edited comment on CALCITE-3334 at 9/9/19 1:05 PM: --- I have a commit

[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=16925666#comment-16925666 ] jin xing commented on CALCITE-3334: --- I have a commit to illustrate the idea shown in the design doc:

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

[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=16921118#comment-16921118 ] jin xing commented on CALCITE-2592: --- [~vladimirsitnikov] I made a fix in 

[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=16917752#comment-16917752 ] jin xing commented on CALCITE-3301: --- Hi [~Water Cut Off] , Usually we talk about such issues on the

[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=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

[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

[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

[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

[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

[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=16911945#comment-16911945 ] jin xing commented on CALCITE-3273: --- As far as I know, {{AggregateOnProjectToAggregateUnifyRule}} is

[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

[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

[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,

[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

[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 &

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

[jira] [Resolved] (CALCITE-3167) Remove overriding equals and hashCode methods in EnumerableTableScan

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing resolved CALCITE-3167. --- Resolution: Fixed > Remove overriding equals and hashCode methods in EnumerableTableScan >

[jira] [Commented] (CALCITE-3167) Remove overriding equals and hashCode methods in EnumerableTableScan

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16911878#comment-16911878 ] jin xing commented on CALCITE-3167: --- Fixed in

[jira] [Commented] (CALCITE-3167) Remove overriding equals and hashCode methods in EnumerableTableScan

2019-08-20 Thread jin xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16911877#comment-16911877 ] jin xing commented on CALCITE-3167: --- [~julianhyde] Thanks a lot for merging ! > Remove overriding

[jira] [Created] (CALCITE-3262) Refine doc of SubstitutionVisitor.java

2019-08-18 Thread jin xing (JIRA)
jin xing created CALCITE-3262: - Summary: Refine doc of SubstitutionVisitor.java Key: CALCITE-3262 URL: https://issues.apache.org/jira/browse/CALCITE-3262 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-3262) Refine doc of SubstitutionVisitor.java

2019-08-18 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3262: -- Description: Current doc of {{SubstitutionVisitor.java}} says the supported core relational

[jira] [Assigned] (CALCITE-3226) RelBuilder doesn't keep the alias when scan from an expanded view

2019-08-16 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3226: - Assignee: jin xing > RelBuilder doesn't keep the alias when scan from an expanded view >

[jira] [Comment Edited] (CALCITE-3226) RelBuilder doesn't keep the alias when scan from an expanded view

2019-08-16 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16909567#comment-16909567 ] jin xing edited comment on CALCITE-3226 at 8/17/19 4:06 AM: Thanks a lot

[jira] [Commented] (CALCITE-3226) RelBuilder doesn't keep the alias when scan from an expanded view

2019-08-16 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16909567#comment-16909567 ] jin xing commented on CALCITE-3226: --- Thanks a lot for clarify [~rubenql] I think [~julianhyde]

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

2019-08-16 Thread jin xing (JIRA)
jin xing created CALCITE-3256: - Summary: Add ProjectOnProjectToProjectUnifyRule for materialization matching. Key: CALCITE-3256 URL: https://issues.apache.org/jira/browse/CALCITE-3256 Project: Calcite

[jira] [Updated] (CALCITE-3251) BinaryExpression evaluate method support Long type.

2019-08-14 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3251: -- Issue Type: Bug (was: Wish) > BinaryExpression evaluate method support Long type. >

[jira] [Assigned] (CALCITE-3251) BinaryExpression evaluate method support Long type.

2019-08-14 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3251: - Assignee: (was: jin xing) > BinaryExpression evaluate method support Long type. >

[jira] [Assigned] (CALCITE-3251) BinaryExpression evaluate method support Long type.

2019-08-14 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing reassigned CALCITE-3251: - Assignee: jin xing > BinaryExpression evaluate method support Long type. >

[jira] [Updated] (CALCITE-3249) Substitution#getRexShuttle does not consider RexLiteral

2019-08-14 Thread jin xing (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3249: -- Description: Current {{Substitution#getRexShuttle}} does not take {{RexLiteral}} into

  1   2   >