hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject [26/51] [partial] hive git commit: HIVE-14376: Schema evolution tests takes a long time (Prasanth Jayachandran reviewed by Matt McCline)
Date Thu, 11 Aug 2016 00:09:38 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_complex.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_complex.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_complex.q.out
index d4995c7..16f6f2d 100644
--- a/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_complex.q.out
+++ b/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_complex.q.out
@@ -60,12 +60,12 @@ POSTHOOK: Lineage: part_change_various_various_struct1 PARTITION(part=1).b SIMPL
 POSTHOOK: Lineage: part_change_various_various_struct1 PARTITION(part=1).insert_num SIMPLE [(struct1_a_txt)struct1_a_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
 POSTHOOK: Lineage: part_change_various_various_struct1 PARTITION(part=1).s1 SIMPLE [(struct1_a_txt)struct1_a_txt.FieldSchema(name:s1, type:struct<c1:boolean,c2:tinyint,c3:smallint,c4:int,c5:bigint,c6:float,c7:double,c8:decimal(38,18),c9:char(25),c10:varchar(25),c11:timestamp,c12:date,c13:binary>, comment:null), ]
 struct1_a_txt.insert_num	struct1_a_txt.s1	struct1_a_txt.b
-PREHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num
+PREHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_struct1
 PREHOOK: Input: default@part_change_various_various_struct1@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num
+POSTHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_struct1
 POSTHOOK: Input: default@part_change_various_various_struct1@part=1
@@ -154,39 +154,32 @@ POSTHOOK: Lineage: part_change_various_various_struct1 PARTITION(part=1).insert_
 POSTHOOK: Lineage: part_change_various_various_struct1 PARTITION(part=1).s1 SIMPLE [(struct1_c_txt)struct1_c_txt.FieldSchema(name:s1, type:struct<c1:string,c2:string,c3:string,c4:string,c5:string,c6:string,c7:string,c8:string,c9:string,c10:string,c11:string,c12:string,c13:string>, comment:null), ]
 struct1_c_txt.insert_num	struct1_c_txt.s1	struct1_c_txt.b
 PREHOOK: query: explain
-select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num
+select insert_num,part,s1,b from part_change_various_various_struct1
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num
+select insert_num,part,s1,b from part_change_various_various_struct1
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 llap
-      File Output Operator [FS_4]
-        Select Operator [SEL_3] (rows=6 width=151)
+      Map 1 llap
+      File Output Operator [FS_2]
+        Select Operator [SEL_1] (rows=6 width=151)
           Output:["_col0","_col1","_col2","_col3"]
-        <-Map 1 [SIMPLE_EDGE] llap
-          SHUFFLE [RS_2]
-            Select Operator [SEL_1] (rows=6 width=151)
-              Output:["_col0","_col1","_col2","_col3"]
-              TableScan [TS_0] (rows=6 width=151)
-                default@part_change_various_various_struct1,part_change_various_various_struct1,Tbl:COMPLETE,Col:NONE,Output:["insert_num","s1","b"]
+          TableScan [TS_0] (rows=6 width=151)
+            default@part_change_various_various_struct1,part_change_various_various_struct1,Tbl:COMPLETE,Col:NONE,Output:["insert_num","s1","b"]
 
-PREHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num
+PREHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_struct1
 PREHOOK: Input: default@part_change_various_various_struct1@part=1
 PREHOOK: Input: default@part_change_various_various_struct1@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num
+POSTHOOK: query: select insert_num,part,s1,b from part_change_various_various_struct1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_struct1
 POSTHOOK: Input: default@part_change_various_various_struct1@part=1
@@ -236,12 +229,12 @@ POSTHOOK: Output: default@part_add_various_various_struct2@part=1
 POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=1).b SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
 POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1
-PREHOOK: query: select insert_num,part,b from part_add_various_various_struct2 order by insert_num
+PREHOOK: query: select insert_num,part,b from part_add_various_various_struct2
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_add_various_various_struct2
 PREHOOK: Input: default@part_add_various_various_struct2@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,b from part_add_various_various_struct2 order by insert_num
