[
https://issues.apache.org/jira/browse/HIVE-7106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14004956#comment-14004956
]
Ashutosh Chauhan commented on HIVE-7106:
----------------------------------------
This is easier to demonstrate via strict mode config which requires predicates
on partitioning columns to be specified for partitioned tables.
{code}
hive> create table t1 (a int, b string) partitioned by (c string);
hive> create table t2 (a int, b string) partitioned by (c string);
hive> set hive.mapred.mode=strict;
hive> explain select * from t1 left outer join t2 on t1.a = t2.a where t2.c =
'abc';
FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: No
partition predicate found for Alias "TS" Table "t2"
{code}
> Predicates in where clause are not getting pushed beyond join for left outer
> joins
> ----------------------------------------------------------------------------------
>
> Key: HIVE-7106
> URL: https://issues.apache.org/jira/browse/HIVE-7106
> Project: Hive
> Issue Type: Improvement
> Reporter: Ashutosh Chauhan
>
> Inner joins they indeed are getting pushed up.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
