[jira] [Commented] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

2019-03-24 Thread Muhammad Gelbana (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800105#comment-16800105 ] Muhammad Gelbana commented on CALCITE-2947: --- Yes it looks like it. I don't have a stacktrace

[jira] [Commented] (CALCITE-2944) Lack of test for Aggregate.indicator

2019-03-24 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800081#comment-16800081 ] Stamatis Zampetakis commented on CALCITE-2944: -- I am not sure if it is worth adding tests

[jira] [Closed] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-24 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis closed CALCITE-2948. Resolution: Duplicate Hey [~hyuan], I think this is a duplicate of CALCITE-1624.

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

2019-03-24 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800082#comment-16800082 ] Stamatis Zampetakis commented on CALCITE-2658: -- Hi [~Chunwei Lei], I still didn't find

[jira] [Commented] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

2019-03-24 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800083#comment-16800083 ] Stamatis Zampetakis commented on CALCITE-2947: -- Is this related to CALCITE-2901? What do

[jira] [Commented] (CALCITE-2940) CalcitePrepareImpl always creates a default SqlParser without user's CalciteConnectionConfig

2019-03-24 Thread Lai Zhou (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800095#comment-16800095 ] Lai Zhou commented on CALCITE-2940: --- Duplicate of [

[jira] [Updated] (CALCITE-2900) RelStructuredTypeFlattener generates wrong types on nested columns

2019-03-24 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-2900: - Summary: RelStructuredTypeFlattener generates wrong types on nested columns

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiaobo Liao updated CALCITE-2950: - Description: Kylin's JDBC

[jira] [Created] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
Xiaobo Liao created CALCITE-2950: Summary: Avatica DriverVersion.load leaks InputStream Key: CALCITE-2950 URL: https://issues.apache.org/jira/browse/CALCITE-2950 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2950: Labels: pull-request-available (was: ) > Avatica DriverVersion.load leaks InputStream >

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

2019-03-24 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800381#comment-16800381 ] Hongze Zhang commented on CALCITE-883: -- It would be great if anyone else could share some thoughts

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiaobo Liao updated CALCITE-2950: - Description: Kylin's JDBC

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiaobo Liao updated CALCITE-2950: - Description: Kylin's JDBC

[jira] [Comment Edited] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

2019-03-24 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800399#comment-16800399 ] Chunwei Lei edited comment on CALCITE-883 at 3/25/19 4:25 AM: --

[jira] [Comment Edited] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800186#comment-16800186 ] Julian Hyde edited comment on CALCITE-2208 at 3/24/19 10:21 PM: The

[jira] [Updated] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-2208: - Labels: (was: pull-request-available) > MaterializedViewTable.MATERIALIZATION_CONNECTION

[jira] [Commented] (CALCITE-2208) MaterializedViewTable.MATERIALIZATION_CONNECTION breaks lex and case sensitivity for end user

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800186#comment-16800186 ] Julian Hyde commented on CALCITE-2208: -- The author of 

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800191#comment-16800191 ] Julian Hyde commented on CALCITE-2948: -- I don't think it is a duplicate. NOT IN sub-queries are

[jira] [Closed] (CALCITE-2790) AggregateJoinTransposeRule incorrectly pushes down distinct count into join

2019-03-24 Thread Kevin Risden (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden closed CALCITE-2790. - > AggregateJoinTransposeRule incorrectly pushes down distinct count into join >

[jira] [Assigned] (CALCITE-2712) Add rule to remove null-generating side of a Join

2019-03-24 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2712: Assignee: Chunwei Lei > Add rule to remove null-generating side of a Join >

[jira] [Commented] (CALCITE-2936) Simplify EXISTS or NOT EXISTS sub-query that has "GROUP BY ()"

2019-03-24 Thread Danny Chan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800380#comment-16800380 ] Danny Chan commented on CALCITE-2936: - So the MinRowCount and MaxRowCount are all estimated but

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiaobo Liao updated CALCITE-2950: - Description: Kylin's JDBC

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiaobo Liao updated CALCITE-2950: - Attachment: stream_not_closed.png > Avatica DriverVersion.load leaks InputStream >

[jira] [Assigned] (CALCITE-2900) RelStructuredTypeFlattener generates wrong types on nested columns

2019-03-24 Thread Will Yu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Will Yu reassigned CALCITE-2900: Assignee: Will Yu > RelStructuredTypeFlattener generates wrong types on nested columns >

[jira] [Updated] (CALCITE-2950) Avatica DriverVersion.load leaks InputStream

2019-03-24 Thread Xiaobo Liao (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiaobo Liao updated CALCITE-2950: - Description: Kylin's JDBC

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

2019-03-24 Thread Chunwei Lei (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800399#comment-16800399 ] Chunwei Lei commented on CALCITE-883: - As far as I see, I am afraid that your proposal may can not 

[jira] [Closed] (CALCITE-2949) Double aggregate generated for in subquery with distinct

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2949. -- Resolution: Fixed > Double aggregate generated for in subquery with distinct >

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800140#comment-16800140 ] Haisheng Yuan commented on CALCITE-2948: I am not sure. Subquery unnesting is a big topic.

[jira] [Commented] (CALCITE-2944) Lack of test for Aggregate.indicator

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800190#comment-16800190 ] Haisheng Yuan commented on CALCITE-2944: Cool, nice to see it going. It has been used by us

[jira] [Commented] (CALCITE-2949) Double aggregate generated for in subquery with distinct

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800132#comment-16800132 ] Haisheng Yuan commented on CALCITE-2949: Agree. I just noticed that AggregateRemoveRule can

[jira] [Commented] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800154#comment-16800154 ] Haisheng Yuan commented on CALCITE-2947: Perhaps not the same issue. At least with your

[jira] [Reopened] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reopened CALCITE-2948: > SqlToRelConverter generates complicated logical plan for subquery >

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-24 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800209#comment-16800209 ] Haisheng Yuan commented on CALCITE-2948: It looks like the problem still exists. {code:java}

[jira] [Commented] (CALCITE-2949) Double aggregate generated for in subquery with distinct

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800133#comment-16800133 ] Julian Hyde commented on CALCITE-2949: -- Yes, close it. Perhaps add a `!plan` test case to

[jira] [Commented] (CALCITE-2712) Add rule to remove null-generating side of a Join

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800193#comment-16800193 ] Julian Hyde commented on CALCITE-2712: -- [~Chunwei Lei], Sure! > Add rule to remove

[jira] [Commented] (CALCITE-2944) Lack of test for Aggregate.indicator

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800187#comment-16800187 ] Julian Hyde commented on CALCITE-2944: -- Yes, let's remove it (it's been 2 years since we

[jira] [Commented] (CALCITE-2949) Double aggregate generated for in subquery with distinct

2019-03-24 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800131#comment-16800131 ] Julian Hyde commented on CALCITE-2949: -- I strongly believe that this should be fixed in a planner