Steve Yeom created HIVE-19186:
---------------------------------
Summary: Multi Table INSERT statements query have a flaw for
partitioned table when INSERT INTO and INSERT OVERWRITE are used
Key: HIVE-19186
URL: https://issues.apache.org/jira/browse/HIVE-19186
Project: Hive
Issue Type: Bug
Components: Query Planning
Affects Versions: 3.0.0
Reporter: Steve Yeom
Fix For: 3.0.0
One problem test case is:
create table intermediate(key int) partitioned by (p int) stored as orc;
insert into table intermediate partition(p='455') select distinct key from src
where key >= 0 order by key desc limit 2;
insert into table intermediate partition(p='456') select distinct key from src
where key is not null order by key asc limit 2;
insert into table intermediate partition(p='457') select distinct key from src
where key >= 100 order by key asc limit 2;
from intermediate
insert into table multi_partitioned partition(p=2) select p, key
insert overwrite table multi_partitioned partition(p=1) select key, p;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
