[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-31 Thread Jacques (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17598219#comment-17598219 ] Jacques commented on HIVE-17342: other example with same query as per samples above: set

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-31 Thread Jacques (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17598213#comment-17598213 ] Jacques commented on HIVE-17342:  Can you please confirm in which  Hive version this is r

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17598180#comment-17598180 ] Krisztian Kasa commented on HIVE-17342: --- [~amansinha] Found that in some cases CBO

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Aman Sinha (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597947#comment-17597947 ] Aman Sinha commented on HIVE-17342: --- A slightly different example shows the limit 0 opt

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-30 Thread Krisztian Kasa (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597866#comment-17597866 ] Krisztian Kasa commented on HIVE-17342: --- This seems to be fixed on the master branc

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

2022-08-17 Thread Jacques (Jira)
[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17580663#comment-17580663 ] Jacques commented on HIVE-17342: I just want to add my support for this Jira. We have a s