hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From w...@apache.org
Subject [01/18] hive git commit: HIVE-14879 : integrate MM tables into ACID: replace MM metastore calls and structures with ACID ones (Wei Zheng)
Date Tue, 16 May 2017 22:53:06 GMT
Repository: hive
Updated Branches:
  refs/heads/hive-14535 1ceaf357b -> 77511070d


http://git-wip-us.apache.org/repos/asf/hive/blob/77511070/ql/src/test/results/clientpositive/mm_conversions.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mm_conversions.q.out b/ql/src/test/results/clientpositive/mm_conversions.q.out
index 2cfa06d..1610672 100644
--- a/ql/src/test/results/clientpositive/mm_conversions.q.out
+++ b/ql/src/test/results/clientpositive/mm_conversions.q.out
@@ -37,55 +37,55 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@intermediate@p=457
 POSTHOOK: Lineage: intermediate PARTITION(p=457).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: drop table simple_from_mm
+PREHOOK: query: drop table simple_from_mm1
 PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table simple_from_mm
+POSTHOOK: query: drop table simple_from_mm1
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table simple_from_mm(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: query: create table simple_from_mm1(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: create table simple_from_mm(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: Output: default@simple_from_mm1
+POSTHOOK: query: create table simple_from_mm1(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
-POSTHOOK: Output: default@simple_from_mm
-PREHOOK: query: insert into table simple_from_mm select key from intermediate
+POSTHOOK: Output: default@simple_from_mm1
+PREHOOK: query: insert into table simple_from_mm1 select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: Output: default@simple_from_mm1
+POSTHOOK: query: insert into table simple_from_mm1 select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@simple_from_mm
-POSTHOOK: Lineage: simple_from_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table simple_from_mm select key from intermediate
+POSTHOOK: Output: default@simple_from_mm1
+POSTHOOK: Lineage: simple_from_mm1.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: insert into table simple_from_mm1 select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: Output: default@simple_from_mm1
+POSTHOOK: query: insert into table simple_from_mm1 select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@simple_from_mm
-POSTHOOK: Lineage: simple_from_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from simple_from_mm s1 order by key
+POSTHOOK: Output: default@simple_from_mm1
+POSTHOOK: Lineage: simple_from_mm1.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from simple_from_mm1 s1 order by key
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
+PREHOOK: Input: default@simple_from_mm1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s1 order by key
+POSTHOOK: query: select * from simple_from_mm1 s1 order by key
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm1
 #### A masked pattern was here ####
 0
 0
@@ -93,21 +93,21 @@ POSTHOOK: Input: default@simple_from_mm
 98
 100
 100
-PREHOOK: query: alter table simple_from_mm unset tblproperties('transactional_properties', 'transactional')
+PREHOOK: query: alter table simple_from_mm1 unset tblproperties('transactional_properties', 'transactional')
 PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@simple_from_mm
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: alter table simple_from_mm unset tblproperties('transactional_properties', 'transactional')
+PREHOOK: Input: default@simple_from_mm1
+PREHOOK: Output: default@simple_from_mm1
+POSTHOOK: query: alter table simple_from_mm1 unset tblproperties('transactional_properties', 'transactional')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@simple_from_mm
-POSTHOOK: Output: default@simple_from_mm
-PREHOOK: query: select * from simple_from_mm s2 order by key
+POSTHOOK: Input: default@simple_from_mm1
+POSTHOOK: Output: default@simple_from_mm1
+PREHOOK: query: select * from simple_from_mm1 s2 order by key
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
+PREHOOK: Input: default@simple_from_mm1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s2 order by key
+POSTHOOK: query: select * from simple_from_mm1 s2 order by key
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm1
 #### A masked pattern was here ####
 0
 0
@@ -115,28 +115,28 @@ POSTHOOK: Input: default@simple_from_mm
 98
 100
 100
-PREHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: query: insert into table simple_from_mm1 select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: Output: default@simple_from_mm1
+POSTHOOK: query: insert into table simple_from_mm1 select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@simple_from_mm
-POSTHOOK: Lineage: simple_from_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from simple_from_mm s3 order by key
+POSTHOOK: Output: default@simple_from_mm1
+POSTHOOK: Lineage: simple_from_mm1.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from simple_from_mm1 s3 order by key
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
+PREHOOK: Input: default@simple_from_mm1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s3 order by key
+POSTHOOK: query: select * from simple_from_mm1 s3 order by key
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm1
 #### A masked pattern was here ####
 0
 0
@@ -147,140 +147,132 @@ POSTHOOK: Input: default@simple_from_mm
 100
 100
 100
-PREHOOK: query: alter table simple_from_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@simple_from_mm
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: alter table simple_from_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@simple_from_mm
-POSTHOOK: Output: default@simple_from_mm
-PREHOOK: query: select * from simple_from_mm s4 order by key
+PREHOOK: query: drop table simple_from_mm1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@simple_from_mm1
+PREHOOK: Output: default@simple_from_mm1
+POSTHOOK: query: drop table simple_from_mm1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@simple_from_mm1
+POSTHOOK: Output: default@simple_from_mm1
+PREHOOK: query: drop table simple_from_mm2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table simple_from_mm2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table simple_from_mm2(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@simple_from_mm2
+POSTHOOK: query: create table simple_from_mm2(key int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@simple_from_mm2
+PREHOOK: query: insert into table simple_from_mm2 select key from intermediate
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s4 order by key
+PREHOOK: Input: default@intermediate
+PREHOOK: Input: default@intermediate@p=455
+PREHOOK: Input: default@intermediate@p=456
+PREHOOK: Input: default@intermediate@p=457
+PREHOOK: Output: default@simple_from_mm2
+POSTHOOK: query: insert into table simple_from_mm2 select key from intermediate
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
-#### A masked pattern was here ####
-0
-0
-0
-98
-98
-98
-100
-100
-100
-PREHOOK: query: insert into table simple_from_mm select key from intermediate
+POSTHOOK: Input: default@intermediate
+POSTHOOK: Input: default@intermediate@p=455
+POSTHOOK: Input: default@intermediate@p=456
+POSTHOOK: Input: default@intermediate@p=457
+POSTHOOK: Output: default@simple_from_mm2
+POSTHOOK: Lineage: simple_from_mm2.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: insert into table simple_from_mm2 select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: Output: default@simple_from_mm2
+POSTHOOK: query: insert into table simple_from_mm2 select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@simple_from_mm
-POSTHOOK: Lineage: simple_from_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from simple_from_mm s5 order by key
+POSTHOOK: Output: default@simple_from_mm2
+POSTHOOK: Lineage: simple_from_mm2.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from simple_from_mm2 s1 order by key
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
+PREHOOK: Input: default@simple_from_mm2
 #### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s5 order by key
+POSTHOOK: query: select * from simple_from_mm2 s1 order by key
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm2
 #### A masked pattern was here ####
 0
 0
-0
-0
-98
-98
 98
 98
 100
 100
-100
-100
-PREHOOK: query: alter table simple_from_mm set tblproperties("transactional"="false", 'transactional_properties'='false')
+PREHOOK: query: alter table simple_from_mm2 set tblproperties("transactional"="false", 'transactional_properties'='false')
 PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@simple_from_mm
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: alter table simple_from_mm set tblproperties("transactional"="false", 'transactional_properties'='false')
+PREHOOK: Input: default@simple_from_mm2
+PREHOOK: Output: default@simple_from_mm2
+POSTHOOK: query: alter table simple_from_mm2 set tblproperties("transactional"="false", 'transactional_properties'='false')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@simple_from_mm
-POSTHOOK: Output: default@simple_from_mm
-PREHOOK: query: select * from simple_from_mm s6 order by key
+POSTHOOK: Input: default@simple_from_mm2
+POSTHOOK: Output: default@simple_from_mm2
+PREHOOK: query: select * from simple_from_mm2 s2 order by key
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
+PREHOOK: Input: default@simple_from_mm2
 #### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s6 order by key
+POSTHOOK: query: select * from simple_from_mm2 s2 order by key
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm2
 #### A masked pattern was here ####
 0
 0
-0
-0
 98
 98
-98
-98
-100
 100
 100
-100
-PREHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: query: insert into table simple_from_mm2 select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: insert into table simple_from_mm select key from intermediate
+PREHOOK: Output: default@simple_from_mm2
+POSTHOOK: query: insert into table simple_from_mm2 select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@simple_from_mm
-POSTHOOK: Lineage: simple_from_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from simple_from_mm s7 order by key
+POSTHOOK: Output: default@simple_from_mm2
+POSTHOOK: Lineage: simple_from_mm2.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from simple_from_mm2 s3 order by key
 PREHOOK: type: QUERY
-PREHOOK: Input: default@simple_from_mm
+PREHOOK: Input: default@simple_from_mm2
 #### A masked pattern was here ####
-POSTHOOK: query: select * from simple_from_mm s7 order by key
+POSTHOOK: query: select * from simple_from_mm2 s3 order by key
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm2
 #### A masked pattern was here ####
 0
 0
 0
-0
-0
-98
 98
 98
 98
-98
-100
 100
 100
 100
-100
-PREHOOK: query: drop table simple_from_mm
+PREHOOK: query: drop table simple_from_mm2
 PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@simple_from_mm
-PREHOOK: Output: default@simple_from_mm
-POSTHOOK: query: drop table simple_from_mm
+PREHOOK: Input: default@simple_from_mm2
+PREHOOK: Output: default@simple_from_mm2
+POSTHOOK: query: drop table simple_from_mm2
 POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@simple_from_mm
-POSTHOOK: Output: default@simple_from_mm
+POSTHOOK: Input: default@simple_from_mm2
+POSTHOOK: Output: default@simple_from_mm2
 PREHOOK: query: drop table simple_to_mm
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: drop table simple_to_mm
@@ -308,21 +300,6 @@ POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
 POSTHOOK: Output: default@simple_to_mm
 POSTHOOK: Lineage: simple_to_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table simple_to_mm select key from intermediate
-PREHOOK: type: QUERY
-PREHOOK: Input: default@intermediate
-PREHOOK: Input: default@intermediate@p=455
-PREHOOK: Input: default@intermediate@p=456
-PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@simple_to_mm
-POSTHOOK: query: insert into table simple_to_mm select key from intermediate
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@intermediate
-POSTHOOK: Input: default@intermediate@p=455
-POSTHOOK: Input: default@intermediate@p=456
-POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@simple_to_mm
-POSTHOOK: Lineage: simple_to_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
 PREHOOK: query: select * from simple_to_mm s1 order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@simple_to_mm
@@ -332,15 +309,13 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@simple_to_mm
 #### A masked pattern was here ####
 0
-0
-98
 98
 100
-100
 PREHOOK: query: alter table simple_to_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
 PREHOOK: type: ALTERTABLE_PROPERTIES
 PREHOOK: Input: default@simple_to_mm
 PREHOOK: Output: default@simple_to_mm
+FAILED: Error in acquiring locks: Transaction already opened. txnid:30
 POSTHOOK: query: alter table simple_to_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
 POSTHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: Input: default@simple_to_mm
@@ -354,11 +329,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@simple_to_mm
 #### A masked pattern was here ####
 0
-0
-98
 98
 100
-100
 PREHOOK: query: insert into table simple_to_mm select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
@@ -400,12 +372,9 @@ POSTHOOK: Input: default@simple_to_mm
 0
 0
 0
-0
 98
 98
 98
-98
-100
 100
 100
 100
@@ -417,74 +386,74 @@ POSTHOOK: query: drop table simple_to_mm
 POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@simple_to_mm
 POSTHOOK: Output: default@simple_to_mm
-PREHOOK: query: drop table part_from_mm
+PREHOOK: query: drop table part_from_mm1
 PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table part_from_mm
+POSTHOOK: query: drop table part_from_mm1
 POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table part_from_mm(key int) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: query: create table part_from_mm1(key int) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-PREHOOK: Output: default@part_from_mm
-POSTHOOK: query: create table part_from_mm(key int) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: Output: default@part_from_mm1
+POSTHOOK: query: create table part_from_mm1(key int) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
-POSTHOOK: Output: default@part_from_mm
-PREHOOK: query: insert into table part_from_mm partition(key_mm='455') select key from intermediate
+POSTHOOK: Output: default@part_from_mm1
+PREHOOK: query: insert into table part_from_mm1 partition(key_mm='455') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=455
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='455') select key from intermediate
+PREHOOK: Output: default@part_from_mm1@key_mm=455
+POSTHOOK: query: insert into table part_from_mm1 partition(key_mm='455') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=455
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table part_from_mm partition(key_mm='455') select key from intermediate
+POSTHOOK: Output: default@part_from_mm1@key_mm=455
+POSTHOOK: Lineage: part_from_mm1 PARTITION(key_mm=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: insert into table part_from_mm1 partition(key_mm='455') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=455
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='455') select key from intermediate
+PREHOOK: Output: default@part_from_mm1@key_mm=455
+POSTHOOK: query: insert into table part_from_mm1 partition(key_mm='455') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=455
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table part_from_mm partition(key_mm='456') select key from intermediate
+POSTHOOK: Output: default@part_from_mm1@key_mm=455
+POSTHOOK: Lineage: part_from_mm1 PARTITION(key_mm=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: insert into table part_from_mm1 partition(key_mm='456') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=456
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='456') select key from intermediate
+PREHOOK: Output: default@part_from_mm1@key_mm=456
+POSTHOOK: query: insert into table part_from_mm1 partition(key_mm='456') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=456
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from part_from_mm s1 order by key, key_mm
+POSTHOOK: Output: default@part_from_mm1@key_mm=456
+POSTHOOK: Lineage: part_from_mm1 PARTITION(key_mm=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from part_from_mm1 s1 order by key, key_mm
 PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
+PREHOOK: Input: default@part_from_mm1
+PREHOOK: Input: default@part_from_mm1@key_mm=455
+PREHOOK: Input: default@part_from_mm1@key_mm=456
 #### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s1 order by key, key_mm
+POSTHOOK: query: select * from part_from_mm1 s1 order by key, key_mm
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
+POSTHOOK: Input: default@part_from_mm1
+POSTHOOK: Input: default@part_from_mm1@key_mm=455
+POSTHOOK: Input: default@part_from_mm1@key_mm=456
 #### A masked pattern was here ####
 0	455
 0	455
@@ -495,25 +464,25 @@ POSTHOOK: Input: default@part_from_mm@key_mm=456
 100	455
 100	455
 100	456
-PREHOOK: query: alter table part_from_mm unset tblproperties('transactional_properties', 'transactional')
+PREHOOK: query: alter table part_from_mm1 unset tblproperties('transactional_properties', 'transactional')
 PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Output: default@part_from_mm
-POSTHOOK: query: alter table part_from_mm unset tblproperties('transactional_properties', 'transactional')
+PREHOOK: Input: default@part_from_mm1
+PREHOOK: Output: default@part_from_mm1
+POSTHOOK: query: alter table part_from_mm1 unset tblproperties('transactional_properties', 'transactional')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Output: default@part_from_mm
-PREHOOK: query: select * from part_from_mm s2 order by key, key_mm
+POSTHOOK: Input: default@part_from_mm1
+POSTHOOK: Output: default@part_from_mm1
+PREHOOK: query: select * from part_from_mm1 s2 order by key, key_mm
 PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
+PREHOOK: Input: default@part_from_mm1
+PREHOOK: Input: default@part_from_mm1@key_mm=455
+PREHOOK: Input: default@part_from_mm1@key_mm=456
 #### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s2 order by key, key_mm
+POSTHOOK: query: select * from part_from_mm1 s2 order by key, key_mm
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
+POSTHOOK: Input: default@part_from_mm1
+POSTHOOK: Input: default@part_from_mm1@key_mm=455
+POSTHOOK: Input: default@part_from_mm1@key_mm=456
 #### A masked pattern was here ####
 0	455
 0	455
@@ -524,49 +493,49 @@ POSTHOOK: Input: default@part_from_mm@key_mm=456
 100	455
 100	455
 100	456
-PREHOOK: query: insert into table part_from_mm partition(key_mm='456') select key from intermediate
+PREHOOK: query: insert into table part_from_mm1 partition(key_mm='456') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=456
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='456') select key from intermediate
+PREHOOK: Output: default@part_from_mm1@key_mm=456
+POSTHOOK: query: insert into table part_from_mm1 partition(key_mm='456') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=456
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table part_from_mm partition(key_mm='457') select key from intermediate
+POSTHOOK: Output: default@part_from_mm1@key_mm=456
+POSTHOOK: Lineage: part_from_mm1 PARTITION(key_mm=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: insert into table part_from_mm1 partition(key_mm='457') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=457
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='457') select key from intermediate
+PREHOOK: Output: default@part_from_mm1@key_mm=457
+POSTHOOK: query: insert into table part_from_mm1 partition(key_mm='457') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=457
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=457).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from part_from_mm s3 order by key, key_mm
+POSTHOOK: Output: default@part_from_mm1@key_mm=457
+POSTHOOK: Lineage: part_from_mm1 PARTITION(key_mm=457).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from part_from_mm1 s3 order by key, key_mm
 PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
-PREHOOK: Input: default@part_from_mm@key_mm=457
+PREHOOK: Input: default@part_from_mm1
+PREHOOK: Input: default@part_from_mm1@key_mm=455
+PREHOOK: Input: default@part_from_mm1@key_mm=456
+PREHOOK: Input: default@part_from_mm1@key_mm=457
 #### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s3 order by key, key_mm
+POSTHOOK: query: select * from part_from_mm1 s3 order by key, key_mm
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
-POSTHOOK: Input: default@part_from_mm@key_mm=457
+POSTHOOK: Input: default@part_from_mm1
+POSTHOOK: Input: default@part_from_mm1@key_mm=455
+POSTHOOK: Input: default@part_from_mm1@key_mm=456
+POSTHOOK: Input: default@part_from_mm1@key_mm=457
 #### A masked pattern was here ####
 0	455
 0	455
@@ -583,212 +552,148 @@ POSTHOOK: Input: default@part_from_mm@key_mm=457
 100	456
 100	456
 100	457
-PREHOOK: query: alter table part_from_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Output: default@part_from_mm
-POSTHOOK: query: alter table part_from_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Output: default@part_from_mm
-PREHOOK: query: select * from part_from_mm s4 order by key, key_mm
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
-PREHOOK: Input: default@part_from_mm@key_mm=457
-#### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s4 order by key, key_mm
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
-POSTHOOK: Input: default@part_from_mm@key_mm=457
-#### A masked pattern was here ####
-0	455
-0	455
-0	456
-0	456
-0	457
-98	455
-98	455
-98	456
-98	456
-98	457
-100	455
-100	455
-100	456
-100	456
-100	457
-PREHOOK: query: insert into table part_from_mm partition(key_mm='456') select key from intermediate
+PREHOOK: query: drop table part_from_mm1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@part_from_mm1
+PREHOOK: Output: default@part_from_mm1
+POSTHOOK: query: drop table part_from_mm1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@part_from_mm1
+POSTHOOK: Output: default@part_from_mm1
+PREHOOK: query: drop table part_from_mm2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table part_from_mm2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table part_from_mm2(key int) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_from_mm2
+POSTHOOK: query: create table part_from_mm2(key int) partitioned by (key_mm int) stored as orc tblproperties ("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_from_mm2
+PREHOOK: query: insert into table part_from_mm2 partition(key_mm='456') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=456
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='456') select key from intermediate
+PREHOOK: Output: default@part_from_mm2@key_mm=456
+POSTHOOK: query: insert into table part_from_mm2 partition(key_mm='456') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=456
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table part_from_mm partition(key_mm='455') select key from intermediate
+POSTHOOK: Output: default@part_from_mm2@key_mm=456
+POSTHOOK: Lineage: part_from_mm2 PARTITION(key_mm=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: --fails here
+insert into table part_from_mm2 partition(key_mm='455') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=455
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='455') select key from intermediate
+PREHOOK: Output: default@part_from_mm2@key_mm=455
+POSTHOOK: query: --fails here
+insert into table part_from_mm2 partition(key_mm='455') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=455
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from part_from_mm s5 order by key, key_mm
+POSTHOOK: Output: default@part_from_mm2@key_mm=455
+POSTHOOK: Lineage: part_from_mm2 PARTITION(key_mm=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from part_from_mm2 s1 order by key, key_mm
 PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
-PREHOOK: Input: default@part_from_mm@key_mm=457
+PREHOOK: Input: default@part_from_mm2
+PREHOOK: Input: default@part_from_mm2@key_mm=455
+PREHOOK: Input: default@part_from_mm2@key_mm=456
 #### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s5 order by key, key_mm
+POSTHOOK: query: select * from part_from_mm2 s1 order by key, key_mm
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
-POSTHOOK: Input: default@part_from_mm@key_mm=457
+POSTHOOK: Input: default@part_from_mm2
+POSTHOOK: Input: default@part_from_mm2@key_mm=455
+POSTHOOK: Input: default@part_from_mm2@key_mm=456
 #### A masked pattern was here ####
 0	455
-0	455
-0	455
-0	456
 0	456
-0	456
-0	457
 98	455
-98	455
-98	455
-98	456
-98	456
 98	456
-98	457
-100	455
-100	455
 100	455
 100	456
-100	456
-100	456
-100	457
-PREHOOK: query: alter table part_from_mm set tblproperties("transactional"="false", 'transactional_properties'='false')
+PREHOOK: query: alter table part_from_mm2 set tblproperties("transactional"="false", 'transactional_properties'='false')
 PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Output: default@part_from_mm
-POSTHOOK: query: alter table part_from_mm set tblproperties("transactional"="false", 'transactional_properties'='false')
+PREHOOK: Input: default@part_from_mm2
+PREHOOK: Output: default@part_from_mm2
+POSTHOOK: query: alter table part_from_mm2 set tblproperties("transactional"="false", 'transactional_properties'='false')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Output: default@part_from_mm
-PREHOOK: query: select * from part_from_mm s6 order by key, key_mm
+POSTHOOK: Input: default@part_from_mm2
+POSTHOOK: Output: default@part_from_mm2
+PREHOOK: query: select * from part_from_mm2 s2 order by key, key_mm
 PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
-PREHOOK: Input: default@part_from_mm@key_mm=457
+PREHOOK: Input: default@part_from_mm2
+PREHOOK: Input: default@part_from_mm2@key_mm=455
+PREHOOK: Input: default@part_from_mm2@key_mm=456
 #### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s6 order by key, key_mm
+POSTHOOK: query: select * from part_from_mm2 s2 order by key, key_mm
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
-POSTHOOK: Input: default@part_from_mm@key_mm=457
+POSTHOOK: Input: default@part_from_mm2
+POSTHOOK: Input: default@part_from_mm2@key_mm=455
+POSTHOOK: Input: default@part_from_mm2@key_mm=456
 #### A masked pattern was here ####
 0	455
-0	455
-0	455
-0	456
 0	456
-0	456
-0	457
-98	455
 98	455
-98	455
-98	456
 98	456
-98	456
-98	457
-100	455
-100	455
 100	455
 100	456
-100	456
-100	456
-100	457
-PREHOOK: query: insert into table part_from_mm partition(key_mm='457') select key from intermediate
+PREHOOK: query: insert into table part_from_mm2 partition(key_mm='457') select key from intermediate
 PREHOOK: type: QUERY
 PREHOOK: Input: default@intermediate
 PREHOOK: Input: default@intermediate@p=455
 PREHOOK: Input: default@intermediate@p=456
 PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: default@part_from_mm@key_mm=457
-POSTHOOK: query: insert into table part_from_mm partition(key_mm='457') select key from intermediate
+PREHOOK: Output: default@part_from_mm2@key_mm=457
+POSTHOOK: query: insert into table part_from_mm2 partition(key_mm='457') select key from intermediate
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@intermediate
 POSTHOOK: Input: default@intermediate@p=455
 POSTHOOK: Input: default@intermediate@p=456
 POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: default@part_from_mm@key_mm=457
-POSTHOOK: Lineage: part_from_mm PARTITION(key_mm=457).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from part_from_mm s7 order by key, key_mm
+POSTHOOK: Output: default@part_from_mm2@key_mm=457
+POSTHOOK: Lineage: part_from_mm2 PARTITION(key_mm=457).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: select * from part_from_mm2 s3 order by key, key_mm
 PREHOOK: type: QUERY
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Input: default@part_from_mm@key_mm=455
-PREHOOK: Input: default@part_from_mm@key_mm=456
-PREHOOK: Input: default@part_from_mm@key_mm=457
+PREHOOK: Input: default@part_from_mm2
+PREHOOK: Input: default@part_from_mm2@key_mm=455
+PREHOOK: Input: default@part_from_mm2@key_mm=456
+PREHOOK: Input: default@part_from_mm2@key_mm=457
 #### A masked pattern was here ####
-POSTHOOK: query: select * from part_from_mm s7 order by key, key_mm
+POSTHOOK: query: select * from part_from_mm2 s3 order by key, key_mm
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Input: default@part_from_mm@key_mm=455
-POSTHOOK: Input: default@part_from_mm@key_mm=456
-POSTHOOK: Input: default@part_from_mm@key_mm=457
+POSTHOOK: Input: default@part_from_mm2
+POSTHOOK: Input: default@part_from_mm2@key_mm=455
+POSTHOOK: Input: default@part_from_mm2@key_mm=456
+POSTHOOK: Input: default@part_from_mm2@key_mm=457
 #### A masked pattern was here ####
 0	455
-0	455
-0	455
-0	456
-0	456
 0	456
 0	457
-0	457
-98	455
 98	455
-98	455
-98	456
-98	456
 98	456
 98	457
-98	457
-100	455
 100	455
-100	455
-100	456
 100	456
-100	456
-100	457
 100	457
-PREHOOK: query: drop table part_from_mm
+PREHOOK: query: drop table part_from_mm2
 PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@part_from_mm
-PREHOOK: Output: default@part_from_mm
-POSTHOOK: query: drop table part_from_mm
+PREHOOK: Input: default@part_from_mm2
+PREHOOK: Output: default@part_from_mm2
+POSTHOOK: query: drop table part_from_mm2
 POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@part_from_mm
-POSTHOOK: Output: default@part_from_mm
+POSTHOOK: Input: default@part_from_mm2
+POSTHOOK: Output: default@part_from_mm2
 PREHOOK: query: drop table part_to_mm
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: drop table part_to_mm
@@ -853,6 +758,7 @@ PREHOOK: query: alter table part_to_mm set tblproperties("transactional"="true",
 PREHOOK: type: ALTERTABLE_PROPERTIES
 PREHOOK: Input: default@part_to_mm
 PREHOOK: Output: default@part_to_mm
+FAILED: Error in acquiring locks: Transaction already opened. txnid:63
 POSTHOOK: query: alter table part_to_mm set tblproperties("transactional"="true", "transactional_properties"="insert_only")
 POSTHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: Input: default@part_to_mm

http://git-wip-us.apache.org/repos/asf/hive/blob/77511070/ql/src/test/results/clientpositive/mm_exim.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mm_exim.q.out b/ql/src/test/results/clientpositive/mm_exim.q.out
new file mode 100644
index 0000000..6a6e549
--- /dev/null
+++ b/ql/src/test/results/clientpositive/mm_exim.q.out
@@ -0,0 +1,457 @@
+PREHOOK: query: drop table intermediate
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table intermediate
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table intermediate(key int) partitioned by (p int) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@intermediate
+POSTHOOK: query: create table intermediate(key int) partitioned by (p int) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@intermediate
+PREHOOK: query: insert into table intermediate partition(p='455') select distinct key from src where key >= 0 order by key desc limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@intermediate@p=455
+POSTHOOK: query: insert into table intermediate partition(p='455') select distinct key from src where key >= 0 order by key desc limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@intermediate@p=455
+POSTHOOK: Lineage: intermediate PARTITION(p=455).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+PREHOOK: query: insert into table intermediate partition(p='456') select distinct key from src where key is not null order by key asc limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@intermediate@p=456
+POSTHOOK: query: insert into table intermediate partition(p='456') select distinct key from src where key is not null order by key asc limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@intermediate@p=456
+POSTHOOK: Lineage: intermediate PARTITION(p=456).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+PREHOOK: query: insert into table intermediate partition(p='457') select distinct key from src where key >= 100 order by key asc limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@intermediate@p=457
+POSTHOOK: query: insert into table intermediate partition(p='457') select distinct key from src where key >= 100 order by key asc limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@intermediate@p=457
+POSTHOOK: Lineage: intermediate PARTITION(p=457).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+PREHOOK: query: drop table intermediate_nonpart
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table intermediate_nonpart
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table intermmediate_part
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table intermmediate_part
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table intermmediate_nonpart
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table intermmediate_nonpart
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table intermediate_nonpart(key int, p int)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@intermediate_nonpart
+POSTHOOK: query: create table intermediate_nonpart(key int, p int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@intermediate_nonpart
+PREHOOK: query: insert into intermediate_nonpart select * from intermediate
+PREHOOK: type: QUERY
+PREHOOK: Input: default@intermediate
+PREHOOK: Input: default@intermediate@p=455
+PREHOOK: Input: default@intermediate@p=456
+PREHOOK: Input: default@intermediate@p=457
+PREHOOK: Output: default@intermediate_nonpart
+POSTHOOK: query: insert into intermediate_nonpart select * from intermediate
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@intermediate
+POSTHOOK: Input: default@intermediate@p=455
+POSTHOOK: Input: default@intermediate@p=456
+POSTHOOK: Input: default@intermediate@p=457
+POSTHOOK: Output: default@intermediate_nonpart
+POSTHOOK: Lineage: intermediate_nonpart.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: intermediate_nonpart.p SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
+PREHOOK: query: create table intermmediate_nonpart(key int, p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@intermmediate_nonpart
+POSTHOOK: query: create table intermmediate_nonpart(key int, p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@intermmediate_nonpart
+PREHOOK: query: insert into intermmediate_nonpart select * from intermediate
+PREHOOK: type: QUERY
+PREHOOK: Input: default@intermediate
+PREHOOK: Input: default@intermediate@p=455
+PREHOOK: Input: default@intermediate@p=456
+PREHOOK: Input: default@intermediate@p=457
+PREHOOK: Output: default@intermmediate_nonpart
+POSTHOOK: query: insert into intermmediate_nonpart select * from intermediate
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@intermediate
+POSTHOOK: Input: default@intermediate@p=455
+POSTHOOK: Input: default@intermediate@p=456
+POSTHOOK: Input: default@intermediate@p=457
+POSTHOOK: Output: default@intermmediate_nonpart
+POSTHOOK: Lineage: intermmediate_nonpart.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: intermmediate_nonpart.p SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
+PREHOOK: query: create table intermmediate(key int) partitioned by (p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@intermmediate
+POSTHOOK: query: create table intermmediate(key int) partitioned by (p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@intermmediate
+PREHOOK: query: insert into table intermmediate partition(p) select key, p from intermediate
+PREHOOK: type: QUERY
+PREHOOK: Input: default@intermediate
+PREHOOK: Input: default@intermediate@p=455
+PREHOOK: Input: default@intermediate@p=456
+PREHOOK: Input: default@intermediate@p=457
+PREHOOK: Output: default@intermmediate
+POSTHOOK: query: insert into table intermmediate partition(p) select key, p from intermediate
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@intermediate
+POSTHOOK: Input: default@intermediate@p=455
+POSTHOOK: Input: default@intermediate@p=456
+POSTHOOK: Input: default@intermediate@p=457
+POSTHOOK: Output: default@intermmediate@p=455
+POSTHOOK: Output: default@intermmediate@p=456
+POSTHOOK: Output: default@intermmediate@p=457
+POSTHOOK: Lineage: intermmediate PARTITION(p=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: intermmediate PARTITION(p=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: intermmediate PARTITION(p=457).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
+PREHOOK: query: export table intermediate_nonpart to 'ql/test/data/exports/intermediate_nonpart'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@intermediate_nonpart
+#### A masked pattern was here ####
+POSTHOOK: query: export table intermediate_nonpart to 'ql/test/data/exports/intermediate_nonpart'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@intermediate_nonpart
+#### A masked pattern was here ####
+PREHOOK: query: export table intermmediate_nonpart to 'ql/test/data/exports/intermmediate_nonpart'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@intermmediate_nonpart
+#### A masked pattern was here ####
+POSTHOOK: query: export table intermmediate_nonpart to 'ql/test/data/exports/intermmediate_nonpart'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@intermmediate_nonpart
+#### A masked pattern was here ####
+PREHOOK: query: export table intermediate to 'ql/test/data/exports/intermediate_part'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@intermediate@p=455
+PREHOOK: Input: default@intermediate@p=456
+PREHOOK: Input: default@intermediate@p=457
+#### A masked pattern was here ####
+POSTHOOK: query: export table intermediate to 'ql/test/data/exports/intermediate_part'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@intermediate@p=455
+POSTHOOK: Input: default@intermediate@p=456
+POSTHOOK: Input: default@intermediate@p=457
+#### A masked pattern was here ####
+PREHOOK: query: export table intermmediate to 'ql/test/data/exports/intermmediate_part'
+PREHOOK: type: EXPORT
+PREHOOK: Input: default@intermmediate@p=455
+PREHOOK: Input: default@intermmediate@p=456
+PREHOOK: Input: default@intermmediate@p=457
+#### A masked pattern was here ####
+POSTHOOK: query: export table intermmediate to 'ql/test/data/exports/intermmediate_part'
+POSTHOOK: type: EXPORT
+POSTHOOK: Input: default@intermmediate@p=455
+POSTHOOK: Input: default@intermmediate@p=456
+POSTHOOK: Input: default@intermmediate@p=457
+#### A masked pattern was here ####
+PREHOOK: query: drop table intermediate_nonpart
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@intermediate_nonpart
+PREHOOK: Output: default@intermediate_nonpart
+POSTHOOK: query: drop table intermediate_nonpart
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@intermediate_nonpart
+POSTHOOK: Output: default@intermediate_nonpart
+PREHOOK: query: drop table intermmediate_part
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table intermmediate_part
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table intermmediate_nonpart
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@intermmediate_nonpart
+PREHOOK: Output: default@intermmediate_nonpart
+POSTHOOK: query: drop table intermmediate_nonpart
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@intermmediate_nonpart
+POSTHOOK: Output: default@intermmediate_nonpart
+PREHOOK: query: drop table import0_mm
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table import0_mm
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table import0_mm(key int, p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@import0_mm
+POSTHOOK: query: create table import0_mm(key int, p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@import0_mm
+PREHOOK: query: import table import0_mm from 'ql/test/data/exports/intermediate_nonpart'
+PREHOOK: type: IMPORT
+#### A masked pattern was here ####
+PREHOOK: Output: default@import0_mm
+POSTHOOK: query: import table import0_mm from 'ql/test/data/exports/intermediate_nonpart'
+POSTHOOK: type: IMPORT
+#### A masked pattern was here ####
+POSTHOOK: Output: default@import0_mm
+PREHOOK: query: select * from import0_mm order by key, p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@import0_mm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from import0_mm order by key, p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@import0_mm
+#### A masked pattern was here ####
+0	456
+10	456
+97	455
+98	455
+100	457
+103	457
+PREHOOK: query: drop table import0_mm
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@import0_mm
+PREHOOK: Output: default@import0_mm
+POSTHOOK: query: drop table import0_mm
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@import0_mm
+POSTHOOK: Output: default@import0_mm
+PREHOOK: query: drop table import1_mm
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table import1_mm
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table import1_mm(key int) partitioned by (p int)
+  stored as orc tblproperties("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@import1_mm
+POSTHOOK: query: create table import1_mm(key int) partitioned by (p int)
+  stored as orc tblproperties("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@import1_mm
+PREHOOK: query: import table import1_mm from 'ql/test/data/exports/intermediate_part'
+PREHOOK: type: IMPORT
+#### A masked pattern was here ####
+PREHOOK: Output: default@import1_mm
+POSTHOOK: query: import table import1_mm from 'ql/test/data/exports/intermediate_part'
+POSTHOOK: type: IMPORT
+#### A masked pattern was here ####
+POSTHOOK: Output: default@import1_mm
+POSTHOOK: Output: default@import1_mm@p=455
+POSTHOOK: Output: default@import1_mm@p=456
+POSTHOOK: Output: default@import1_mm@p=457
+PREHOOK: query: select * from import1_mm order by key, p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@import1_mm
+PREHOOK: Input: default@import1_mm@p=455
+PREHOOK: Input: default@import1_mm@p=456
+PREHOOK: Input: default@import1_mm@p=457
+#### A masked pattern was here ####
+POSTHOOK: query: select * from import1_mm order by key, p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@import1_mm
+POSTHOOK: Input: default@import1_mm@p=455
+POSTHOOK: Input: default@import1_mm@p=456
+POSTHOOK: Input: default@import1_mm@p=457
+#### A masked pattern was here ####
+0	456
+10	456
+97	455
+98	455
+100	457
+103	457
+PREHOOK: query: drop table import1_mm
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@import1_mm
+PREHOOK: Output: default@import1_mm
+POSTHOOK: query: drop table import1_mm
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@import1_mm
+POSTHOOK: Output: default@import1_mm
+PREHOOK: query: drop table import4_mm
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table import4_mm
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table import4_mm(key int, p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@import4_mm
+POSTHOOK: query: create table import4_mm(key int, p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@import4_mm
+PREHOOK: query: import table import4_mm from 'ql/test/data/exports/intermmediate_nonpart'
+PREHOOK: type: IMPORT
+#### A masked pattern was here ####
+PREHOOK: Output: default@import4_mm
+POSTHOOK: query: import table import4_mm from 'ql/test/data/exports/intermmediate_nonpart'
+POSTHOOK: type: IMPORT
+#### A masked pattern was here ####
+POSTHOOK: Output: default@import4_mm
+PREHOOK: query: select * from import4_mm order by key, p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@import4_mm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from import4_mm order by key, p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@import4_mm
+#### A masked pattern was here ####
+0	456
+10	456
+97	455
+98	455
+100	457
+103	457
+PREHOOK: query: drop table import4_mm
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@import4_mm
+PREHOOK: Output: default@import4_mm
+POSTHOOK: query: drop table import4_mm
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@import4_mm
+POSTHOOK: Output: default@import4_mm
+PREHOOK: query: drop table import5_mm
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table import5_mm
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table import5_mm(key int) partitioned by (p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@import5_mm
+POSTHOOK: query: create table import5_mm(key int) partitioned by (p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@import5_mm
+PREHOOK: query: import table import5_mm partition(p=455) from 'ql/test/data/exports/intermmediate_part'
+PREHOOK: type: IMPORT
+#### A masked pattern was here ####
+PREHOOK: Output: default@import5_mm
+POSTHOOK: query: import table import5_mm partition(p=455) from 'ql/test/data/exports/intermmediate_part'
+POSTHOOK: type: IMPORT
+#### A masked pattern was here ####
+POSTHOOK: Output: default@import5_mm
+POSTHOOK: Output: default@import5_mm@p=455
+PREHOOK: query: select * from import5_mm order by key, p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@import5_mm
+PREHOOK: Input: default@import5_mm@p=455
+#### A masked pattern was here ####
+POSTHOOK: query: select * from import5_mm order by key, p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@import5_mm
+POSTHOOK: Input: default@import5_mm@p=455
+#### A masked pattern was here ####
+97	455
+98	455
+PREHOOK: query: drop table import5_mm
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@import5_mm
+PREHOOK: Output: default@import5_mm
+POSTHOOK: query: drop table import5_mm
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@import5_mm
+POSTHOOK: Output: default@import5_mm
+PREHOOK: query: drop table import6_mm
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table import6_mm
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table import6_mm(key int, p int)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@import6_mm
+POSTHOOK: query: create table import6_mm(key int, p int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@import6_mm
+PREHOOK: query: import table import6_mm from 'ql/test/data/exports/intermmediate_nonpart'
+PREHOOK: type: IMPORT
+#### A masked pattern was here ####
+PREHOOK: Output: default@import6_mm
+POSTHOOK: query: import table import6_mm from 'ql/test/data/exports/intermmediate_nonpart'
+POSTHOOK: type: IMPORT
+#### A masked pattern was here ####
+POSTHOOK: Output: default@import6_mm
+PREHOOK: query: select * from import6_mm order by key, p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@import6_mm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from import6_mm order by key, p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@import6_mm
+#### A masked pattern was here ####
+0	456
+10	456
+97	455
+98	455
+100	457
+103	457
+PREHOOK: query: drop table import6_mm
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@import6_mm
+PREHOOK: Output: default@import6_mm
+POSTHOOK: query: drop table import6_mm
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@import6_mm
+POSTHOOK: Output: default@import6_mm
+PREHOOK: query: drop table import7_mm
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table import7_mm
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table import7_mm(key int) partitioned by (p int)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@import7_mm
+POSTHOOK: query: create table import7_mm(key int) partitioned by (p int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@import7_mm
+PREHOOK: query: import table import7_mm from 'ql/test/data/exports/intermmediate_part'
+PREHOOK: type: IMPORT
+#### A masked pattern was here ####
+PREHOOK: Output: default@import7_mm
+POSTHOOK: query: import table import7_mm from 'ql/test/data/exports/intermmediate_part'
+POSTHOOK: type: IMPORT
+#### A masked pattern was here ####
+POSTHOOK: Output: default@import7_mm
+POSTHOOK: Output: default@import7_mm@p=455
+POSTHOOK: Output: default@import7_mm@p=456
+POSTHOOK: Output: default@import7_mm@p=457
+PREHOOK: query: select * from import7_mm order by key, p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@import7_mm
+PREHOOK: Input: default@import7_mm@p=455
+PREHOOK: Input: default@import7_mm@p=456
+PREHOOK: Input: default@import7_mm@p=457
+#### A masked pattern was here ####
+POSTHOOK: query: select * from import7_mm order by key, p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@import7_mm
+POSTHOOK: Input: default@import7_mm@p=455
+POSTHOOK: Input: default@import7_mm@p=456
+POSTHOOK: Input: default@import7_mm@p=457
+#### A masked pattern was here ####
+0	456
+10	456
+97	455
+98	455
+100	457
+103	457
+PREHOOK: query: drop table import7_mm
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@import7_mm
+PREHOOK: Output: default@import7_mm
+POSTHOOK: query: drop table import7_mm
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@import7_mm
+POSTHOOK: Output: default@import7_mm

http://git-wip-us.apache.org/repos/asf/hive/blob/77511070/ql/src/test/results/clientpositive/mm_insertonly_acid.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mm_insertonly_acid.q.out b/ql/src/test/results/clientpositive/mm_insertonly_acid.q.out
deleted file mode 100644
index 22bdc93..0000000
--- a/ql/src/test/results/clientpositive/mm_insertonly_acid.q.out
+++ /dev/null
@@ -1,115 +0,0 @@
-PREHOOK: query: drop table qtr_acid
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table qtr_acid
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table qtr_acid (key int) partitioned by (p int) tblproperties ("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@qtr_acid
-POSTHOOK: query: create table qtr_acid (key int) partitioned by (p int) tblproperties ("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@qtr_acid
-PREHOOK: query: insert into table qtr_acid partition(p='123') select distinct key from src where key > 0 order by key asc limit 10
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@qtr_acid@p=123
-POSTHOOK: query: insert into table qtr_acid partition(p='123') select distinct key from src where key > 0 order by key asc limit 10
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@qtr_acid@p=123
-POSTHOOK: Lineage: qtr_acid PARTITION(p=123).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: insert into table qtr_acid partition(p='456') select distinct key from src where key > 0 order by key desc limit 10
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@qtr_acid@p=456
-POSTHOOK: query: insert into table qtr_acid partition(p='456') select distinct key from src where key > 0 order by key desc limit 10
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@qtr_acid@p=456
-POSTHOOK: Lineage: qtr_acid PARTITION(p=456).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-PREHOOK: query: explain
-select * from qtr_acid order by key
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select * from qtr_acid order by key
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: qtr_acid
-            Statistics: Num rows: 20 Data size: 47 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: key (type: int), p (type: int)
-              outputColumnNames: _col0, _col1
-              Statistics: Num rows: 20 Data size: 47 Basic stats: COMPLETE Column stats: NONE
-              Reduce Output Operator
-                key expressions: _col0 (type: int)
-                sort order: +
-                Statistics: Num rows: 20 Data size: 47 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int)
-          outputColumnNames: _col0, _col1
-          Statistics: Num rows: 20 Data size: 47 Basic stats: COMPLETE Column stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 20 Data size: 47 Basic stats: COMPLETE Column stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select * from qtr_acid order by key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@qtr_acid
-PREHOOK: Input: default@qtr_acid@p=123
-PREHOOK: Input: default@qtr_acid@p=456
-#### A masked pattern was here ####
-POSTHOOK: query: select * from qtr_acid order by key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@qtr_acid
-POSTHOOK: Input: default@qtr_acid@p=123
-POSTHOOK: Input: default@qtr_acid@p=456
-#### A masked pattern was here ####
-9	456
-10	123
-11	123
-85	456
-86	456
-87	456
-90	456
-92	456
-95	456
-96	456
-97	456
-98	456
-100	123
-103	123
-104	123
-105	123
-111	123
-113	123
-114	123
-116	123
-PREHOOK: query: drop table qtr_acid
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@qtr_acid
-PREHOOK: Output: default@qtr_acid
-POSTHOOK: query: drop table qtr_acid
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@qtr_acid
-POSTHOOK: Output: default@qtr_acid


Mime
View raw message