hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-17856) MM tables - IOW is broken
Date Thu, 19 Oct 2017 23:08:00 GMT
Sergey Shelukhin created HIVE-17856:
---------------------------------------

             Summary: MM tables - IOW is broken
                 Key: HIVE-17856
                 URL: https://issues.apache.org/jira/browse/HIVE-17856
             Project: Hive
          Issue Type: Sub-task
            Reporter: Sergey Shelukhin


The following tests were removed from mm_all 
{noformat}
drop table iow0_mm;
create table iow0_mm(key int) tblproperties("transactional"="true", "transactional_properties"="insert_only");
insert overwrite table iow0_mm select key from intermediate;
insert into table iow0_mm select key + 1 from intermediate;
select * from iow0_mm order by key;
insert overwrite table iow0_mm select key + 2 from intermediate;
select * from iow0_mm order by key;
drop table iow0_mm;


drop table iow1_mm; 
create table iow1_mm(key int) partitioned by (key2 int)  tblproperties("transactional"="true",
"transactional_properties"="insert_only");
insert overwrite table iow1_mm partition (key2)
select key as k1, key from intermediate union all select key as k1, key from intermediate;
insert into table iow1_mm partition (key2)
select key + 1 as k1, key from intermediate union all select key as k1, key from intermediate;
select * from iow1_mm order by key, key2;
insert overwrite table iow1_mm partition (key2)
select key + 3 as k1, key from intermediate union all select key + 4 as k1, key from intermediate;
select * from iow1_mm order by key, key2;
insert overwrite table iow1_mm partition (key2)
select key + 3 as k1, key + 3 from intermediate union all select key + 2 as k1, key + 2 from
intermediate;
select * from iow1_mm order by key, key2;
drop table iow1_mm;
{noformat}

{noformat}
drop table simple_mm;
create table simple_mm(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only");
insert into table simple_mm select key from intermediate;
-insert overwrite table simple_mm select key from intermediate;
{noformat}





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message