[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Issue Type: Sub-task (was: Task) Parent: HIVE-15456 > Use Calcite to de-correlate and plan

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-16 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-15192: Resolution: Fixed Fix Version/s: 2.2.0 Status: Resolved (was: Patch

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.10.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.9.patch Addressed review comments > Use Calcite to de-correlate and plan

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.8.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-10 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Description: HIVE currently tranform subqueries into SEMI-JOIN or LEFT OUTER JOIN. This

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-10 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) Fixed tests and added more > Use Calcite to de-correlate and

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-10 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.7.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-10 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-09 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.6.patch Updated subquery remove rule and de-correlation to support NOT IN

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-09 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-09 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.5.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.4.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.3.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: (was: HIVE-15192.3.patch) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) Know issue with this patch (HIVE-15192.3.patch) * Following

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.3.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-12-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Labels: sub-query (was: ) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.2.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: (was: HIVE-15192.2.patch) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.2.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: (was: HIVE-15192.2.patch) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.2.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: (was: HIVE-15192.2.patch) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: (was: HIVE-15192.2.patch) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.2.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-28 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: (was: HIVE-15192.2.patch) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.2.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Attachment: HIVE-15192.2.patch > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) Submitting same patch again to trigger pre-commit testing > Use

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Open (was: Patch Available) > Use Calcite to de-correlate and plan subqueries >

[jira] [Updated] (HIVE-15192) Use Calcite to de-correlate and plan subqueries

2016-11-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-15192: --- Status: Patch Available (was: Open) > Use Calcite to de-correlate and plan subqueries >