[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

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

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

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

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16119531#comment-16119531 ] Vlad Gudikov commented on HIVE-17148: - Uploaded new patch with fixed tests > Incorrect result for

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16119445#comment-16119445 ] Vlad Gudikov commented on HIVE-17148: - [~ashutoshc] today I will upload another patch with fixed

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16117886#comment-16117886 ] Ashutosh Chauhan commented on HIVE-17148: - +1 > Incorrect result for Hive join query with

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

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

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112242#comment-16112242 ] Vlad Gudikov commented on HIVE-17148: - Added patch with testcase > Incorrect result for Hive join

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107423#comment-16107423 ] Ashutosh Chauhan commented on HIVE-17148: - [~allgoodok] Can you add a testcase with your patch? >

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16104919#comment-16104919 ] Vlad Gudikov commented on HIVE-17148: - ROOT-CAUSE: The problem was with the predicates that were

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16104534#comment-16104534 ] Vlad Gudikov commented on HIVE-17148: - Related test failures are due to changes in the plan as we do

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

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

[jira] [Commented] (HIVE-17148) Incorrect result for Hive join query with COALESCE in WHERE condition

[ https://issues.apache.org/jira/browse/HIVE-17148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16096357#comment-16096357 ] Vlad Gudikov commented on HIVE-17148: - The thing is that while optimizing query HiveJoinAddNotRule