+POSTHOOK: query: select insert_num,part,b from part_add_various_various_struct2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_add_various_various_struct2
 POSTHOOK: Input: default@part_add_various_various_struct2@part=1
@@ -327,13 +320,13 @@ POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=2).b SIMPLE [
 POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=2).insert_num SIMPLE [(struct2_b_txt)struct2_b_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
 POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=2).s2 SIMPLE [(struct2_b_txt)struct2_b_txt.FieldSchema(name:s2, type:struct<c1:boolean,c2:tinyint,c3:smallint,c4:int,c5:bigint,c6:float,c7:double,c8:decimal(38,18),c9:char(25),c10:varchar(25),c11:timestamp,c12:date,c13:binary>, comment:null), ]
 struct2_b_txt.insert_num	struct2_b_txt.b	struct2_b_txt.s2
-PREHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num
+PREHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_add_various_various_struct2
 PREHOOK: Input: default@part_add_various_various_struct2@part=1
 PREHOOK: Input: default@part_add_various_various_struct2@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num
+POSTHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_add_various_various_struct2
 POSTHOOK: Input: default@part_add_various_various_struct2@part=1
@@ -425,39 +418,32 @@ POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=1).insert_num
 POSTHOOK: Lineage: part_add_various_various_struct2 PARTITION(part=1).s2 SIMPLE [(struct2_d_txt)struct2_d_txt.FieldSchema(name:s2, type:struct<c1:string,c2:string,c3:string,c4:string,c5:string,c6:string,c7:string,c8:string,c9:string,c10:string,c11:string,c12:string,c13:string>, comment:null), ]
 struct2_d_txt.insert_num	struct2_d_txt.b	struct2_d_txt.s2
 PREHOOK: query: explain
-select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num
+select insert_num,part,b,s2 from part_add_various_various_struct2
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num
+select insert_num,part,b,s2 from part_add_various_various_struct2
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 llap
-      File Output Operator [FS_4]
-        Select Operator [SEL_3] (rows=8 width=113)
+      Map 1 llap
+      File Output Operator [FS_2]
+        Select Operator [SEL_1] (rows=8 width=113)
           Output:["_col0","_col1","_col2","_col3"]
-        <-Map 1 [SIMPLE_EDGE] llap
-          SHUFFLE [RS_2]
-            Select Operator [SEL_1] (rows=8 width=113)
-              Output:["_col0","_col1","_col2","_col3"]
-              TableScan [TS_0] (rows=8 width=113)
-                default@part_add_various_various_struct2,part_add_various_various_struct2,Tbl:COMPLETE,Col:NONE,Output:["insert_num","b","s2"]
+          TableScan [TS_0] (rows=8 width=113)
+            default@part_add_various_various_struct2,part_add_various_various_struct2,Tbl:COMPLETE,Col:NONE,Output:["insert_num","b","s2"]
 
-PREHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num
+PREHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_add_various_various_struct2
 PREHOOK: Input: default@part_add_various_various_struct2@part=1
 PREHOOK: Input: default@part_add_various_various_struct2@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num
+POSTHOOK: query: select insert_num,part,b,s2 from part_add_various_various_struct2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_add_various_various_struct2
 POSTHOOK: Input: default@part_add_various_various_struct2@part=1
