You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by we...@apache.org on 2017/05/16 22:53:07 UTC
[02/18] hive git commit: HIVE-14879 : integrate MM tables into ACID:
replace MM metastore calls and structures with ACID ones (Wei Zheng)
http://git-wip-us.apache.org/repos/asf/hive/blob/77511070/ql/src/test/results/clientpositive/mm_all.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/mm_all.q.out b/ql/src/test/results/clientpositive/mm_all.q.out
index db5de69..71826df 100644
--- a/ql/src/test/results/clientpositive/mm_all.q.out
+++ b/ql/src/test/results/clientpositive/mm_all.q.out
@@ -82,6 +82,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
name: default.part_mm
+ Write Type: INSERT
Stage: Stage-7
Conditional Operator
@@ -288,21 +289,6 @@ POSTHOOK: Input: default@intermediate@p=456
POSTHOOK: Input: default@intermediate@p=457
POSTHOOK: Output: default@simple_mm
POSTHOOK: Lineage: simple_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert overwrite table simple_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_mm
-POSTHOOK: query: insert overwrite table simple_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_mm
-POSTHOOK: Lineage: simple_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
PREHOOK: query: select * from simple_mm order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@simple_mm
@@ -1236,473 +1222,6 @@ POSTHOOK: query: drop table merge1_mm
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@merge1_mm
POSTHOOK: Output: default@merge1_mm
-PREHOOK: query: drop table ctas0_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table ctas0_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table ctas0_mm tblproperties ("transactional"="true", "transactional_properties"="insert_only") as select * from intermediate
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@intermediate
-PREHOOK: Input: default@intermediate@p=455
-PREHOOK: Input: default@intermediate@p=456
-PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: database:default
-PREHOOK: Output: default@ctas0_mm
-POSTHOOK: query: create table ctas0_mm tblproperties ("transactional"="true", "transactional_properties"="insert_only") as select * from intermediate
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@intermediate
-POSTHOOK: Input: default@intermediate@p=455
-POSTHOOK: Input: default@intermediate@p=456
-POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@ctas0_mm
-POSTHOOK: Lineage: ctas0_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: ctas0_mm.p SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-PREHOOK: query: select * from ctas0_mm
-PREHOOK: type: QUERY
-PREHOOK: Input: default@ctas0_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from ctas0_mm
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@ctas0_mm
-#### A masked pattern was here ####
-98 455
-97 455
-0 456
-10 456
-100 457
-103 457
-PREHOOK: query: drop table ctas0_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@ctas0_mm
-PREHOOK: Output: default@ctas0_mm
-POSTHOOK: query: drop table ctas0_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@ctas0_mm
-POSTHOOK: Output: default@ctas0_mm
-PREHOOK: query: drop table ctas1_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table ctas1_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table ctas1_mm tblproperties ("transactional"="true", "transactional_properties"="insert_only") as
- select * from intermediate union all select * from intermediate
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@intermediate
-PREHOOK: Input: default@intermediate@p=455
-PREHOOK: Input: default@intermediate@p=456
-PREHOOK: Input: default@intermediate@p=457
-PREHOOK: Output: database:default
-PREHOOK: Output: default@ctas1_mm
-POSTHOOK: query: create table ctas1_mm tblproperties ("transactional"="true", "transactional_properties"="insert_only") as
- select * from intermediate union all select * from intermediate
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@intermediate
-POSTHOOK: Input: default@intermediate@p=455
-POSTHOOK: Input: default@intermediate@p=456
-POSTHOOK: Input: default@intermediate@p=457
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@ctas1_mm
-POSTHOOK: Lineage: ctas1_mm.key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: ctas1_mm.p EXPRESSION [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-PREHOOK: query: select * from ctas1_mm
-PREHOOK: type: QUERY
-PREHOOK: Input: default@ctas1_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from ctas1_mm
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@ctas1_mm
-#### A masked pattern was here ####
-98 455
-98 455
-97 455
-97 455
-0 456
-0 456
-10 456
-10 456
-100 457
-100 457
-103 457
-103 457
-PREHOOK: query: drop table ctas1_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@ctas1_mm
-PREHOOK: Output: default@ctas1_mm
-POSTHOOK: query: drop table ctas1_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@ctas1_mm
-POSTHOOK: Output: default@ctas1_mm
-PREHOOK: query: drop table iow0_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table iow0_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table iow0_mm(key int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@iow0_mm
-POSTHOOK: query: create table iow0_mm(key int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@iow0_mm
-PREHOOK: query: insert overwrite table iow0_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@iow0_mm
-POSTHOOK: query: insert overwrite table iow0_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@iow0_mm
-POSTHOOK: Lineage: iow0_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table iow0_mm select key + 1 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@iow0_mm
-POSTHOOK: query: insert into table iow0_mm select key + 1 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@iow0_mm
-POSTHOOK: Lineage: iow0_mm.key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from iow0_mm order by key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@iow0_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from iow0_mm order by key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@iow0_mm
-#### A masked pattern was here ####
-0
-1
-10
-11
-97
-98
-98
-99
-100
-101
-103
-104
-PREHOOK: query: insert overwrite table iow0_mm select key + 2 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@iow0_mm
-POSTHOOK: query: insert overwrite table iow0_mm select key + 2 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@iow0_mm
-POSTHOOK: Lineage: iow0_mm.key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from iow0_mm order by key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@iow0_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from iow0_mm order by key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@iow0_mm
-#### A masked pattern was here ####
-2
-12
-99
-100
-102
-105
-PREHOOK: query: drop table iow0_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@iow0_mm
-PREHOOK: Output: default@iow0_mm
-POSTHOOK: query: drop table iow0_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@iow0_mm
-POSTHOOK: Output: default@iow0_mm
-PREHOOK: query: drop table iow1_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table iow1_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table iow1_mm(key int) partitioned by (key2 int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@iow1_mm
-POSTHOOK: query: create table iow1_mm(key int) partitioned by (key2 int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@iow1_mm
-PREHOOK: query: insert overwrite table iow1_mm partition (key2)
-select key as k1, key from intermediate union all select key as k1, 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@iow1_mm
-POSTHOOK: query: insert overwrite table iow1_mm partition (key2)
-select key as k1, key from intermediate union all select key as k1, 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@iow1_mm@key2=0
-POSTHOOK: Output: default@iow1_mm@key2=10
-POSTHOOK: Output: default@iow1_mm@key2=100
-POSTHOOK: Output: default@iow1_mm@key2=103
-POSTHOOK: Output: default@iow1_mm@key2=97
-POSTHOOK: Output: default@iow1_mm@key2=98
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=0).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=100).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=103).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=10).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=97).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=98).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: insert into table iow1_mm partition (key2)
-select key + 1 as k1, key from intermediate union all select key as k1, 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@iow1_mm
-POSTHOOK: query: insert into table iow1_mm partition (key2)
-select key + 1 as k1, key from intermediate union all select key as k1, 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@iow1_mm@key2=0
-POSTHOOK: Output: default@iow1_mm@key2=10
-POSTHOOK: Output: default@iow1_mm@key2=100
-POSTHOOK: Output: default@iow1_mm@key2=103
-POSTHOOK: Output: default@iow1_mm@key2=97
-POSTHOOK: Output: default@iow1_mm@key2=98
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=0).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=100).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=103).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=10).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=97).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=98).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from iow1_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@iow1_mm
-PREHOOK: Input: default@iow1_mm@key2=0
-PREHOOK: Input: default@iow1_mm@key2=10
-PREHOOK: Input: default@iow1_mm@key2=100
-PREHOOK: Input: default@iow1_mm@key2=103
-PREHOOK: Input: default@iow1_mm@key2=97
-PREHOOK: Input: default@iow1_mm@key2=98
-#### A masked pattern was here ####
-POSTHOOK: query: select * from iow1_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@iow1_mm
-POSTHOOK: Input: default@iow1_mm@key2=0
-POSTHOOK: Input: default@iow1_mm@key2=10
-POSTHOOK: Input: default@iow1_mm@key2=100
-POSTHOOK: Input: default@iow1_mm@key2=103
-POSTHOOK: Input: default@iow1_mm@key2=97
-POSTHOOK: Input: default@iow1_mm@key2=98
-#### A masked pattern was here ####
-0 0
-0 0
-0 0
-1 0
-10 10
-10 10
-10 10
-11 10
-97 97
-97 97
-97 97
-98 97
-98 98
-98 98
-98 98
-99 98
-100 100
-100 100
-100 100
-101 100
-103 103
-103 103
-103 103
-104 103
-PREHOOK: query: 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
-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@iow1_mm
-POSTHOOK: query: 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
-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@iow1_mm@key2=0
-POSTHOOK: Output: default@iow1_mm@key2=10
-POSTHOOK: Output: default@iow1_mm@key2=100
-POSTHOOK: Output: default@iow1_mm@key2=103
-POSTHOOK: Output: default@iow1_mm@key2=97
-POSTHOOK: Output: default@iow1_mm@key2=98
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=0).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=100).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=103).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=10).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=97).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=98).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from iow1_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@iow1_mm
-PREHOOK: Input: default@iow1_mm@key2=0
-PREHOOK: Input: default@iow1_mm@key2=10
-PREHOOK: Input: default@iow1_mm@key2=100
-PREHOOK: Input: default@iow1_mm@key2=103
-PREHOOK: Input: default@iow1_mm@key2=97
-PREHOOK: Input: default@iow1_mm@key2=98
-#### A masked pattern was here ####
-POSTHOOK: query: select * from iow1_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@iow1_mm
-POSTHOOK: Input: default@iow1_mm@key2=0
-POSTHOOK: Input: default@iow1_mm@key2=10
-POSTHOOK: Input: default@iow1_mm@key2=100
-POSTHOOK: Input: default@iow1_mm@key2=103
-POSTHOOK: Input: default@iow1_mm@key2=97
-POSTHOOK: Input: default@iow1_mm@key2=98
-#### A masked pattern was here ####
-3 0
-4 0
-13 10
-14 10
-100 97
-101 97
-101 98
-102 98
-103 100
-104 100
-106 103
-107 103
-PREHOOK: query: 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
-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@iow1_mm
-POSTHOOK: query: 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
-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@iow1_mm@key2=100
-POSTHOOK: Output: default@iow1_mm@key2=101
-POSTHOOK: Output: default@iow1_mm@key2=102
-POSTHOOK: Output: default@iow1_mm@key2=103
-POSTHOOK: Output: default@iow1_mm@key2=105
-POSTHOOK: Output: default@iow1_mm@key2=106
-POSTHOOK: Output: default@iow1_mm@key2=12
-POSTHOOK: Output: default@iow1_mm@key2=13
-POSTHOOK: Output: default@iow1_mm@key2=2
-POSTHOOK: Output: default@iow1_mm@key2=3
-POSTHOOK: Output: default@iow1_mm@key2=99
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=100).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=101).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=102).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=103).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=105).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=106).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=12).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=13).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=2).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=3).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: iow1_mm PARTITION(key2=99).key EXPRESSION [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from iow1_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@iow1_mm
-PREHOOK: Input: default@iow1_mm@key2=0
-PREHOOK: Input: default@iow1_mm@key2=10
-PREHOOK: Input: default@iow1_mm@key2=100
-PREHOOK: Input: default@iow1_mm@key2=101
-PREHOOK: Input: default@iow1_mm@key2=102
-PREHOOK: Input: default@iow1_mm@key2=103
-PREHOOK: Input: default@iow1_mm@key2=105
-PREHOOK: Input: default@iow1_mm@key2=106
-PREHOOK: Input: default@iow1_mm@key2=12
-PREHOOK: Input: default@iow1_mm@key2=13
-PREHOOK: Input: default@iow1_mm@key2=2
-PREHOOK: Input: default@iow1_mm@key2=3
-PREHOOK: Input: default@iow1_mm@key2=97
-PREHOOK: Input: default@iow1_mm@key2=98
-PREHOOK: Input: default@iow1_mm@key2=99
-#### A masked pattern was here ####
-POSTHOOK: query: select * from iow1_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@iow1_mm
-POSTHOOK: Input: default@iow1_mm@key2=0
-POSTHOOK: Input: default@iow1_mm@key2=10
-POSTHOOK: Input: default@iow1_mm@key2=100
-POSTHOOK: Input: default@iow1_mm@key2=101
-POSTHOOK: Input: default@iow1_mm@key2=102
-POSTHOOK: Input: default@iow1_mm@key2=103
-POSTHOOK: Input: default@iow1_mm@key2=105
-POSTHOOK: Input: default@iow1_mm@key2=106
-POSTHOOK: Input: default@iow1_mm@key2=12
-POSTHOOK: Input: default@iow1_mm@key2=13
-POSTHOOK: Input: default@iow1_mm@key2=2
-POSTHOOK: Input: default@iow1_mm@key2=3
-POSTHOOK: Input: default@iow1_mm@key2=97
-POSTHOOK: Input: default@iow1_mm@key2=98
-POSTHOOK: Input: default@iow1_mm@key2=99
-#### A masked pattern was here ####
-2 2
-3 0
-3 3
-4 0
-12 12
-13 10
-13 13
-14 10
-99 99
-100 97
-100 100
-100 100
-101 97
-101 98
-101 101
-102 98
-102 102
-103 103
-105 105
-106 106
-PREHOOK: query: drop table iow1_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@iow1_mm
-PREHOOK: Output: default@iow1_mm
-POSTHOOK: query: drop table iow1_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@iow1_mm
-POSTHOOK: Output: default@iow1_mm
PREHOOK: query: drop table load0_mm
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table load0_mm
@@ -1765,7 +1284,7 @@ POSTHOOK: query: select count(1) from load0_mm
POSTHOOK: type: QUERY
POSTHOOK: Input: default@load0_mm
#### A masked pattern was here ####
-500
+1000
PREHOOK: query: drop table load0_mm
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@load0_mm
@@ -1916,7 +1435,7 @@ POSTHOOK: query: select count(1) from load1_mm
POSTHOOK: type: QUERY
POSTHOOK: Input: default@load1_mm
#### A masked pattern was here ####
-500
+1050
PREHOOK: query: drop table load1_mm
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@load1_mm
@@ -1999,1091 +1518,30 @@ POSTHOOK: query: drop table intermediate2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@intermediate2
POSTHOOK: Output: default@intermediate2
-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: query: drop table multi0_1_mm
PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table intermmediate_part
+POSTHOOK: query: drop table multi0_1_mm
POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table intermmediate_nonpart
+PREHOOK: query: drop table multi0_2_mm
PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table intermmediate_nonpart
+POSTHOOK: query: drop table multi0_2_mm
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: query: create table multi0_1_mm (key int, key2 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")
+PREHOOK: Output: default@multi0_1_mm
+POSTHOOK: query: create table multi0_1_mm (key int, key2 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")
+POSTHOOK: Output: default@multi0_1_mm
+PREHOOK: query: create table multi0_2_mm (key int, key2 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")
+PREHOOK: Output: default@multi0_2_mm
+POSTHOOK: query: create table multi0_2_mm (key int, key2 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
-PREHOOK: query: drop table multi0_1_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table multi0_1_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table multi0_2_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table multi0_2_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table multi0_1_mm (key int, key2 int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@multi0_1_mm
-POSTHOOK: query: create table multi0_1_mm (key int, key2 int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@multi0_1_mm
-PREHOOK: query: create table multi0_2_mm (key int, key2 int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@multi0_2_mm
-POSTHOOK: query: create table multi0_2_mm (key int, key2 int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@multi0_2_mm
-PREHOOK: query: from intermediate
-insert overwrite table multi0_1_mm select key, p
-insert overwrite table multi0_2_mm select p, key
-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@multi0_1_mm
-PREHOOK: Output: default@multi0_2_mm
-POSTHOOK: query: from intermediate
-insert overwrite table multi0_1_mm select key, p
-insert overwrite table multi0_2_mm select p, key
-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@multi0_1_mm
-POSTHOOK: Output: default@multi0_2_mm
-POSTHOOK: Lineage: multi0_1_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi0_1_mm.key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi0_2_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi0_2_mm.key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from multi0_1_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi0_1_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from multi0_1_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi0_1_mm
-#### A masked pattern was here ####
-0 456
-10 456
-97 455
-98 455
-100 457
-103 457
-PREHOOK: query: select * from multi0_2_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi0_2_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from multi0_2_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi0_2_mm
-#### A masked pattern was here ####
-455 97
-455 98
-456 0
-456 10
-457 100
-457 103
-PREHOOK: query: from intermediate
-insert into table multi0_1_mm select p, key
-insert overwrite table multi0_2_mm select key, p
-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@multi0_1_mm
-PREHOOK: Output: default@multi0_2_mm
-POSTHOOK: query: from intermediate
-insert into table multi0_1_mm select p, key
-insert overwrite table multi0_2_mm select key, p
-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@multi0_1_mm
POSTHOOK: Output: default@multi0_2_mm
-POSTHOOK: Lineage: multi0_1_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi0_1_mm.key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi0_2_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi0_2_mm.key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-PREHOOK: query: select * from multi0_1_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi0_1_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from multi0_1_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi0_1_mm
-#### A masked pattern was here ####
-0 456
-10 456
-97 455
-98 455
-100 457
-103 457
-455 97
-455 98
-456 0
-456 10
-457 100
-457 103
-PREHOOK: query: select * from multi0_2_mm order by key, key2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi0_2_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select * from multi0_2_mm order by key, key2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi0_2_mm
-#### A masked pattern was here ####
-0 456
-10 456
-97 455
-98 455
-100 457
-103 457
-PREHOOK: query: drop table multi0_1_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@multi0_1_mm
-PREHOOK: Output: default@multi0_1_mm
-POSTHOOK: query: drop table multi0_1_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@multi0_1_mm
-POSTHOOK: Output: default@multi0_1_mm
-PREHOOK: query: drop table multi0_2_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@multi0_2_mm
-PREHOOK: Output: default@multi0_2_mm
-POSTHOOK: query: drop table multi0_2_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@multi0_2_mm
-POSTHOOK: Output: default@multi0_2_mm
-PREHOOK: query: drop table multi1_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table multi1_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table multi1_mm (key int, key2 int) partitioned by (p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@multi1_mm
-POSTHOOK: query: create table multi1_mm (key int, key2 int) partitioned by (p int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@multi1_mm
-PREHOOK: query: from intermediate
-insert into table multi1_mm partition(p=1) select p, key
-insert into table multi1_mm partition(p=2) select key, p
-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@multi1_mm@p=1
-PREHOOK: Output: default@multi1_mm@p=2
-POSTHOOK: query: from intermediate
-insert into table multi1_mm partition(p=1) select p, key
-insert into table multi1_mm partition(p=2) select key, p
-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@multi1_mm@p=1
-POSTHOOK: Output: default@multi1_mm@p=2
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=2).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=2).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-PREHOOK: query: select * from multi1_mm order by key, key2, p
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi1_mm
-PREHOOK: Input: default@multi1_mm@p=1
-PREHOOK: Input: default@multi1_mm@p=2
-#### A masked pattern was here ####
-POSTHOOK: query: select * from multi1_mm order by key, key2, p
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi1_mm
-POSTHOOK: Input: default@multi1_mm@p=1
-POSTHOOK: Input: default@multi1_mm@p=2
-#### A masked pattern was here ####
-0 456 2
-10 456 2
-97 455 2
-98 455 2
-100 457 2
-103 457 2
-455 97 1
-455 98 1
-456 0 1
-456 10 1
-457 100 1
-457 103 1
-PREHOOK: query: from intermediate
-insert into table multi1_mm partition(p=2) select p, key
-insert overwrite table multi1_mm partition(p=1) select key, p
-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@multi1_mm@p=1
-PREHOOK: Output: default@multi1_mm@p=2
-POSTHOOK: query: from intermediate
-insert into table multi1_mm partition(p=2) select p, key
-insert overwrite table multi1_mm partition(p=1) select key, p
-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@multi1_mm@p=1
-POSTHOOK: Output: default@multi1_mm@p=2
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=2).key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=2).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select * from multi1_mm order by key, key2, p
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi1_mm
-PREHOOK: Input: default@multi1_mm@p=1
-PREHOOK: Input: default@multi1_mm@p=2
-#### A masked pattern was here ####
-POSTHOOK: query: select * from multi1_mm order by key, key2, p
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi1_mm
-POSTHOOK: Input: default@multi1_mm@p=1
-POSTHOOK: Input: default@multi1_mm@p=2
-#### A masked pattern was here ####
-0 456 1
-0 456 2
-10 456 1
-10 456 2
-97 455 1
-97 455 2
-98 455 1
-98 455 2
-100 457 1
-100 457 2
-103 457 1
-103 457 2
-455 97 1
-455 97 2
-455 98 1
-455 98 2
-456 0 1
-456 0 2
-456 10 1
-456 10 2
-457 100 1
-457 100 2
-457 103 1
-457 103 2
-PREHOOK: query: from intermediate
-insert into table multi1_mm partition(p) select p, key, p
-insert into table multi1_mm partition(p=1) select key, p
-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@multi1_mm
-PREHOOK: Output: default@multi1_mm@p=1
-POSTHOOK: query: from intermediate
-insert into table multi1_mm partition(p) select p, key, p
-insert into table multi1_mm partition(p=1) select key, p
-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@multi1_mm@p=1
-POSTHOOK: Output: default@multi1_mm@p=455
-POSTHOOK: Output: default@multi1_mm@p=456
-POSTHOOK: Output: default@multi1_mm@p=457
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=455).key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=455).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=456).key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=456).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=457).key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=457).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select key, key2, p from multi1_mm order by key, key2, p
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi1_mm
-PREHOOK: Input: default@multi1_mm@p=1
-PREHOOK: Input: default@multi1_mm@p=2
-PREHOOK: Input: default@multi1_mm@p=455
-PREHOOK: Input: default@multi1_mm@p=456
-PREHOOK: Input: default@multi1_mm@p=457
-#### A masked pattern was here ####
-POSTHOOK: query: select key, key2, p from multi1_mm order by key, key2, p
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi1_mm
-POSTHOOK: Input: default@multi1_mm@p=1
-POSTHOOK: Input: default@multi1_mm@p=2
-POSTHOOK: Input: default@multi1_mm@p=455
-POSTHOOK: Input: default@multi1_mm@p=456
-POSTHOOK: Input: default@multi1_mm@p=457
-#### A masked pattern was here ####
-0 456 1
-0 456 1
-0 456 2
-10 456 1
-10 456 1
-10 456 2
-97 455 1
-97 455 1
-97 455 2
-98 455 1
-98 455 1
-98 455 2
-100 457 1
-100 457 1
-100 457 2
-103 457 1
-103 457 1
-103 457 2
-455 97 1
-455 97 2
-455 97 455
-455 98 1
-455 98 2
-455 98 455
-456 0 1
-456 0 2
-456 0 456
-456 10 1
-456 10 2
-456 10 456
-457 100 1
-457 100 2
-457 100 457
-457 103 1
-457 103 2
-457 103 457
-PREHOOK: query: from intermediate
-insert into table multi1_mm partition(p) select p, key, 1
-insert into table multi1_mm partition(p=1) select key, p
-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@multi1_mm
-PREHOOK: Output: default@multi1_mm@p=1
-POSTHOOK: query: from intermediate
-insert into table multi1_mm partition(p) select p, key, 1
-insert into table multi1_mm partition(p=1) select key, p
-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@multi1_mm@p=1
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key SIMPLE [(intermediate)intermediate.FieldSchema(name:p, type:int, comment:null), ]
-POSTHOOK: Lineage: multi1_mm PARTITION(p=1).key2 SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: select key, key2, p from multi1_mm order by key, key2, p
-PREHOOK: type: QUERY
-PREHOOK: Input: default@multi1_mm
-PREHOOK: Input: default@multi1_mm@p=1
-PREHOOK: Input: default@multi1_mm@p=2
-PREHOOK: Input: default@multi1_mm@p=455
-PREHOOK: Input: default@multi1_mm@p=456
-PREHOOK: Input: default@multi1_mm@p=457
-#### A masked pattern was here ####
-POSTHOOK: query: select key, key2, p from multi1_mm order by key, key2, p
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@multi1_mm
-POSTHOOK: Input: default@multi1_mm@p=1
-POSTHOOK: Input: default@multi1_mm@p=2
-POSTHOOK: Input: default@multi1_mm@p=455
-POSTHOOK: Input: default@multi1_mm@p=456
-POSTHOOK: Input: default@multi1_mm@p=457
-#### A masked pattern was here ####
-0 456 1
-0 456 1
-0 456 1
-0 456 2
-10 456 1
-10 456 1
-10 456 1
-10 456 2
-97 455 1
-97 455 1
-97 455 1
-97 455 2
-98 455 1
-98 455 1
-98 455 1
-98 455 2
-100 457 1
-100 457 1
-100 457 1
-100 457 2
-103 457 1
-103 457 1
-103 457 1
-103 457 2
-455 97 1
-455 97 1
-455 97 2
-455 97 455
-455 98 1
-455 98 1
-455 98 2
-455 98 455
-456 0 1
-456 0 1
-456 0 2
-456 0 456
-456 10 1
-456 10 1
-456 10 2
-456 10 456
-457 100 1
-457 100 1
-457 100 2
-457 100 457
-457 103 1
-457 103 1
-457 103 2
-457 103 457
-PREHOOK: query: drop table multi1_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@multi1_mm
-PREHOOK: Output: default@multi1_mm
-POSTHOOK: query: drop table multi1_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@multi1_mm
-POSTHOOK: Output: default@multi1_mm
-PREHOOK: query: drop table stats_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table stats_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table stats_mm(key int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@stats_mm
-POSTHOOK: query: create table stats_mm(key int) tblproperties("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@stats_mm
-PREHOOK: query: insert overwrite table stats_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@stats_mm
-POSTHOOK: query: insert overwrite table stats_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@stats_mm
-POSTHOOK: Lineage: stats_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: desc formatted stats_mm
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@stats_mm
-POSTHOOK: query: desc formatted stats_mm
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@stats_mm
-# col_name data_type comment
-
-key int
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
- numFiles 1
- numRows 6
- rawDataSize 13
- totalSize 19
- transactional true
- transactional_properties insert_only
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: insert into table stats_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@stats_mm
-POSTHOOK: query: insert into table stats_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@stats_mm
-POSTHOOK: Lineage: stats_mm.key SIMPLE [(intermediate)intermediate.FieldSchema(name:key, type:int, comment:null), ]
-PREHOOK: query: desc formatted stats_mm
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@stats_mm
-POSTHOOK: query: desc formatted stats_mm
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@stats_mm
-# col_name data_type comment
-
-key int
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
- numFiles 2
- numRows 12
- rawDataSize 26
- totalSize 38
- transactional true
- transactional_properties insert_only
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: drop table stats_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@stats_mm
-PREHOOK: Output: default@stats_mm
-POSTHOOK: query: drop table stats_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@stats_mm
-POSTHOOK: Output: default@stats_mm
-PREHOOK: query: drop table stats2_mm
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table stats2_mm
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table stats2_mm tblproperties("transactional"="true", "transactional_properties"="insert_only") as select array(key, value) from src
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@src
-PREHOOK: Output: database:default
-PREHOOK: Output: default@stats2_mm
-POSTHOOK: query: create table stats2_mm tblproperties("transactional"="true", "transactional_properties"="insert_only") as select array(key, value) from src
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@src
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@stats2_mm
-POSTHOOK: Lineage: stats2_mm._c0 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: desc formatted stats2_mm
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@stats2_mm
-POSTHOOK: query: desc formatted stats2_mm
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@stats2_mm
-# col_name data_type comment
-
-_c0 array<string>
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
- numFiles 1
- numRows 500
- rawDataSize 5312
- totalSize 5812
- transactional true
- transactional_properties insert_only
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-InputFormat: org.apache.hadoop.mapred.TextInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: drop table stats2_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@stats2_mm
-PREHOOK: Output: default@stats2_mm
-POSTHOOK: query: drop table stats2_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@stats2_mm
-POSTHOOK: Output: default@stats2_mm
-PREHOOK: query: CREATE TABLE skewjoin_mm(key INT, value STRING) STORED AS TEXTFILE tblproperties ("transactional"="true", "transactional_properties"="insert_only")
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@skewjoin_mm
-POSTHOOK: query: CREATE TABLE skewjoin_mm(key INT, value STRING) STORED AS TEXTFILE tblproperties ("transactional"="true", "transactional_properties"="insert_only")
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@skewjoin_mm
-PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE skewjoin_mm SELECT src1.key, src2.value
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@skewjoin_mm
-POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) INSERT OVERWRITE TABLE skewjoin_mm SELECT src1.key, src2.value
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@skewjoin_mm
-POSTHOOK: Lineage: skewjoin_mm.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: skewjoin_mm.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select count(distinct key) from skewjoin_mm
-PREHOOK: type: QUERY
-PREHOOK: Input: default@skewjoin_mm
-#### A masked pattern was here ####
-POSTHOOK: query: select count(distinct key) from skewjoin_mm
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@skewjoin_mm
-#### A masked pattern was here ####
-309
-PREHOOK: query: drop table skewjoin_mm
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@skewjoin_mm
-PREHOOK: Output: default@skewjoin_mm
-POSTHOOK: query: drop table skewjoin_mm
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@skewjoin_mm
-POSTHOOK: Output: default@skewjoin_mm
PREHOOK: query: CREATE TABLE parquet1_mm(id INT) STORED AS PARQUET tblproperties ("transactional"="true", "transactional_properties"="insert_only")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default