[jira] [Commented] (HIVE-24957) Wrong results when subquery has COALESCE in correlation predicate

2021-04-01 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17313012#comment-17313012 ] Stamatis Zampetakis commented on HIVE-24957: {quote}it seems to me that we could avoid this

[jira] [Commented] (HIVE-24957) Wrong results when subquery has COALESCE in correlation predicate

2021-04-01 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17312977#comment-17312977 ] Zoltan Haindrich commented on HIVE-24957: - I was wondering if changing the semijoin compare

[jira] [Commented] (HIVE-24957) Wrong results when subquery has COALESCE in correlation predicate

2021-03-30 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17311521#comment-17311521 ] Stamatis Zampetakis commented on HIVE-24957: The problem lies in the query plan and more