[ https://issues.apache.org/jira/browse/HIVE-17856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Shelukhin updated HIVE-17856: ------------------------------------ Description: The following tests were removed from mm_all during "integration"... I should have never allowed such manner of intergration. MM logic should have been kept intact until ACID logic could catch up. Alas, here we are. {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} was: The following tests were removed from mm_all during "integration"... I should have never allowed such manner of intergration. MM logic should have been kept intact until ACID logic could catch up. Alas, here we are. Additionally multi-IOW tests may produce incorrect results. They were/are commented out in 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} > MM tables - IOW is broken > ------------------------- > > Key: HIVE-17856 > URL: https://issues.apache.org/jira/browse/HIVE-17856 > Project: Hive > Issue Type: Sub-task > Components: Transactions > Reporter: Sergey Shelukhin > Labels: mm-gap-1 > > The following tests were removed from mm_all during "integration"... I should > have never allowed such manner of intergration. > MM logic should have been kept intact until ACID logic could catch up. Alas, > here we are. > {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)