[HIVE-15495] subquery's column alias can not be the same with partition column name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Component/s: Query Planning
• Assignee: Hui Fei
• Reporter: chenyukang
• Created: 22/Dec/16 04:24
• Updated: 14/Feb/17 02:56
• Resolved: 27/Dec/16 10:57

Description

case:
create table testkk5(a string) partitioned by(dt string);
alter table testkk5 add partition(dt="1");
hive> select * from (select a as dt from testkk5 where dt="1") t1 where t1.dt="2";
FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "t1:testkk5" Table "testkk5"

actually outer query's column `dt` is irrevelent with table `testkk5`'s partition column name

Issue Links

• is related to: HIVE-14705 Hive outer queries is not picking up the right column from subqueries
• is related to: HIVE-13602 TPCH q16 return wrong result when CBO is on
• relates to: HIVE-15888 constant propagation optimizer failed when query has the same alias with subquery