@@ -528,12 +514,12 @@ POSTHOOK: Lineage: part_add_to_various_various_struct4 PARTITION(part=1).b SIMPL
 POSTHOOK: Lineage: part_add_to_various_various_struct4 PARTITION(part=1).insert_num SIMPLE [(struct4_a_txt)struct4_a_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
 POSTHOOK: Lineage: part_add_to_various_various_struct4 PARTITION(part=1).s3 SIMPLE [(struct4_a_txt)struct4_a_txt.FieldSchema(name:s3, type:struct<c1:boolean,c2:tinyint,c3:smallint,c4:int,c5:bigint>, comment:null), ]
 struct4_a_txt.insert_num	struct4_a_txt.b	struct4_a_txt.s3
-PREHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num
+PREHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_add_to_various_various_struct4
 PREHOOK: Input: default@part_add_to_various_various_struct4@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num
+POSTHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_add_to_various_various_struct4
 POSTHOOK: Input: default@part_add_to_various_various_struct4@part=1
@@ -620,39 +606,32 @@ POSTHOOK: Lineage: part_add_to_various_various_struct4 PARTITION(part=1).insert_
 POSTHOOK: Lineage: part_add_to_various_various_struct4 PARTITION(part=1).s3 SIMPLE [(struct4_c_txt)struct4_c_txt.FieldSchema(name:s3, type:struct<c1:boolean,c2:tinyint,c3:smallint,c4:int,c5:bigint,c6:float,c7:double,c8:decimal(38,18),c9:char(25),c10:varchar(25),c11:timestamp,c12:date,c13:binary>, comment:null), ]
 struct4_c_txt.insert_num	struct4_c_txt.b	struct4_c_txt.s3
 PREHOOK: query: explain
-select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num
+select insert_num,part,b,s3 from part_add_to_various_various_struct4
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num
+select insert_num,part,b,s3 from part_add_to_various_various_struct4
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 llap
-      File Output Operator [FS_4]
-        Select Operator [SEL_3] (rows=4 width=84)
+      Map 1 llap
+      File Output Operator [FS_2]
+        Select Operator [SEL_1] (rows=4 width=84)
           Output:["_col0","_col1","_col2","_col3"]
-        <-Map 1 [SIMPLE_EDGE] llap
-          SHUFFLE [RS_2]
-            Select Operator [SEL_1] (rows=4 width=84)
-              Output:["_col0","_col1","_col2","_col3"]
-              TableScan [TS_0] (rows=4 width=84)
-                default@part_add_to_various_various_struct4,part_add_to_various_various_struct4,Tbl:COMPLETE,Col:NONE,Output:["insert_num","b","s3"]
+          TableScan [TS_0] (rows=4 width=84)
+            default@part_add_to_various_various_struct4,part_add_to_various_various_struct4,Tbl:COMPLETE,Col:NONE,Output:["insert_num","b","s3"]
 
-PREHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num
+PREHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_add_to_various_various_struct4
 PREHOOK: Input: default@part_add_to_various_various_struct4@part=1
 PREHOOK: Input: default@part_add_to_various_various_struct4@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num
+POSTHOOK: query: select insert_num,part,b,s3 from part_add_to_various_various_struct4
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_add_to_various_various_struct4
 POSTHOOK: Input: default@part_add_to_various_various_struct4@part=1

http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_primitive.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_primitive.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_primitive.q.out
index 3689718..5ea61b0 100644
--- a/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_primitive.q.out
+++ b/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_mapwork_part_all_primitive.q.out
@@ -60,12 +60,12 @@ POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c8 SIMP
 POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_boolean
 PREHOOK: Input: default@part_change_various_various_boolean@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_boolean
 POSTHOOK: Input: default@part_change_various_various_boolean@part=1
@@ -130,39 +130,32 @@ POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).c9 EXPR
 POSTHOOK: Lineage: part_change_various_various_boolean PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=96)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=6 width=96)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=96)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-              TableScan [TS_0] (rows=6 width=96)
-                default@part_change_various_various_boolean,part_change_various_various_boolean,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","b"]
+          TableScan [TS_0] (rows=6 width=96)
+            default@part_change_various_various_boolean,part_change_various_various_boolean,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_boolean
 PREHOOK: Input: default@part_change_various_various_boolean@part=1
 PREHOOK: Input: default@part_change_various_various_boolean@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_boolean
 POSTHOOK: Input: default@part_change_various_various_boolean@part=1
