[jira] [Created] (HIVE-19186) Multi Table INSERT statements query have a flaw for partitioned table when INSERT INTO and INSERT OVERWRITE are used

["Steve Yeom (JIRA)" <ji...@apache.org>]

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)