[ https://issues.apache.org/jira/browse/HIVE-7111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14187846#comment-14187846 ]
Navis commented on HIVE-7111: ----------------------------- bq. select * from src s1, src s2 where 1 = 2 and s1.value = s2.value; I'm expecting this will be archived when HIVE-8585 is once applied (confirmed the result after changing the order). Surely the constant folding can be done in PPD(in ExprWalkerProc), but it seemed redundant to do it again. bq. auto_join33.q Right. I've mistook it with HIVE-3315, which propagates predicates in join condition. I should change this with some query, fore example, {noformat} explain SELECT * FROM (SELECT a.key,b.value FROM src a join src b WHERE a.key+1=b.key+2) X where X.key+1 > 100; {noformat} > Extend join transitivity PPD to non-column expressions > ------------------------------------------------------ > > Key: HIVE-7111 > URL: https://issues.apache.org/jira/browse/HIVE-7111 > Project: Hive > Issue Type: Task > Components: Query Processor > Reporter: Navis > Assignee: Navis > Priority: Minor > Attachments: HIVE-7111.1.patch.txt, HIVE-7111.2.patch.txt, > HIVE-7111.2.patch.txt, HIVE-7111.3.patch.txt, HIVE-7111.4.patch.txt > > > Join transitive in PPD only supports column expressions, but it's possible to > extend this to generic expressions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)