@@ -231,12 +224,12 @@ POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=1).c8 SIMP
 POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_tinyint
 PREHOOK: Input: default@part_change_various_various_tinyint@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_tinyint
 POSTHOOK: Input: default@part_change_various_various_tinyint@part=1
@@ -306,39 +299,32 @@ POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=1).c9 EXPR
 POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=105)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=105)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=105)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=105)
-                default@part_change_various_various_tinyint,part_change_various_various_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=105)
+            default@part_change_various_various_tinyint,part_change_various_various_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_tinyint
 PREHOOK: Input: default@part_change_various_various_tinyint@part=1
 PREHOOK: Input: default@part_change_various_various_tinyint@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_tinyint
 POSTHOOK: Input: default@part_change_various_various_tinyint@part=1
@@ -408,12 +394,12 @@ POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=1).c8 SIM
 POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_smallint
 PREHOOK: Input: default@part_change_various_various_smallint@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_smallint
 POSTHOOK: Input: default@part_change_various_various_smallint@part=1
@@ -483,39 +469,32 @@ POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=1).c9 EXP
 POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=111)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=111)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=111)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=111)
-                default@part_change_various_various_smallint,part_change_various_various_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=111)
+            default@part_change_various_various_smallint,part_change_various_various_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_smallint
 PREHOOK: Input: default@part_change_various_various_smallint@part=1
 PREHOOK: Input: default@part_change_various_various_smallint@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_smallint
 POSTHOOK: Input: default@part_change_various_various_smallint@part=1
@@ -585,12 +564,12 @@ POSTHOOK: Lineage: part_change_various_various_int PARTITION(part=1).c8 SIMPLE [
 POSTHOOK: Lineage: part_change_various_various_int PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_int PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_int
 PREHOOK: Input: default@part_change_various_various_int@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_int
 POSTHOOK: Input: default@part_change_various_various_int@part=1
@@ -660,39 +639,32 @@ POSTHOOK: Lineage: part_change_various_various_int PARTITION(part=1).c9 EXPRESSI
 POSTHOOK: Lineage: part_change_various_various_int PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=114)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=114)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=114)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=114)
-                default@part_change_various_various_int,part_change_various_various_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=114)
+            default@part_change_various_various_int,part_change_various_various_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_int
 PREHOOK: Input: default@part_change_various_various_int@part=1
 PREHOOK: Input: default@part_change_various_various_int@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_int
 POSTHOOK: Input: default@part_change_various_various_int@part=1
@@ -762,12 +734,12 @@ POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=1).c8 SIMPL
 POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_bigint
 PREHOOK: Input: default@part_change_various_various_bigint@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_bigint
 POSTHOOK: Input: default@part_change_various_various_bigint@part=1
@@ -837,39 +809,32 @@ POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=1).c9 EXPRE
 POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=119)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=119)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=119)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=119)
-                default@part_change_various_various_bigint,part_change_various_various_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=119)
+            default@part_change_various_various_bigint,part_change_various_various_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_bigint
 PREHOOK: Input: default@part_change_various_various_bigint@part=1
 PREHOOK: Input: default@part_change_various_various_bigint@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_bigint
 POSTHOOK: Input: default@part_change_various_various_bigint@part=1
@@ -937,12 +902,12 @@ POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=1).c8 SIMPLE
 POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_float
 PREHOOK: Input: default@part_change_various_various_float@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_float
 POSTHOOK: Input: default@part_change_various_various_float@part=1
@@ -1012,39 +977,32 @@ POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=1).c9 EXPRES
 POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=118)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=118)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=118)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=118)
-                default@part_change_various_various_float,part_change_various_various_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=118)
+            default@part_change_various_various_float,part_change_various_various_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_float
 PREHOOK: Input: default@part_change_various_various_float@part=1
 PREHOOK: Input: default@part_change_various_various_float@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_float
 POSTHOOK: Input: default@part_change_various_various_float@part=1
