http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_table.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_table.q.out index bfa8195..078a8bf 100644 --- a/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_mapwork_table.q.out @@ -176,39 +176,32 @@ POSTHOOK: Lineage: table_add_int_permute_select.c EXPRESSION [(values__tmp__tabl POSTHOOK: Lineage: table_add_int_permute_select.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,a,b from table_add_int_permute_select order by insert_num +select insert_num,a,b from table_add_int_permute_select PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,a,b from table_add_int_permute_select order by insert_num +select insert_num,a,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=12) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=12) Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=12) - Output:["_col0","_col1","_col2"] - TableScan [TS_0] (rows=4 width=12) - default@table_add_int_permute_select,table_add_int_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"] + TableScan [TS_0] (rows=4 width=12) + default@table_add_int_permute_select,table_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,a,b from table_add_int_permute_select order by insert_num +select insert_num,a,b from table_add_int_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_permute_select #### A masked pattern was here #### POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,a,b from table_add_int_permute_select order by insert_num +select insert_num,a,b from table_add_int_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_permute_select #### A masked pattern was here #### @@ -223,11 +216,11 @@ insert_num a b 7 3 new 8 4 new 9 5 new -PREHOOK: query: select insert_num,a,b,c from table_add_int_permute_select order by insert_num +PREHOOK: query: select insert_num,a,b,c from table_add_int_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,a,b,c from table_add_int_permute_select order by insert_num +POSTHOOK: query: select insert_num,a,b,c from table_add_int_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_permute_select #### A masked pattern was here #### @@ -242,11 +235,11 @@ insert_num a b c 7 3 new 30 8 4 new 40 9 5 new 100 -PREHOOK: query: select insert_num,c from table_add_int_permute_select order by insert_num +PREHOOK: query: select insert_num,c from table_add_int_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c from table_add_int_permute_select order by insert_num +POSTHOOK: query: select insert_num,c from table_add_int_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_permute_select #### A masked pattern was here #### @@ -430,39 +423,32 @@ POSTHOOK: Lineage: table_add_int_string_permute_select.d SIMPLE [(values__tmp__t POSTHOOK: Lineage: table_add_int_string_permute_select.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,a,b from table_add_int_string_permute_select order by insert_num +select insert_num,a,b from table_add_int_string_permute_select PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,a,b from table_add_int_string_permute_select order by insert_num +select insert_num,a,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=12) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=12) Output:["_col0","_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=12) - Output:["_col0","_col1","_col2"] - TableScan [TS_0] (rows=4 width=12) - default@table_add_int_string_permute_select,table_add_int_string_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"] + TableScan [TS_0] (rows=4 width=12) + default@table_add_int_string_permute_select,table_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,a,b from table_add_int_string_permute_select order by insert_num +select insert_num,a,b from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,a,b from table_add_int_string_permute_select order by insert_num +select insert_num,a,b from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -477,11 +463,11 @@ insert_num a b 7 3 new 8 4 new 9 5 new -PREHOOK: query: select insert_num,a,b,c from table_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,a,b,c from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,a,b,c from table_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,a,b,c from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -496,11 +482,11 @@ insert_num a b c 7 3 new 30 8 4 new 40 9 5 new 100 -PREHOOK: query: select insert_num,a,b,c,d from table_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,a,b,c,d from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,a,b,c,d from table_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,a,b,c,d from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -515,11 +501,11 @@ insert_num a b c d 7 3 new 30 thirty 8 4 new 40 forty 9 5 new 100 hundred -PREHOOK: query: select insert_num,a,c,d from table_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,a,c,d from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,a,c,d from table_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,a,c,d from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -534,11 +520,11 @@ insert_num a c d 7 3 30 thirty 8 4 40 forty 9 5 100 hundred -PREHOOK: query: select insert_num,a,d from table_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,a,d from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,a,d from table_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,a,d from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -553,11 +539,11 @@ insert_num a d 7 3 thirty 8 4 forty 9 5 hundred -PREHOOK: query: select insert_num,c from table_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,c from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c from table_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,c from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -572,11 +558,11 @@ insert_num c 7 30 8 40 9 100 -PREHOOK: query: select insert_num,d from table_add_int_string_permute_select order by insert_num +PREHOOK: query: select insert_num,d from table_add_int_string_permute_select PREHOOK: type: QUERY PREHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### -POSTHOOK: query: select insert_num,d from table_add_int_string_permute_select order by insert_num +POSTHOOK: query: select insert_num,d from table_add_int_string_permute_select POSTHOOK: type: QUERY POSTHOOK: Input: default@table_add_int_string_permute_select #### A masked pattern was here #### @@ -694,37 +680,30 @@ POSTHOOK: Lineage: table_change_string_group_double.c3 EXPRESSION [(values__tmp_ POSTHOOK: Lineage: table_change_string_group_double.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,c1,c2,c3,b from table_change_string_group_double order by insert_num +select insert_num,c1,c2,c3,b from table_change_string_group_double PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=37) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=37) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=37) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=37) - default@table_change_string_group_double,table_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=37) + default@table_change_string_group_double,table_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_double #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_double #### A masked pattern was here #### @@ -846,37 +825,30 @@ POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c5 EXPRESSION POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.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,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num +select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num +select insert_num,c1,c2,c3,c4,c5,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=3 width=150) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=3 width=150) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=3 width=150) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=3 width=150) - default@table_change_date_group_string_group_timestamp,table_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] + TableScan [TS_0] (rows=3 width=150) + default@table_change_date_group_string_group_timestamp,table_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] -PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp PREHOOK: type: QUERY PREHOOK: Input: default@table_change_date_group_string_group_timestamp #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_date_group_string_group_timestamp #### A masked pattern was here #### @@ -1014,37 +986,30 @@ POSTHOOK: Lineage: table_change_date_group_string_group_date.c5 EXPRESSION [(val POSTHOOK: Lineage: table_change_date_group_string_group_date.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,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num +select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num +select insert_num,c1,c2,c3,c4,c5,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=3 width=65) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=3 width=65) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=3 width=65) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=3 width=65) - default@table_change_date_group_string_group_date,table_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] + TableScan [TS_0] (rows=3 width=65) + default@table_change_date_group_string_group_date,table_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] -PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date PREHOOK: type: QUERY PREHOOK: Input: default@table_change_date_group_string_group_date #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_date_group_string_group_date #### A masked pattern was here #### @@ -1111,11 +1076,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c3 POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c4 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string #### A masked pattern was here #### @@ -1162,37 +1127,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c4 POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num +select insert_num,c1,c2,c3,c4,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=37) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=37) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=37) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=37) - default@table_change_numeric_group_string_group_multi_ints_string,table_change_numeric_group_string_group_multi_ints_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=4 width=37) + default@table_change_numeric_group_string_group_multi_ints_string,table_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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string #### A masked pattern was here #### @@ -1252,11 +1210,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c3 EX POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c4 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char #### A masked pattern was here #### @@ -1303,37 +1261,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c4 EX POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num +select insert_num,c1,c2,c3,c4,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=37) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=37) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=37) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=37) - default@table_change_numeric_group_string_group_multi_ints_char,table_change_numeric_group_string_group_multi_ints_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=4 width=37) + default@table_change_numeric_group_string_group_multi_ints_char,table_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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char #### A masked pattern was here #### @@ -1393,11 +1344,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.c4 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc #### A masked pattern was here #### @@ -1444,37 +1395,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +select insert_num,c1,c2,c3,c4,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=37) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=37) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=37) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=37) - default@table_change_numeric_group_string_group_multi_ints_char_trunc,table_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=4 width=37) + default@table_change_numeric_group_string_group_multi_ints_char_trunc,table_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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc #### A masked pattern was here #### @@ -1534,11 +1478,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.c3 POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.c4 EXPRESSION [(values__tmp__table__21)values__tmp__table__21.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar #### A masked pattern was here #### @@ -1585,37 +1529,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.c4 POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num +select insert_num,c1,c2,c3,c4,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=37) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=37) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=37) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=37) - default@table_change_numeric_group_string_group_multi_ints_varchar,table_change_numeric_group_string_group_multi_ints_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=4 width=37) + default@table_change_numeric_group_string_group_multi_ints_varchar,table_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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar #### A masked pattern was here #### @@ -1675,11 +1612,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_tr POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.c4 EXPRESSION [(values__tmp__table__23)values__tmp__table__23.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc #### A masked pattern was here #### @@ -1726,37 +1663,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_tr POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +select insert_num,c1,c2,c3,c4,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=37) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=37) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=37) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=37) - default@table_change_numeric_group_string_group_multi_ints_varchar_trunc,table_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=4 width=37) + default@table_change_numeric_group_string_group_multi_ints_varchar_trunc,table_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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc #### A masked pattern was here #### @@ -1815,11 +1745,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.c2 EX POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.c3 EXPRESSION [(values__tmp__table__25)values__tmp__table__25.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.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,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_string #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string #### A masked pattern was here #### @@ -1865,37 +1795,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.c3 SI POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.insert_num EXPRESSION [(values__tmp__table__26)values__tmp__table__26.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=53) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=53) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=53) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=53) - default@table_change_numeric_group_string_group_floating_string,table_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=53) + default@table_change_numeric_group_string_group_floating_string,table_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_string #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string #### A masked pattern was here #### @@ -1954,11 +1877,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.c2 EXPR POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.c3 EXPRESSION [(values__tmp__table__27)values__tmp__table__27.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.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,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_char #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char #### A masked pattern was here #### @@ -2004,37 +1927,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.c3 EXPR POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.insert_num EXPRESSION [(values__tmp__table__28)values__tmp__table__28.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=55) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=55) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=55) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=55) - default@table_change_numeric_group_string_group_floating_char,table_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=55) + default@table_change_numeric_group_string_group_floating_char,table_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_char #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char #### A masked pattern was here #### @@ -2093,11 +2009,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.c POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.c3 EXPRESSION [(values__tmp__table__29)values__tmp__table__29.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.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,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc #### A masked pattern was here #### @@ -2143,37 +2059,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.c POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.insert_num EXPRESSION [(values__tmp__table__30)values__tmp__table__30.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=53) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=53) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=53) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=53) - default@table_change_numeric_group_string_group_floating_char_trunc,table_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=53) + default@table_change_numeric_group_string_group_floating_char_trunc,table_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc #### A masked pattern was here #### @@ -2232,11 +2141,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.c2 E POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.c3 EXPRESSION [(values__tmp__table__31)values__tmp__table__31.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.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,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar #### A masked pattern was here #### @@ -2282,37 +2191,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.c3 E POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.insert_num EXPRESSION [(values__tmp__table__32)values__tmp__table__32.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=50) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=50) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=50) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=50) - default@table_change_numeric_group_string_group_floating_varchar,table_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=50) + default@table_change_numeric_group_string_group_floating_varchar,table_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar #### A masked pattern was here #### @@ -2371,11 +2273,11 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trun POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.c3 EXPRESSION [(values__tmp__table__33)values__tmp__table__33.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.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,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc #### A masked pattern was here #### @@ -2421,37 +2323,30 @@ POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trun POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.insert_num EXPRESSION [(values__tmp__table__34)values__tmp__table__34.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=55) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=55) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=55) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=55) - default@table_change_numeric_group_string_group_floating_varchar_trunc,table_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=55) + default@table_change_numeric_group_string_group_floating_varchar_trunc,table_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc PREHOOK: type: QUERY PREHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc #### A masked pattern was here #### @@ -2519,11 +2414,11 @@ POSTHOOK: Lineage: table_change_string_group_string_group_string.c3 SIMPLE [(val POSTHOOK: Lineage: table_change_string_group_string_group_string.c4 SIMPLE [(values__tmp__table__35)values__tmp__table__35.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_string.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,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_string_group_string #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_string_group_string #### A masked pattern was here #### @@ -2570,37 +2465,30 @@ POSTHOOK: Lineage: table_change_string_group_string_group_string.c4 EXPRESSION [ POSTHOOK: Lineage: table_change_string_group_string_group_string.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num +select insert_num,c1,c2,c3,c4,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=59) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=59) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=59) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=59) - default@table_change_string_group_string_group_string,table_change_string_group_string_group_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=4 width=59) + default@table_change_string_group_string_group_string,table_change_string_group_string_group_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] -PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_string_group_string #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_string_group_string #### A masked pattern was here #### @@ -2659,11 +2547,11 @@ POSTHOOK: Lineage: table_change_string_group_string_group_char.c2 EXPRESSION [(v POSTHOOK: Lineage: table_change_string_group_string_group_char.c3 EXPRESSION [(values__tmp__table__37)values__tmp__table__37.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_char.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,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_string_group_char #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_string_group_char #### A masked pattern was here #### @@ -2709,37 +2597,30 @@ POSTHOOK: Lineage: table_change_string_group_string_group_char.c3 SIMPLE [(value POSTHOOK: Lineage: table_change_string_group_string_group_char.insert_num EXPRESSION [(values__tmp__table__38)values__tmp__table__38.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num +select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=44) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=44) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=44) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=44) - default@table_change_string_group_string_group_char,table_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=44) + default@table_change_string_group_string_group_char,table_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_string_group_char #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_string_group_char #### A masked pattern was here #### @@ -2798,11 +2679,11 @@ POSTHOOK: Lineage: table_change_string_group_string_group_varchar.c2 EXPRESSION POSTHOOK: Lineage: table_change_string_group_string_group_varchar.c3 EXPRESSION [(values__tmp__table__39)values__tmp__table__39.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_varchar.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,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_string_group_varchar #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_string_group_varchar #### A masked pattern was here #### @@ -2848,37 +2729,30 @@ POSTHOOK: Lineage: table_change_string_group_string_group_varchar.c3 SIMPLE [(va POSTHOOK: Lineage: table_change_string_group_string_group_varchar.insert_num EXPRESSION [(values__tmp__table__40)values__tmp__table__40.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num +select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num +select insert_num,c1,c2,c3,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=46) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=46) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=46) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=46) - default@table_change_string_group_string_group_varchar,table_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=46) + default@table_change_string_group_string_group_varchar,table_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar PREHOOK: type: QUERY PREHOOK: Input: default@table_change_string_group_string_group_varchar #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_string_group_string_group_varchar #### A masked pattern was here #### @@ -2948,11 +2822,11 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.c5 EXPRESS POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.c6 EXPRESSION [(values__tmp__table__41)values__tmp__table__41.FieldSchema(name:tmp_values_col7, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.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,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint #### A masked pattern was here #### @@ -3001,37 +2875,30 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.c6 EXPRESS POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num +select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num +select insert_num,c1,c2,c3,c4,c5,c6,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=29) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=29) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=29) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - TableScan [TS_0] (rows=4 width=29) - default@table_change_lower_to_higher_numeric_group_tinyint,table_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=4 width=29) + default@table_change_lower_to_higher_numeric_group_tinyint,table_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,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint #### A masked pattern was here #### @@ -3092,11 +2959,11 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.c4 EXPRES POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.c5 EXPRESSION [(values__tmp__table__43)values__tmp__table__43.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.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,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint #### A masked pattern was here #### @@ -3144,37 +3011,30 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.c5 EXPRES POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.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 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num +select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num +select insert_num,c1,c2,c3,c4,c5,b from table_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 vectorized, llap - File Output Operator [FS_8] - Select Operator [SEL_7] (rows=4 width=32) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=32) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=32) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=4 width=32) - default@table_change_lower_to_higher_numeric_group_smallint,table_change_lower_to_higher_numeric_group_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"] + TableScan [TS_0] (rows=4 width=32) + default@table_change_lower_to_higher_numeric_group_smallint,table_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,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint #### A masked pattern was here #### @@ -3234,11 +3094,11 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.c3 EXPRESSION POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.c4 EXPRESSION [(values__tmp__table__45)values__tmp__table__45.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.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,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_int #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int #### A masked pattern was here #### @@ -3285,37 +3145,30 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.c4 EXPRESSION POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.insert_num EXPRESSION [(values__tmp__table__46)values__tmp__table__46.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 _col5 PREHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num +select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_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=4 width=33) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=33) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=33) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=4 width=33) - default@table_change_lower_to_higher_numeric_group_int,table_change_lower_to_higher_numeric_group_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] + TableScan [TS_0] (rows=4 width=33) + default@table_change_lower_to_higher_numeric_group_int,table_change_lower_to_higher_numeric_group_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"] -PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_int #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int #### A masked pattern was here #### @@ -3374,11 +3227,11 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.c2 EXPRESSI POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.c3 EXPRESSION [(values__tmp__table__47)values__tmp__table__47.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.insert_num EXPRESSION [(values__tmp__table__47)values__tmp__table__47.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint #### A masked pattern was here #### @@ -3424,37 +3277,30 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.c3 EXPRESSI POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.insert_num EXPRESSION [(values__tmp__table__48)values__tmp__table__48.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 _col4 PREHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num +select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num +select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_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=4 width=31) + Map 1 vectorized, llap + File Output Operator [FS_4] + Select Operator [SEL_3] (rows=4 width=31) Output:["_col0","_col1","_col2","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] vectorized, llap - SHUFFLE [RS_6] - Select Operator [SEL_5] (rows=4 width=31) - Output:["_col0","_col1","_col2","_col3","_col4"] - TableScan [TS_0] (rows=4 width=31) - default@table_change_lower_to_higher_numeric_group_bigint,table_change_lower_to_higher_numeric_group_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] + TableScan [TS_0] (rows=4 width=31) + default@table_change_lower_to_higher_numeric_group_bigint,table_change_lower_to_higher_numeric_group_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"] -PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num +PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num +POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint #### A masked pattern was here #### @@ -3512,11 +3358,11 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESS POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 -PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal PREHOOK: type: QUERY PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### @@ -3561,37 +3407,30 @@ POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c2 EXPRESS POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 PREHOOK: query: explain -select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_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
<TRUNCATED>
