hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject [1/2] hive git commit: HIVE-11885: LLAP: Remove unused/old golden files (Prasanth Jayachandran)
Date Fri, 18 Sep 2015 18:24:09 GMT
Repository: hive
Updated Branches:
  refs/heads/llap 393bbd428 -> 9ddfc184d


http://git-wip-us.apache.org/repos/asf/hive/blob/9ddfc184/ql/src/test/results/clientpositive/tez/vector_outer_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vector_outer_join.q.out b/ql/src/test/results/clientpositive/tez/vector_outer_join.q.out
deleted file mode 100644
index 9691c48..0000000
--- a/ql/src/test/results/clientpositive/tez/vector_outer_join.q.out
+++ /dev/null
@@ -1,2204 +0,0 @@
-PREHOOK: query: CREATE TABLE orc_table_1(v1 STRING, a INT) STORED AS ORC
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@orc_table_1
-POSTHOOK: query: CREATE TABLE orc_table_1(v1 STRING, a INT) STORED AS ORC
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@orc_table_1
-PREHOOK: query: CREATE TABLE orc_table_2(c INT, v2 STRING) STORED AS ORC
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@orc_table_2
-POSTHOOK: query: CREATE TABLE orc_table_2(c INT, v2 STRING) STORED AS ORC
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@orc_table_2
-PREHOOK: query: insert into table orc_table_1 values ("<null1>", null),("one", 1),("one", 1),("two", 2),("three", 3),("<null2>", null)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@orc_table_1
-POSTHOOK: query: insert into table orc_table_1 values ("<null1>", null),("one", 1),("one", 1),("two", 2),("three", 3),("<null2>", null)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@orc_table_1
-POSTHOOK: Lineage: orc_table_1.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: orc_table_1.v1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-PREHOOK: query: insert into table orc_table_2 values (0, "ZERO"),(2, "TWO"), (3, "THREE"),(null, "<NULL1>"),(4, "FOUR"),(null, "<NULL2>")
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__2
-PREHOOK: Output: default@orc_table_2
-POSTHOOK: query: insert into table orc_table_2 values (0, "ZERO"),(2, "TWO"), (3, "THREE"),(null, "<NULL1>"),(4, "FOUR"),(null, "<NULL2>")
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__2
-POSTHOOK: Output: default@orc_table_2
-POSTHOOK: Lineage: orc_table_2.c EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: orc_table_2.v2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-PREHOOK: query: select * from orc_table_1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_table_1
-#### A masked pattern was here ####
-POSTHOOK: query: select * from orc_table_1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_table_1
-#### A masked pattern was here ####
-<null1>	NULL
-<null2>	NULL
-one	1
-one	1
-three	3
-two	2
-PREHOOK: query: select * from orc_table_2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_table_2
-#### A masked pattern was here ####
-POSTHOOK: query: select * from orc_table_2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_table_2
-#### A masked pattern was here ####
-0	ZERO
-2	TWO
-3	THREE
-4	FOUR
-NULL	<NULL1>
-NULL	<NULL2>
-PREHOOK: query: explain
-select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 left outer join orc_table_2 t2 on t1.a = t2.c
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 left outer join orc_table_2 t2 on t1.a = t2.c
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 2 (BROADCAST_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: t1
-                  Statistics: Num rows: 6 Data size: 544 Basic stats: COMPLETE Column stats: NONE
-                  Map Join Operator
-                    condition map:
-                         Left Outer Join0 to 1
-                    keys:
-                      0 a (type: int)
-                      1 c (type: int)
-                    outputColumnNames: _col0, _col1, _col5, _col6
-                    input vertices:
-                      1 Map 2
-                    Statistics: Num rows: 6 Data size: 598 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: _col0 (type: string), _col1 (type: int), _col5 (type: int), _col6 (type: string)
-                      outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 6 Data size: 598 Basic stats: COMPLETE Column stats: NONE
-                      File Output Operator
-                        compressed: false
-                        Statistics: Num rows: 6 Data size: 598 Basic stats: COMPLETE Column stats: NONE
-                        table:
-                            input format: org.apache.hadoop.mapred.TextInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-        Map 2 
-            Map Operator Tree:
-                TableScan
-                  alias: t2
-                  Statistics: Num rows: 6 Data size: 550 Basic stats: COMPLETE Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: c (type: int)
-                    sort order: +
-                    Map-reduce partition columns: c (type: int)
-                    Statistics: Num rows: 6 Data size: 550 Basic stats: COMPLETE Column stats: NONE
-                    value expressions: v2 (type: string)
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 left outer join orc_table_2 t2 on t1.a = t2.c
-PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_table_1
-PREHOOK: Input: default@orc_table_2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 left outer join orc_table_2 t2 on t1.a = t2.c
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_table_1
-POSTHOOK: Input: default@orc_table_2
-#### A masked pattern was here ####
-<null1>	NULL	NULL	NULL
-<null2>	NULL	NULL	NULL
-one	1	NULL	NULL
-one	1	NULL	NULL
-three	3	3	THREE
-two	2	2	TWO
-PREHOOK: query: explain
-select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 right outer join orc_table_2 t2 on t1.a = t2.c
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 right outer join orc_table_2 t2 on t1.a = t2.c
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 2 <- Map 1 (BROADCAST_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: t1
-                  Statistics: Num rows: 6 Data size: 544 Basic stats: COMPLETE Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: a (type: int)
-                    sort order: +
-                    Map-reduce partition columns: a (type: int)
-                    Statistics: Num rows: 6 Data size: 544 Basic stats: COMPLETE Column stats: NONE
-                    value expressions: v1 (type: string)
-            Execution mode: vectorized
-        Map 2 
-            Map Operator Tree:
-                TableScan
-                  alias: t2
-                  Statistics: Num rows: 6 Data size: 550 Basic stats: COMPLETE Column stats: NONE
-                  Map Join Operator
-                    condition map:
-                         Right Outer Join0 to 1
-                    keys:
-                      0 a (type: int)
-                      1 c (type: int)
-                    outputColumnNames: _col0, _col1, _col5, _col6
-                    input vertices:
-                      0 Map 1
-                    Statistics: Num rows: 6 Data size: 598 Basic stats: COMPLETE Column stats: NONE
-                    Select Operator
-                      expressions: _col0 (type: string), _col1 (type: int), _col5 (type: int), _col6 (type: string)
-                      outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 6 Data size: 598 Basic stats: COMPLETE Column stats: NONE
-                      File Output Operator
-                        compressed: false
-                        Statistics: Num rows: 6 Data size: 598 Basic stats: COMPLETE Column stats: NONE
-                        table:
-                            input format: org.apache.hadoop.mapred.TextInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 right outer join orc_table_2 t2 on t1.a = t2.c
-PREHOOK: type: QUERY
-PREHOOK: Input: default@orc_table_1
-PREHOOK: Input: default@orc_table_2
-#### A masked pattern was here ####
-POSTHOOK: query: select t1.v1, t1.a, t2.c, t2.v2 from orc_table_1 t1 right outer join orc_table_2 t2 on t1.a = t2.c
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@orc_table_1
-POSTHOOK: Input: default@orc_table_2
-#### A masked pattern was here ####
-NULL	NULL	0	ZERO
-NULL	NULL	4	FOUR
-NULL	NULL	NULL	<NULL1>
-NULL	NULL	NULL	<NULL2>
-three	3	3	THREE
-two	2	2	TWO
-PREHOOK: query: create table small_alltypesorc1a as select * from alltypesorc where cint is not null and ctinyint is not null limit 5
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc1a
-POSTHOOK: query: create table small_alltypesorc1a as select * from alltypesorc where cint is not null and ctinyint is not null limit 5
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc1a
-PREHOOK: query: create table small_alltypesorc2a as select * from alltypesorc where cint is null and ctinyint is not null limit 5
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc2a
-POSTHOOK: query: create table small_alltypesorc2a as select * from alltypesorc where cint is null and ctinyint is not null limit 5
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc2a
-PREHOOK: query: create table small_alltypesorc3a as select * from alltypesorc where cint is not null and ctinyint is null limit 5
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc3a
-POSTHOOK: query: create table small_alltypesorc3a as select * from alltypesorc where cint is not null and ctinyint is null limit 5
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc3a
-PREHOOK: query: create table small_alltypesorc4a as select * from alltypesorc where cint is null and ctinyint is null limit 5
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc4a
-POSTHOOK: query: create table small_alltypesorc4a as select * from alltypesorc where cint is null and ctinyint is null limit 5
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc4a
-PREHOOK: query: create table small_alltypesorc_a stored as orc as select * from 
-(select * from (select * from small_alltypesorc1a) sq1
- union all
- select * from (select * from small_alltypesorc2a) sq2
- union all
- select * from (select * from small_alltypesorc3a) sq3
- union all
- select * from (select * from small_alltypesorc4a) sq4) q
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@small_alltypesorc1a
-PREHOOK: Input: default@small_alltypesorc2a
-PREHOOK: Input: default@small_alltypesorc3a
-PREHOOK: Input: default@small_alltypesorc4a
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc_a
-POSTHOOK: query: create table small_alltypesorc_a stored as orc as select * from 
-(select * from (select * from small_alltypesorc1a) sq1
- union all
- select * from (select * from small_alltypesorc2a) sq2
- union all
- select * from (select * from small_alltypesorc3a) sq3
- union all
- select * from (select * from small_alltypesorc4a) sq4) q
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@small_alltypesorc1a
-POSTHOOK: Input: default@small_alltypesorc2a
-POSTHOOK: Input: default@small_alltypesorc3a
-POSTHOOK: Input: default@small_alltypesorc4a
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc_a
-PREHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-PREHOOK: Output: default@small_alltypesorc_a
-POSTHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-POSTHOOK: Output: default@small_alltypesorc_a
-PREHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-PREHOOK: query: explain
-select * 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select * 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 2 (BROADCAST_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 11 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean)
-                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
-                    Statistics: Num rows: 11 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col2 (type: int)
-                        1 _col2 (type: int)
-                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23
-                      input vertices:
-                        1 Map 2
-                      Statistics: Num rows: 12 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      File Output Operator
-                        compressed: false
-                        Statistics: Num rows: 12 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                        table:
-                            input format: org.apache.hadoop.mapred.TextInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-        Map 2 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 11 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean)
-                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
-                    Statistics: Num rows: 11 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col2 (type: int)
-                      sort order: +
-                      Map-reduce partition columns: _col2 (type: int)
-                      Statistics: Num rows: 11 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                      value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type: timestamp), _col10 (type: boolean), _col11 (type: boolean)
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select * 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select * 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
--21	-200	NULL	NULL	-21.0	-200.0	NULL	NULL	1969-12-31 16:00:09.052	1969-12-31 15:59:55.451	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-3	-200	NULL	-1438142492	3.0	-200.0	NULL	T8Uakh8tudd1XRG5yKW8Y42H	1969-12-31 16:00:07.648	1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-31	-200	NULL	-245476731	31.0	-200.0	NULL	3E3BxP	1969-12-31 15:59:54.739	1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-38	-200	NULL	-1090414113	38.0	-200.0	NULL	5oQ43l	1969-12-31 16:00:05.478	1969-12-31 15:59:55.451	NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-38	-200	NULL	1576772382	38.0	-200.0	NULL	X3Ufbt46AUIfHe	1969-12-31 15:59:49.567	1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-34	15007	528534767	NULL	-34.0	15007.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:50.434	1969-12-31 16:00:13.352	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	-50	-13326	528534767	NULL	-50.0	-13326.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:46.674	1969-12-31 16:00:08.875	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	29	7021	528534767	NULL	29.0	7021.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 16:00:15.007	1969-12-31 16:00:15.148	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	31	-9566	528534767	NULL	31.0	-9566.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.187	1969-12-31 16:00:06.961	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-11534	528534767	NULL	NULL	-11534.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 15:59:55.407	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-3012	528534767	NULL	NULL	-3012.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:03.756	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4016	528534767	NULL	NULL	-4016.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:07.209	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-4213	528534767	NULL	NULL	-4213.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.589	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL	NULL	-6147	528534767	NULL	NULL	-6147.0	cvLH6Eat2yFsyy7p	NULL	NULL	1969-12-31 16:00:13.839	true	NULL
-PREHOOK: query: explain
-select c.ctinyint 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select c.ctinyint 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 2 (BROADCAST_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col0 (type: tinyint)
-                        1 _col0 (type: tinyint)
-                      outputColumnNames: _col0
-                      input vertices:
-                        1 Map 2
-                      Statistics: Num rows: 1005 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      File Output Operator
-                        compressed: false
-                        Statistics: Num rows: 1005 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                        table:
-                            input format: org.apache.hadoop.mapred.TextInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-        Map 2 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: tinyint)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: tinyint)
-                      Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select c.ctinyint 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select c.ctinyint 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
--21
--28
--34
--50
-29
-3
-31
-31
-31
-31
-38
-38
-38
-38
-NULL
-NULL
-NULL
-NULL
-NULL
-PREHOOK: query: explain
-select count(*), sum(t1.c_ctinyint) from (select c.ctinyint as c_ctinyint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-) t1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select count(*), sum(t1.c_ctinyint) from (select c.ctinyint as c_ctinyint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-) t1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
-        Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 457 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint), cint (type: int)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 457 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col1 (type: int)
-                        1 _col0 (type: int)
-                      outputColumnNames: _col0
-                      input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 1005 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      Map Join Operator
-                        condition map:
-                             Left Outer Join0 to 1
-                        keys:
-                          0 _col0 (type: tinyint)
-                          1 _col0 (type: tinyint)
-                        outputColumnNames: _col0
-                        input vertices:
-                          1 Map 4
-                        Statistics: Num rows: 1105 Data size: 4423 Basic stats: COMPLETE Column stats: NONE
-                        Group By Operator
-                          aggregations: count(), sum(_col0)
-                          mode: hash
-                          outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                          Reduce Output Operator
-                            sort order: 
-                            Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                            value expressions: _col0 (type: bigint), _col1 (type: bigint)
-            Execution mode: vectorized
-        Map 3 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: int)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: int)
-                      Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: tinyint)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: tinyint)
-                      Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Reducer 2 
-            Reduce Operator Tree:
-              Group By Operator
-                aggregations: count(VALUE._col0), sum(VALUE._col1)
-                mode: mergepartial
-                outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*), sum(t1.c_ctinyint) from (select c.ctinyint as c_ctinyint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-) t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*), sum(t1.c_ctinyint) from (select c.ctinyint as c_ctinyint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.ctinyint = c.ctinyint
-) t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-108	1646
-PREHOOK: query: explain
-select count(*), sum(t1.c_cbigint) from (select c.cbigint as c_cbigint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cbigint = c.cbigint
-) t1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select count(*), sum(t1.c_cbigint) from (select c.cbigint as c_cbigint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cbigint = c.cbigint
-) t1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
-        Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 304 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int), cbigint (type: bigint)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 304 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col0 (type: int)
-                        1 _col0 (type: int)
-                      outputColumnNames: _col1
-                      input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 1005 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      Map Join Operator
-                        condition map:
-                             Left Outer Join0 to 1
-                        keys:
-                          0 _col1 (type: bigint)
-                          1 _col0 (type: bigint)
-                        outputColumnNames: _col1
-                        input vertices:
-                          1 Map 4
-                        Statistics: Num rows: 1105 Data size: 4423 Basic stats: COMPLETE Column stats: NONE
-                        Select Operator
-                          expressions: _col1 (type: bigint)
-                          outputColumnNames: _col0
-                          Statistics: Num rows: 1105 Data size: 4423 Basic stats: COMPLETE Column stats: NONE
-                          Group By Operator
-                            aggregations: count(), sum(_col0)
-                            mode: hash
-                            outputColumnNames: _col0, _col1
-                            Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                            Reduce Output Operator
-                              sort order: 
-                              Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                              value expressions: _col0 (type: bigint), _col1 (type: bigint)
-            Execution mode: vectorized
-        Map 3 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: int)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: int)
-                      Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 457 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cbigint (type: bigint)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 457 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: bigint)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: bigint)
-                      Statistics: Num rows: 457 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Reducer 2 
-            Reduce Operator Tree:
-              Group By Operator
-                aggregations: count(VALUE._col0), sum(VALUE._col1)
-                mode: mergepartial
-                outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*), sum(t1.c_cbigint) from (select c.cbigint as c_cbigint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cbigint = c.cbigint
-) t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*), sum(t1.c_cbigint) from (select c.cbigint as c_cbigint
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cbigint = c.cbigint
-) t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-105	-1197260954
-PREHOOK: query: explain
-select count(*) from (select c.cstring1 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select count(*) from (select c.cstring1 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
-        Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 35 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int), cstring1 (type: string)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 35 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col0 (type: int)
-                        1 _col0 (type: int)
-                      outputColumnNames: _col1
-                      input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 1005 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      Map Join Operator
-                        condition map:
-                             Left Outer Join0 to 1
-                        keys:
-                          0 _col1 (type: string)
-                          1 _col0 (type: string)
-                        input vertices:
-                          1 Map 4
-                        Statistics: Num rows: 1105 Data size: 4423 Basic stats: COMPLETE Column stats: NONE
-                        Group By Operator
-                          aggregations: count()
-                          mode: hash
-                          outputColumnNames: _col0
-                          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                          Reduce Output Operator
-                            sort order: 
-                            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                            value expressions: _col0 (type: bigint)
-            Execution mode: vectorized
-        Map 3 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: int)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: int)
-                      Statistics: Num rows: 914 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cstring1 (type: string)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: string)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: string)
-                      Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Reducer 2 
-            Reduce Operator Tree:
-              Group By Operator
-                aggregations: count(VALUE._col0)
-                mode: mergepartial
-                outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*) from (select c.cstring1
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*) from (select c.cstring1
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cint = c.cint 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-1005
-PREHOOK: query: explain
-select count(*) from (select c.cstring1 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select count(*) from (select c.cstring1 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
-        Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 18 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cstring1 (type: string), cstring2 (type: string)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 18 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col1 (type: string)
-                        1 _col0 (type: string)
-                      outputColumnNames: _col0
-                      input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 39 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      Map Join Operator
-                        condition map:
-                             Left Outer Join0 to 1
-                        keys:
-                          0 _col0 (type: string)
-                          1 _col0 (type: string)
-                        input vertices:
-                          1 Map 4
-                        Statistics: Num rows: 42 Data size: 4423 Basic stats: COMPLETE Column stats: NONE
-                        Group By Operator
-                          aggregations: count()
-                          mode: hash
-                          outputColumnNames: _col0
-                          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                          Reduce Output Operator
-                            sort order: 
-                            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                            value expressions: _col0 (type: bigint)
-            Execution mode: vectorized
-        Map 3 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cstring2 (type: string)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: string)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: string)
-                      Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cstring1 (type: string)
-                    outputColumnNames: _col0
-                    Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col0 (type: string)
-                      sort order: +
-                      Map-reduce partition columns: _col0 (type: string)
-                      Statistics: Num rows: 36 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Reducer 2 
-            Reduce Operator Tree:
-              Group By Operator
-                aggregations: count(VALUE._col0)
-                mode: mergepartial
-                outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*) from (select c.cstring1
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*) from (select c.cstring1
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1
-) t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-105
-PREHOOK: query: explain
-select count(*) from (select c.cstring1 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 and cd.cbigint = c.cbigint
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1 and hd.cint = c.cint
-) t1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select count(*) from (select c.cstring1 
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 and cd.cbigint = c.cbigint
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1 and hd.cint = c.cint
-) t1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
-        Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 17 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int), cbigint (type: bigint), cstring1 (type: string), cstring2 (type: string)
-                    outputColumnNames: _col0, _col1, _col2, _col3
-                    Statistics: Num rows: 17 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col3 (type: string), _col1 (type: bigint)
-                        1 _col1 (type: string), _col0 (type: bigint)
-                      outputColumnNames: _col0, _col2
-                      input vertices:
-                        1 Map 3
-                      Statistics: Num rows: 36 Data size: 4021 Basic stats: COMPLETE Column stats: NONE
-                      Map Join Operator
-                        condition map:
-                             Left Outer Join0 to 1
-                        keys:
-                          0 _col2 (type: string), _col0 (type: int)
-                          1 _col1 (type: string), _col0 (type: int)
-                        input vertices:
-                          1 Map 4
-                        Statistics: Num rows: 39 Data size: 4423 Basic stats: COMPLETE Column stats: NONE
-                        Group By Operator
-                          aggregations: count()
-                          mode: hash
-                          outputColumnNames: _col0
-                          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                          Reduce Output Operator
-                            sort order: 
-                            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                            value expressions: _col0 (type: bigint)
-            Execution mode: vectorized
-        Map 3 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 33 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cbigint (type: bigint), cstring2 (type: string)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 33 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col1 (type: string), _col0 (type: bigint)
-                      sort order: ++
-                      Map-reduce partition columns: _col1 (type: string), _col0 (type: bigint)
-                      Statistics: Num rows: 33 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Map 4 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 35 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: cint (type: int), cstring1 (type: string)
-                    outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 35 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col1 (type: string), _col0 (type: int)
-                      sort order: ++
-                      Map-reduce partition columns: _col1 (type: string), _col0 (type: int)
-                      Statistics: Num rows: 35 Data size: 3656 Basic stats: COMPLETE Column stats: NONE
-            Execution mode: vectorized
-        Reducer 2 
-            Reduce Operator Tree:
-              Group By Operator
-                aggregations: count(VALUE._col0)
-                mode: mergepartial
-                outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                File Output Operator
-                  compressed: false
-                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
-                  table:
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*) from (select c.cstring1
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 and cd.cbigint = c.cbigint
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1 and hd.cint = c.cint
-) t1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select count(*) from (select c.cstring1
-from small_alltypesorc_a c
-left outer join small_alltypesorc_a cd
-  on cd.cstring2 = c.cstring2 and cd.cbigint = c.cbigint
-left outer join small_alltypesorc_a hd
-  on hd.cstring1 = c.cstring1 and hd.cint = c.cint
-) t1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_a
-#### A masked pattern was here ####
-105
-PREHOOK: query: create table small_alltypesorc1b as select * from alltypesorc where cint is not null and ctinyint is not null limit 10
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc1b
-POSTHOOK: query: create table small_alltypesorc1b as select * from alltypesorc where cint is not null and ctinyint is not null limit 10
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc1b
-PREHOOK: query: create table small_alltypesorc2b as select * from alltypesorc where cint is null and ctinyint is not null limit 10
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc2b
-POSTHOOK: query: create table small_alltypesorc2b as select * from alltypesorc where cint is null and ctinyint is not null limit 10
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc2b
-PREHOOK: query: create table small_alltypesorc3b as select * from alltypesorc where cint is not null and ctinyint is null limit 10
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc3b
-POSTHOOK: query: create table small_alltypesorc3b as select * from alltypesorc where cint is not null and ctinyint is null limit 10
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc3b
-PREHOOK: query: create table small_alltypesorc4b as select * from alltypesorc where cint is null and ctinyint is null limit 10
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc4b
-POSTHOOK: query: create table small_alltypesorc4b as select * from alltypesorc where cint is null and ctinyint is null limit 10
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc4b
-PREHOOK: query: create table small_alltypesorc_b stored as orc as select * from 
-(select * from (select * from small_alltypesorc1b) sq1
- union all
- select * from (select * from small_alltypesorc2b) sq2
- union all
- select * from (select * from small_alltypesorc3b) sq3
- union all
- select * from (select * from small_alltypesorc4b) sq4) q
-PREHOOK: type: CREATETABLE_AS_SELECT
-PREHOOK: Input: default@small_alltypesorc1b
-PREHOOK: Input: default@small_alltypesorc2b
-PREHOOK: Input: default@small_alltypesorc3b
-PREHOOK: Input: default@small_alltypesorc4b
-PREHOOK: Output: database:default
-PREHOOK: Output: default@small_alltypesorc_b
-POSTHOOK: query: create table small_alltypesorc_b stored as orc as select * from 
-(select * from (select * from small_alltypesorc1b) sq1
- union all
- select * from (select * from small_alltypesorc2b) sq2
- union all
- select * from (select * from small_alltypesorc3b) sq3
- union all
- select * from (select * from small_alltypesorc4b) sq4) q
-POSTHOOK: type: CREATETABLE_AS_SELECT
-POSTHOOK: Input: default@small_alltypesorc1b
-POSTHOOK: Input: default@small_alltypesorc2b
-POSTHOOK: Input: default@small_alltypesorc3b
-POSTHOOK: Input: default@small_alltypesorc4b
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@small_alltypesorc_b
-PREHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_b
-PREHOOK: Output: default@small_alltypesorc_b
-POSTHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_b
-POSTHOOK: Output: default@small_alltypesorc_b
-PREHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS FOR COLUMNS
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_b
-#### A masked pattern was here ####
-POSTHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS FOR COLUMNS
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_b
-#### A masked pattern was here ####
-PREHOOK: query: explain
-select * 
-from small_alltypesorc_b c
-left outer join small_alltypesorc_b cd
-  on cd.cint = c.cint
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select * 
-from small_alltypesorc_b c
-left outer join small_alltypesorc_b cd
-  on cd.cint = c.cint
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Tez
-      Edges:
-        Map 1 <- Map 2 (BROADCAST_EDGE)
-#### A masked pattern was here ####
-      Vertices:
-        Map 1 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 12 Data size: 3977 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean)
-                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
-                    Statistics: Num rows: 12 Data size: 3977 Basic stats: COMPLETE Column stats: NONE
-                    Map Join Operator
-                      condition map:
-                           Left Outer Join0 to 1
-                      keys:
-                        0 _col2 (type: int)
-                        1 _col2 (type: int)
-                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23
-                      input vertices:
-                        1 Map 2
-                      Statistics: Num rows: 13 Data size: 4374 Basic stats: COMPLETE Column stats: NONE
-                      File Output Operator
-                        compressed: false
-                        Statistics: Num rows: 13 Data size: 4374 Basic stats: COMPLETE Column stats: NONE
-                        table:
-                            input format: org.apache.hadoop.mapred.TextInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-            Execution mode: vectorized
-        Map 2 
-            Map Operator Tree:
-                TableScan
-                  alias: c
-                  Statistics: Num rows: 12 Data size: 3977 Basic stats: COMPLETE Column stats: NONE
-                  Select Operator
-                    expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint (type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1 (type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type: timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean)
-                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
-                    Statistics: Num rows: 12 Data size: 3977 Basic stats: COMPLETE Column stats: NONE
-                    Reduce Output Operator
-                      key expressions: _col2 (type: int)
-                      sort order: +
-                      Map-reduce partition columns: _col2 (type: int)
-                      Statistics: Num rows: 12 Data size: 3977 Basic stats: COMPLETE Column stats: NONE
-                      value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: string), _col7 (type: string), _col8 (type: timestamp), _col9 (type: timestamp), _col10 (type: boolean), _col11 (type: boolean)
-            Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-select * 
-from small_alltypesorc_b c
-left outer join small_alltypesorc_b cd
-  on cd.cint = c.cint
-PREHOOK: type: QUERY
-PREHOOK: Input: default@small_alltypesorc_b
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-select * 
-from small_alltypesorc_b c
-left outer join small_alltypesorc_b cd
-  on cd.cint = c.cint
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@small_alltypesorc_b
-#### A masked pattern was here ####
--10	-200	NULL	-1818374653	-10.0	-200.0	NULL	uFavNs7g58qrfyCH681d	1969-12-31 16:00:03.248	1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--21	-200	NULL	NULL	-21.0	-200.0	NULL	NULL	1969-12-31 16:00:09.052	1969-12-31 15:59:55.451	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--30	-200	NULL	-815881183	-30.0	-200.0	NULL	B0B5kG3OIl6C	1969-12-31 15:59:44.842	1969-12-31 15:59:55.451	NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--39	-200	NULL	944477914	-39.0	-200.0	NULL	T8brJ213nd7rhW8XdnB1	1969-12-31 16:00:00.958	1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
--63	-200	NULL	1927856372	-63.0	-200.0	NULL	v6mk2b7oX	1969-12-31 16:00:06.852	1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-11	-15431	528534767	NULL	-11.0	-15431.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:52.176	1969-12-31 16:00:07.787	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NULL	-28	-15813	528534767	NULL	-28.0	-15813.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:55.787	1969-12-31 16:00:01.546	true	NULL
-16	5780	528534767	NULL	16.0	5780.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:44.451	1969-12-31 16:00:12.752	true	NUL

<TRUNCATED>

Mime
View raw message