@@ -1112,12 +1070,12 @@ POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=1).c8 SIMPL
 POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_double
 PREHOOK: Input: default@part_change_various_various_double@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_double
 POSTHOOK: Input: default@part_change_various_various_double@part=1
@@ -1187,39 +1145,32 @@ POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=1).c9 EXPRE
 POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__21)values__tmp__table__21.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=124)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=124)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=124)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=124)
-                default@part_change_various_various_double,part_change_various_various_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=124)
+            default@part_change_various_various_double,part_change_various_various_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_double
 PREHOOK: Input: default@part_change_various_various_double@part=1
 PREHOOK: Input: default@part_change_various_various_double@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_double
 POSTHOOK: Input: default@part_change_various_various_double@part=1
@@ -1287,12 +1238,12 @@ POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=1).c8 SIMP
 POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__22)values__tmp__table__22.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__22)values__tmp__table__22.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_decimal
 PREHOOK: Input: default@part_change_various_various_decimal@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_decimal
 POSTHOOK: Input: default@part_change_various_various_decimal@part=1
@@ -1362,39 +1313,32 @@ POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=1).c9 EXPR
 POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__24)values__tmp__table__24.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=159)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=159)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=159)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=7 width=159)
-                default@part_change_various_various_decimal,part_change_various_various_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
+          TableScan [TS_0] (rows=7 width=159)
+            default@part_change_various_various_decimal,part_change_various_various_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_decimal
 PREHOOK: Input: default@part_change_various_various_decimal@part=1
 PREHOOK: Input: default@part_change_various_various_decimal@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_decimal
 POSTHOOK: Input: default@part_change_various_various_decimal@part=1
@@ -1464,12 +1408,12 @@ POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=1).c8 EXPRE
 POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=1).c9 EXPRESSION [(values__tmp__table__25)values__tmp__table__25.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__25)values__tmp__table__25.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_string
 PREHOOK: Input: default@part_change_various_various_string@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_string
 POSTHOOK: Input: default@part_change_various_various_string@part=1
@@ -1543,39 +1487,32 @@ POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=1).c9 SIMPL
 POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__27)values__tmp__table__27.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=141)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=141)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=141)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-              TableScan [TS_0] (rows=7 width=141)
-                default@part_change_various_various_string,part_change_various_various_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
+          TableScan [TS_0] (rows=7 width=141)
+            default@part_change_various_various_string,part_change_various_various_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_string
 PREHOOK: Input: default@part_change_various_various_string@part=1
 PREHOOK: Input: default@part_change_various_various_string@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_string
 POSTHOOK: Input: default@part_change_various_various_string@part=1
@@ -1645,12 +1582,12 @@ POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=1).c8 EXPRESS
 POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=1).c9 SIMPLE [(values__tmp__table__28)values__tmp__table__28.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__28)values__tmp__table__28.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_char
 PREHOOK: Input: default@part_change_various_various_char@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_char
 POSTHOOK: Input: default@part_change_various_various_char@part=1
@@ -1724,39 +1661,32 @@ POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=1).c9 EXPRESS
 POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__30)values__tmp__table__30.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=127)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=127)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=127)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-              TableScan [TS_0] (rows=7 width=127)
-                default@part_change_various_various_char,part_change_various_various_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
+          TableScan [TS_0] (rows=7 width=127)
+            default@part_change_various_various_char,part_change_various_various_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_char
 PREHOOK: Input: default@part_change_various_various_char@part=1
 PREHOOK: Input: default@part_change_various_various_char@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_char
 POSTHOOK: Input: default@part_change_various_various_char@part=1
@@ -1826,12 +1756,12 @@ POSTHOOK: Lineage: part_change_various_various_char_trunc PARTITION(part=1).c8 E
 POSTHOOK: Lineage: part_change_various_various_char_trunc PARTITION(part=1).c9 SIMPLE [(values__tmp__table__31)values__tmp__table__31.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_char_trunc PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__31)values__tmp__table__31.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_char_trunc
 PREHOOK: Input: default@part_change_various_various_char_trunc@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_char_trunc
 POSTHOOK: Input: default@part_change_various_various_char_trunc@part=1
