http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/results/clientpositive/llap/schema_evol_text_nonvec_mapwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_text_nonvec_mapwork_part.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_text_nonvec_mapwork_part.q.out index e0d0cab..81d0fcc 100644 --- a/ql/src/test/results/clientpositive/llap/schema_evol_text_nonvec_mapwork_part.q.out +++ b/ql/src/test/results/clientpositive/llap/schema_evol_text_nonvec_mapwork_part.q.out @@ -172,41 +172,34 @@ POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).c EXPRESSION [( POSTHOOK: Lineage: part_add_int_permute_select 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 PREHOOK: query: explain -select insert_num,part,a,b from part_add_int_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_permute_select PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,a,b from part_add_int_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_permute_select 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=10 width=11) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=11) Output:["_col0","_col1","_col2","_col3"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=11) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=10 width=11) - default@part_add_int_permute_select,part_add_int_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"] + TableScan [TS_0] (rows=10 width=11) + default@part_add_int_permute_select,part_add_int_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"] PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_permute_select PREHOOK: Input: default@part_add_int_permute_select@part=1 PREHOOK: Input: default@part_add_int_permute_select@part=2 #### A masked pattern was here #### POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_permute_select POSTHOOK: Input: default@part_add_int_permute_select@part=1 @@ -223,13 +216,13 @@ insert_num part a b 7 2 3 new 8 2 4 new 9 1 5 new -PREHOOK: query: select insert_num,part,a,b,c from part_add_int_permute_select order by insert_num +PREHOOK: query: select insert_num,part,a,b,c from part_add_int_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_permute_select PREHOOK: Input: default@part_add_int_permute_select@part=1 PREHOOK: Input: default@part_add_int_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,b,c from part_add_int_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,a,b,c from part_add_int_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_permute_select POSTHOOK: Input: default@part_add_int_permute_select@part=1 @@ -246,13 +239,13 @@ insert_num part a b c 7 2 3 new 30 8 2 4 new 40 9 1 5 new NULL -PREHOOK: query: select insert_num,part,c from part_add_int_permute_select order by insert_num +PREHOOK: query: select insert_num,part,c from part_add_int_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_permute_select PREHOOK: Input: default@part_add_int_permute_select@part=1 PREHOOK: Input: default@part_add_int_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c from part_add_int_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,c from part_add_int_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_permute_select POSTHOOK: Input: default@part_add_int_permute_select@part=1 @@ -438,41 +431,34 @@ POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).d SIMPLE POSTHOOK: Lineage: part_add_int_string_permute_select 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 PREHOOK: query: explain -select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_string_permute_select PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_string_permute_select 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=10 width=15) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=15) Output:["_col0","_col1","_col2","_col3"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=15) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=10 width=15) - default@part_add_int_string_permute_select,part_add_int_string_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"] + TableScan [TS_0] (rows=10 width=15) + default@part_add_int_string_permute_select,part_add_int_string_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"] PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num +select insert_num,part,a,b from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -489,13 +475,13 @@ insert_num part a b 7 2 3 new 8 2 4 new 9 1 5 new -PREHOOK: query: select insert_num,part,a,b,c from part_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,part,a,b,c from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,b,c from part_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,a,b,c from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -512,13 +498,13 @@ insert_num part a b c 7 2 3 new 30 8 2 4 new 40 9 1 5 new NULL -PREHOOK: query: select insert_num,part,a,b,c,d from part_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,part,a,b,c,d from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,b,c,d from part_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,a,b,c,d from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -535,13 +521,13 @@ insert_num part a b c d 7 2 3 new 30 thirty 8 2 4 new 40 forty 9 1 5 new NULL NULL -PREHOOK: query: select insert_num,part,a,c,d from part_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,part,a,c,d from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,c,d from part_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,a,c,d from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -558,13 +544,13 @@ insert_num part a c d 7 2 3 30 thirty 8 2 4 40 forty 9 1 5 NULL NULL -PREHOOK: query: select insert_num,part,a,d from part_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,part,a,d from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,d from part_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,a,d from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -581,13 +567,13 @@ insert_num part a d 7 2 3 thirty 8 2 4 forty 9 1 5 NULL -PREHOOK: query: select insert_num,part,c from part_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,part,c from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c from part_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,c from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -604,13 +590,13 @@ insert_num part c 7 2 30 8 2 40 9 1 NULL -PREHOOK: query: select insert_num,part,d from part_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,part,d from part_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@part_add_int_string_permute_select PREHOOK: Input: default@part_add_int_string_permute_select@part=1 PREHOOK: Input: default@part_add_int_string_permute_select@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,d from part_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,part,d from part_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 @@ -730,39 +716,32 @@ POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c3 EXPRESSI POSTHOOK: Lineage: part_change_string_group_double 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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_string_group_double PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_string_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=55) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=55) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=55) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=55) - default@part_change_string_group_double,part_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=55) + default@part_change_string_group_double,part_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_double PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_double PREHOOK: Input: default@part_change_string_group_double@part=1 PREHOOK: Input: default@part_change_string_group_double@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_double POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_double POSTHOOK: Input: default@part_change_string_group_double@part=1 @@ -886,39 +865,32 @@ POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part= POSTHOOK: Lineage: part_change_date_group_string_group_timestamp 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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=9 width=147) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=9 width=147) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=9 width=147) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - TableScan [TS_0] (rows=9 width=147) - default@part_change_date_group_string_group_timestamp,part_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] + TableScan [TS_0] (rows=9 width=147) + default@part_change_date_group_string_group_timestamp,part_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp PREHOOK: type: QUERY PREHOOK: Input: default@part_change_date_group_string_group_timestamp PREHOOK: Input: default@part_change_date_group_string_group_timestamp@part=1 PREHOOK: Input: default@part_change_date_group_string_group_timestamp@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_date_group_string_group_timestamp POSTHOOK: Input: default@part_change_date_group_string_group_timestamp@part=1 @@ -1017,39 +989,32 @@ POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).c5 POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 _col6 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=9 width=91) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=9 width=91) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=9 width=91) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - TableScan [TS_0] (rows=9 width=91) - default@part_change_date_group_string_group_date,part_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] + TableScan [TS_0] (rows=9 width=91) + default@part_change_date_group_string_group_date,part_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date PREHOOK: type: QUERY PREHOOK: Input: default@part_change_date_group_string_group_date PREHOOK: Input: default@part_change_date_group_string_group_date@part=1 PREHOOK: Input: default@part_change_date_group_string_group_date@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_date_group_string_group_date POSTHOOK: Input: default@part_change_date_group_string_group_date@part=1 @@ -1118,12 +1083,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PART POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 @@ -1178,39 +1143,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PART POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=33) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=33) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=33) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=33) - default@part_change_numeric_group_string_group_multi_ints_string,part_change_numeric_group_string_group_multi_ints_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=10 width=33) + default@part_change_numeric_group_string_group_multi_ints_string,part_change_numeric_group_string_group_multi_ints_string,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_numeric_group_string_group_multi_ints_string order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 @@ -1272,12 +1230,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTIT POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__17)values__tmp__table__17.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_numeric_group_string_group_multi_ints_char order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 @@ -1332,39 +1290,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTIT POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=140) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=140) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=140) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=140) - default@part_change_numeric_group_string_group_multi_ints_char,part_change_numeric_group_string_group_multi_ints_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=10 width=140) + default@part_change_numeric_group_string_group_multi_ints_char,part_change_numeric_group_string_group_multi_ints_char,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_numeric_group_string_group_multi_ints_char order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 @@ -1426,12 +1377,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char_trunc PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char_trunc 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc@part=1 @@ -1486,39 +1437,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char_trunc PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__20)values__tmp__table__20.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 _col6 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=32) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=32) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=32) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=32) - default@part_change_numeric_group_string_group_multi_ints_char_trunc,part_change_numeric_group_string_group_multi_ints_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=10 width=32) + default@part_change_numeric_group_string_group_multi_ints_char_trunc,part_change_numeric_group_string_group_multi_ints_char_trunc,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_numeric_group_string_group_multi_ints_char_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char_trunc@part=1 @@ -1580,12 +1524,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar PAR POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__21)values__tmp__table__21.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar@part=1 @@ -1640,39 +1584,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar PAR POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=33) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=33) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=33) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=33) - default@part_change_numeric_group_string_group_multi_ints_varchar,part_change_numeric_group_string_group_multi_ints_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=10 width=33) + default@part_change_numeric_group_string_group_multi_ints_varchar,part_change_numeric_group_string_group_multi_ints_varchar,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_numeric_group_string_group_multi_ints_varchar order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar@part=1 @@ -1734,12 +1671,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar_tru POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar_trunc PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__23)values__tmp__table__23.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar_trunc PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__23)values__tmp__table__23.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_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc@part=1 @@ -1794,39 +1731,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar_tru POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_varchar_trunc PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=30) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=30) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=30) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=30) - default@part_change_numeric_group_string_group_multi_ints_varchar_trunc,part_change_numeric_group_string_group_multi_ints_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=10 width=30) + default@part_change_numeric_group_string_group_multi_ints_varchar_trunc,part_change_numeric_group_string_group_multi_ints_varchar_trunc,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_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc@part=1 @@ -1887,12 +1817,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_string PARTIT POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_string PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__25)values__tmp__table__25.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_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 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_string PREHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=1 @@ -1945,39 +1875,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_string PARTIT POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_string PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__26)values__tmp__table__26.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=38) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=38) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=38) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=38) - default@part_change_numeric_group_string_group_floating_string,part_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=38) + default@part_change_numeric_group_string_group_floating_string,part_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_string PREHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=1 @@ -2038,12 +1961,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char PARTITIO POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__27)values__tmp__table__27.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=1 @@ -2096,39 +2019,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char PARTITIO POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=116) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=116) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=116) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=116) - default@part_change_numeric_group_string_group_floating_char,part_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=116) + default@part_change_numeric_group_string_group_floating_char,part_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=1 @@ -2189,12 +2105,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char_trunc PA POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char_trunc PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__29)values__tmp__table__29.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char_trunc PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__29)values__tmp__table__29.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=1 @@ -2247,39 +2163,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char_trunc PA POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_char_trunc PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=39) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=39) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=39) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=39) - default@part_change_numeric_group_string_group_floating_char_trunc,part_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=39) + default@part_change_numeric_group_string_group_floating_char_trunc,part_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=1 @@ -2340,12 +2249,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar PARTI POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__31)values__tmp__table__31.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar@part=1 @@ -2398,39 +2307,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar PARTI POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__32)values__tmp__table__32.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=36) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=36) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=36) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=36) - default@part_change_numeric_group_string_group_floating_varchar,part_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=36) + default@part_change_numeric_group_string_group_floating_varchar,part_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar@part=1 @@ -2491,12 +2393,12 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar_trunc PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__33)values__tmp__table__33.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar_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 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=1 @@ -2549,39 +2451,32 @@ POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_varchar_trunc PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=36) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=36) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=36) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=36) - default@part_change_numeric_group_string_group_floating_varchar_trunc,part_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=36) + default@part_change_numeric_group_string_group_floating_varchar_trunc,part_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=1 PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=1 @@ -2651,12 +2546,12 @@ POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=1 POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=1).c4 SIMPLE [(values__tmp__table__35)values__tmp__table__35.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__35)values__tmp__table__35.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_string_group_string_group_string order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_string_group_string PREHOOK: Input: default@part_change_string_group_string_group_string@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_string_group_string POSTHOOK: Input: default@part_change_string_group_string_group_string@part=1 @@ -2711,39 +2606,32 @@ POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=2 POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num +select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=79) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=79) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=79) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=79) - default@part_change_string_group_string_group_string,part_change_string_group_string_group_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=10 width=79) + default@part_change_string_group_string_group_string,part_change_string_group_string_group_string,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_string_group_string_group_string order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_string_group_string PREHOOK: Input: default@part_change_string_group_string_group_string@part=1 PREHOOK: Input: default@part_change_string_group_string_group_string@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_string_group_string POSTHOOK: Input: default@part_change_string_group_string_group_string@part=1 @@ -2804,12 +2692,12 @@ POSTHOOK: Lineage: part_change_string_group_string_group_char PARTITION(part=1). POSTHOOK: Lineage: part_change_string_group_string_group_char PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__37)values__tmp__table__37.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_string_group_string_group_char 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_string_group_char PREHOOK: Input: default@part_change_string_group_string_group_char@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_string_group_char POSTHOOK: Input: default@part_change_string_group_string_group_char@part=1 @@ -2862,39 +2750,32 @@ POSTHOOK: Lineage: part_change_string_group_string_group_char PARTITION(part=2). POSTHOOK: Lineage: part_change_string_group_string_group_char PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__38)values__tmp__table__38.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=93) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=93) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=93) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=93) - default@part_change_string_group_string_group_char,part_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=93) + default@part_change_string_group_string_group_char,part_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_string_group_char PREHOOK: Input: default@part_change_string_group_string_group_char@part=1 PREHOOK: Input: default@part_change_string_group_string_group_char@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_string_group_char POSTHOOK: Input: default@part_change_string_group_string_group_char@part=1 @@ -2955,12 +2836,12 @@ POSTHOOK: Lineage: part_change_string_group_string_group_varchar PARTITION(part= POSTHOOK: Lineage: part_change_string_group_string_group_varchar PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__39)values__tmp__table__39.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: part_change_string_group_string_group_varchar 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 -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_string_group_varchar PREHOOK: Input: default@part_change_string_group_string_group_varchar@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_string_group_varchar POSTHOOK: Input: default@part_change_string_group_string_group_varchar@part=1 @@ -3013,39 +2894,32 @@ POSTHOOK: Lineage: part_change_string_group_string_group_varchar PARTITION(part= POSTHOOK: Lineage: part_change_string_group_string_group_varchar PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=68) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=68) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=68) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=68) - default@part_change_string_group_string_group_varchar,part_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=10 width=68) + default@part_change_string_group_string_group_varchar,part_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar PREHOOK: type: QUERY PREHOOK: Input: default@part_change_string_group_string_group_varchar PREHOOK: Input: default@part_change_string_group_string_group_varchar@part=1 PREHOOK: Input: default@part_change_string_group_string_group_varchar@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_string_group_string_group_varchar POSTHOOK: Input: default@part_change_string_group_string_group_varchar@part=1 @@ -3117,12 +2991,12 @@ POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint PARTITION(p POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint PARTITION(part=1).c6 EXPRESSION [(values__tmp__table__41)values__tmp__table__41.FieldSchema(name:tmp_values_col7, type:string, comment:), ] POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__41)values__tmp__table__41.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: QUERY PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=1 @@ -3181,39 +3055,32 @@ POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint PARTITION(p POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint PARTITION(part=2).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 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=44) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=44) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=44) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"] - TableScan [TS_0] (rows=10 width=44) - default@part_change_lower_to_higher_numeric_group_tinyint,part_change_lower_to_higher_numeric_group_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","b"] + TableScan [TS_0] (rows=10 width=44) + default@part_change_lower_to_higher_numeric_group_tinyint,part_change_lower_to_higher_numeric_group_tinyint,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_lower_to_higher_numeric_group_tinyint order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: QUERY PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=1 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=1 @@ -3276,12 +3143,12 @@ POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_smallint PARTITION( POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_smallint PARTITION(part=1).c5 EXPRESSION [(values__tmp__table__43)values__tmp__table__43.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_smallint 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 _col6 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint PREHOOK: type: QUERY PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=1 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=1 @@ -3338,39 +3205,32 @@ POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_smallint PARTITION( POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_smallint PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__44)values__tmp__table__44.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_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 llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=44) + Map 1 llap + File Output Operator [FS_2] + Select Operator [SEL_1] (rows=10 width=44) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - <-Map 1 [SIMPLE_EDGE] llap - SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=44) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - TableScan [TS_0] (rows=10 width=44) - default@part_change_lower_to_higher_numeric_group_smallint,part_change_lower_to_higher_numeric_group_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] + TableScan [TS_0] (rows=10 width=44) + default@part_change_lower_to_higher_numeric_group_smallint,part_change_lower_to_higher_numeric_group_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint PREHOOK: type: QUERY PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=1 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=2 #### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num +POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint POSTHOOK: type: QUERY POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=1 @@ -3432,12 +3292,12 @@ POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_int PARTITION(part= POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_int PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__45)values__tmp__table__45.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_int 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: select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int order by insert_num +PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int PREHOOK: type: QUERY PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_int PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_int@part=1 #### A mas
<TRUNCATED>
