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)