@@ -1905,39 +1835,32 @@ POSTHOOK: Lineage: part_change_various_various_char_trunc PARTITION(part=1).c9 E
 POSTHOOK: Lineage: part_change_various_various_char_trunc PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__33)values__tmp__table__33.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=121)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=121)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=121)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-              TableScan [TS_0] (rows=7 width=121)
-                default@part_change_various_various_char_trunc,part_change_various_various_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
+          TableScan [TS_0] (rows=7 width=121)
+            default@part_change_various_various_char_trunc,part_change_various_various_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_char_trunc
 PREHOOK: Input: default@part_change_various_various_char_trunc@part=1
 PREHOOK: Input: default@part_change_various_various_char_trunc@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_char_trunc
 POSTHOOK: Input: default@part_change_various_various_char_trunc@part=1
@@ -2007,12 +1930,12 @@ POSTHOOK: Lineage: part_change_various_various_varchar PARTITION(part=1).c8 EXPR
 POSTHOOK: Lineage: part_change_various_various_varchar PARTITION(part=1).c9 SIMPLE [(values__tmp__table__34)values__tmp__table__34.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_varchar PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__34)values__tmp__table__34.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_varchar
 PREHOOK: Input: default@part_change_various_various_varchar@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_varchar
 POSTHOOK: Input: default@part_change_various_various_varchar@part=1
@@ -2086,39 +2009,32 @@ POSTHOOK: Lineage: part_change_various_various_varchar PARTITION(part=1).c9 EXPR
 POSTHOOK: Lineage: part_change_various_various_varchar PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__36)values__tmp__table__36.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=143)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=143)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=143)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-              TableScan [TS_0] (rows=7 width=143)
-                default@part_change_various_various_varchar,part_change_various_various_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
+          TableScan [TS_0] (rows=7 width=143)
+            default@part_change_various_various_varchar,part_change_various_various_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_varchar
 PREHOOK: Input: default@part_change_various_various_varchar@part=1
 PREHOOK: Input: default@part_change_various_various_varchar@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_varchar
 POSTHOOK: Input: default@part_change_various_various_varchar@part=1
@@ -2188,12 +2104,12 @@ POSTHOOK: Lineage: part_change_various_various_varchar_trunc PARTITION(part=1).c
 POSTHOOK: Lineage: part_change_various_various_varchar_trunc PARTITION(part=1).c9 SIMPLE [(values__tmp__table__37)values__tmp__table__37.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_varchar_trunc PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__37)values__tmp__table__37.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_varchar_trunc
 PREHOOK: Input: default@part_change_various_various_varchar_trunc@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_varchar_trunc
 POSTHOOK: Input: default@part_change_various_various_varchar_trunc@part=1
@@ -2267,39 +2183,32 @@ POSTHOOK: Lineage: part_change_various_various_varchar_trunc PARTITION(part=1).c
 POSTHOOK: Lineage: part_change_various_various_varchar_trunc PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__39)values__tmp__table__39.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=138)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=138)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=138)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-              TableScan [TS_0] (rows=7 width=138)
-                default@part_change_various_various_varchar_trunc,part_change_various_various_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
+          TableScan [TS_0] (rows=7 width=138)
+            default@part_change_various_various_varchar_trunc,part_change_various_various_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_varchar_trunc
 PREHOOK: Input: default@part_change_various_various_varchar_trunc@part=1
 PREHOOK: Input: default@part_change_various_various_varchar_trunc@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_varchar_trunc
 POSTHOOK: Input: default@part_change_various_various_varchar_trunc@part=1
@@ -2368,12 +2277,12 @@ POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c8 EX
 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c9 SIMPLE [(values__tmp__table__40)values__tmp__table__40.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__40)values__tmp__table__40.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_timestamp
 PREHOOK: Input: default@part_change_various_various_timestamp@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_timestamp
 POSTHOOK: Input: default@part_change_various_various_timestamp@part=1
