Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.1.0
-
None
-
None
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
Attachments
Issue Links
- is related to
-
HIVE-14705 Hive outer queries is not picking up the right column from subqueries
- Open
-
HIVE-13602 TPCH q16 return wrong result when CBO is on
- Closed
- relates to
-
HIVE-15888 constant propagation optimizer failed when query has the same alias with subquery
- Resolved