[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15853126#comment-15853126 ] Ashutosh Chauhan commented on HIVE-15458: - +1 > Fix semi-join conversion rule for subquery >

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15852735#comment-15852735 ] Hive QA commented on HIVE-15458: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15852517#comment-15852517 ] Vineet Garg commented on HIVE-15458: [~ashutoshc] Incorporated left join optimization in latest patch

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15852415#comment-15852415 ] Hive QA commented on HIVE-15458: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15852249#comment-15852249 ] Ashutosh Chauhan commented on HIVE-15458: - Patch looks good. I think we can also incorporate

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15852147#comment-15852147 ] Vineet Garg commented on HIVE-15458: As a fix we have decided to add a Project on top of Join in

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15850185#comment-15850185 ] Ashutosh Chauhan commented on HIVE-15458: - [~vgarg] Way to solve this is to output same AST from

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15849294#comment-15849294 ] Vineet Garg commented on HIVE-15458: cc [~ashutoshc] I tried with cbo off for following query

[jira] [Commented] (HIVE-15458) Fix semi-join conversion rule for subquery

[ https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15849292#comment-15849292 ] Vineet Garg commented on HIVE-15458: This is not really subquery issue. This is also reproducible with