predicate pushdown does not work correctly with outer joins -----------------------------------------------------------
Key: HIVE-1534 URL: https://issues.apache.org/jira/browse/HIVE-1534 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Amareshwari Sriramadasu The hive documentation for predicate pushdown says: Left outer join: predicates on the left side aliases are pushed Right outer join: predicates on the right side aliases are pushed But, this pushdown should not happen for AND predicates in join queries: ex: SELECT * FROM T1 JOIN T2 ON (T1.c1=T2.c2 AND T1.c1 < 10) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.