[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-11-15 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15669174#comment-15669174 ] Julian Hyde commented on CALCITE-1495: -- You can have a *physical* semi-join operator without having

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668955#comment-15668955 ] Vineet Garg commented on CALCITE-1495: -- Thanks Julian. I did not know that Calcite already has a

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-11-15 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668863#comment-15668863 ] Julian Hyde commented on CALCITE-1495: -- We already have SemiJoinRule. I'm a bit skeptical about

[jira] [Updated] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-1495: - Description: For IN and EXISTS subqueries Calcite currently generates plan consisting of GROUP

[jira] [Created] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-11-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1495: Summary: Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN Key: CALCITE-1495 URL: https://issues.apache.org/jira/browse/CALCITE-1495

[jira] [Commented] (CALCITE-1494) Inefficient plan for co-related subqueries

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668821#comment-15668821 ] Vineet Garg commented on CALCITE-1494: -- Note that Calcite seems to generate similar plan for

[jira] [Created] (CALCITE-1494) Inefficient plan for co-related subqueries

2016-11-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1494: Summary: Inefficient plan for co-related subqueries Key: CALCITE-1494 URL: https://issues.apache.org/jira/browse/CALCITE-1494 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-1493) Wrong plan for NOT IN correlated queries

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668787#comment-15668787 ] Vineet Garg edited comment on CALCITE-1493 at 11/15/16 11:55 PM: - Note

[jira] [Commented] (CALCITE-1493) Wrong plan for NOT IN correlated queries

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668787#comment-15668787 ] Vineet Garg commented on CALCITE-1493: -- Note that I had to hack RelOptTestBase's checkPlanning

[jira] [Updated] (CALCITE-1493) Wrong plan for NOT IN correlated queries

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-1493: - Description: Plan generated by calcite with SubqueryRemoveRule followed by de-correlation for

[jira] [Commented] (CALCITE-1483) Suboptimal plan for NOT IN query

2016-11-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668608#comment-15668608 ] Vineet Garg commented on CALCITE-1483: -- [~julianhyde] Following are few more examples where inner

[jira] [Commented] (CALCITE-1492) Table name with star is not supported.

2016-11-15 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15667877#comment-15667877 ] Julian Hyde commented on CALCITE-1492: -- As far as I know sql2 is valid and Calcite allows it. >

[jira] [Commented] (CALCITE-1492) Table name with star is not supported.

2016-11-15 Thread Dongming Liu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15667742#comment-15667742 ] Dongming Liu commented on CALCITE-1492: --- Sorry, my usage is incorrect. > Table name with star is

[jira] [Closed] (CALCITE-1492) Table name with star is not supported.

2016-11-15 Thread Dongming Liu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dongming Liu closed CALCITE-1492. - Resolution: Invalid > Table name with star is not supported. >

[jira] [Updated] (CALCITE-1491) Excel Adapter

2016-11-15 Thread Michael Mior (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Mior updated CALCITE-1491: -- Description: Build Excel Adapter for Apache calcite like CSV Adapter (was: Build Excel

[jira] [Updated] (CALCITE-1491) Excel Adaptor

2016-11-15 Thread Michael Mior (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Mior updated CALCITE-1491: -- Description: Build Excel Adaptor for Apache Calcite like CSV Adaptor (was: Build Excel

[jira] [Updated] (CALCITE-1491) Excel Adaptor

2016-11-15 Thread Michael Mior (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Mior updated CALCITE-1491: -- Summary: Excel Adaptor (was: Excel Adapter) > Excel Adaptor > - > >

[jira] [Created] (CALCITE-1492) Table name with star is not supported.

2016-11-15 Thread Dongming Liu (JIRA)
Dongming Liu created CALCITE-1492: - Summary: Table name with star is not supported. Key: CALCITE-1492 URL: https://issues.apache.org/jira/browse/CALCITE-1492 Project: Calcite Issue Type: Bug