[jira] [Commented] (HIVE-7106) Predicates in where clause are not getting pushed beyond join for left outer joins

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

    [ 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)