@@ -2445,39 +2354,32 @@ POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c9 EX
 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__42)values__tmp__table__42.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=7 width=124)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=7 width=124)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=7 width=124)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14"]
-              TableScan [TS_0] (rows=7 width=124)
-                default@part_change_various_various_timestamp,part_change_various_various_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","b"]
+          TableScan [TS_0] (rows=7 width=124)
+            default@part_change_various_various_timestamp,part_change_various_various_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_timestamp
 PREHOOK: Input: default@part_change_various_various_timestamp@part=1
 PREHOOK: Input: default@part_change_various_various_timestamp@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_timestamp
 POSTHOOK: Input: default@part_change_various_various_timestamp@part=1
@@ -2536,12 +2438,12 @@ POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c3 EXPRESS
 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__43)values__tmp__table__43.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__43)values__tmp__table__43.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_date
 PREHOOK: Input: default@part_change_various_various_date@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_date
 POSTHOOK: Input: default@part_change_various_various_date@part=1
@@ -2596,39 +2498,32 @@ POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c4 EXPRESS
 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__45)values__tmp__table__45.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num
+select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num
+select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=97)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=6 width=97)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=97)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-              TableScan [TS_0] (rows=6 width=97)
-                default@part_change_various_various_date,part_change_various_various_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
+          TableScan [TS_0] (rows=6 width=97)
+            default@part_change_various_various_date,part_change_various_various_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_various_various_date
 PREHOOK: Input: default@part_change_various_various_date@part=1
 PREHOOK: Input: default@part_change_various_various_date@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_various_various_date
 POSTHOOK: Input: default@part_change_various_various_date@part=1
@@ -2714,12 +2609,12 @@ POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c5 S
 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c6 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c6, type:decimal(20,10), comment:null), ]
 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).insert_num SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
 same_type1_a_txt.insert_num	same_type1_a_txt.c1	same_type1_a_txt.c2	same_type1_a_txt.c3	same_type1_a_txt.c4	same_type1_a_txt.c5	same_type1_a_txt.c6	same_type1_a_txt.b
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_same_type_different_params
 PREHOOK: Input: default@part_change_same_type_different_params@part=1
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_same_type_different_params
 POSTHOOK: Input: default@part_change_same_type_different_params@part=1
@@ -2841,39 +2736,32 @@ POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c6 S
 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).insert_num SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
 same_type1_c_txt.insert_num	same_type1_c_txt.c1	same_type1_c_txt.c2	same_type1_c_txt.c3	same_type1_c_txt.c4	same_type1_c_txt.c5	same_type1_c_txt.c6	same_type1_c_txt.b
 PREHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
 PREHOOK: type: QUERY
 POSTHOOK: query: explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num
+select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
 POSTHOOK: type: QUERY
 Explain
 Plan optimized by CBO.
 
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE)
-
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 2 vectorized, llap
-      File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=13 width=96)
+      Map 1 vectorized, llap
+      File Output Operator [FS_4]
+        Select Operator [SEL_3] (rows=13 width=96)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
-        <-Map 1 [SIMPLE_EDGE] vectorized, llap
-          SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=13 width=96)
-              Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
-              TableScan [TS_0] (rows=13 width=96)
-                default@part_change_same_type_different_params,part_change_same_type_different_params,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","b"]
+          TableScan [TS_0] (rows=13 width=96)
+            default@part_change_same_type_different_params,part_change_same_type_different_params,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","b"]
 
-PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num
+PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_same_type_different_params
 PREHOOK: Input: default@part_change_same_type_different_params@part=1
 PREHOOK: Input: default@part_change_same_type_different_params@part=2
 #### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num
+POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part_change_same_type_different_params
 POSTHOOK: Input: default@part_change_same_type_different_params@part=1


Mime
View raw message