http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/results/clientpositive/schema_evol_orc_vec_mapwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/schema_evol_orc_vec_mapwork_part.q.out b/ql/src/test/results/clientpositive/schema_evol_orc_vec_mapwork_part.q.out index d5bcda5..06a2cae 100644 --- a/ql/src/test/results/clientpositive/schema_evol_orc_vec_mapwork_part.q.out +++ b/ql/src/test/results/clientpositive/schema_evol_orc_vec_mapwork_part.q.out @@ -172,10 +172,10 @@ 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 STAGE DEPENDENCIES: @@ -193,24 +193,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), a (type: int), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 10 Data size: 994 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 994 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 994 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 994 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -219,14 +209,14 @@ STAGE PLANS: ListSink 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 @@ -243,13 +233,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 @@ -266,13 +256,13 @@ insert_num part a b c 7 2 3 new 30 8 2 4 new 40 9 1 5 new 100 -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 @@ -458,10 +448,10 @@ 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 STAGE DEPENDENCIES: @@ -479,24 +469,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), a (type: int), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 10 Data size: 1536 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 1536 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 1536 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 1536 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -505,14 +485,14 @@ STAGE PLANS: ListSink 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 @@ -529,13 +509,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 @@ -552,13 +532,13 @@ insert_num part a b c 7 2 3 new 30 8 2 4 new 40 9 1 5 new 100 -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 @@ -575,13 +555,13 @@ insert_num part a b c d 7 2 3 new 30 thirty 8 2 4 new 40 forty 9 1 5 new 100 hundred -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 @@ -598,13 +578,13 @@ insert_num part a c d 7 2 3 30 thirty 8 2 4 40 forty 9 1 5 100 hundred -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 @@ -621,13 +601,13 @@ insert_num part a d 7 2 3 thirty 8 2 4 forty 9 1 5 hundred -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 @@ -644,13 +624,13 @@ insert_num part c 7 2 30 8 2 40 9 1 100 -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 @@ -770,10 +750,10 @@ 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 STAGE DEPENDENCIES: @@ -791,24 +771,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: double), c2 (type: double), c3 (type: double), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 10 Data size: 2346 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 2346 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: double), _col4 (type: double), _col5 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 10 Data size: 2346 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 2346 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -816,13 +786,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -946,10 +916,10 @@ 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 STAGE DEPENDENCIES: @@ -967,24 +937,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: string), c2 (type: char(50)), c3 (type: char(15)), c4 (type: varchar(50)), c5 (type: varchar(15)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 9 Data size: 4770 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 9 Data size: 4770 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: string), _col3 (type: char(50)), _col4 (type: char(15)), _col5 (type: varchar(50)), _col6 (type: varchar(15)), _col7 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: string), VALUE._col2 (type: char(50)), VALUE._col3 (type: char(15)), VALUE._col4 (type: varchar(50)), VALUE._col5 (type: varchar(15)), VALUE._col6 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 - Statistics: Num rows: 9 Data size: 4770 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 9 Data size: 4770 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -992,13 +952,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -1097,10 +1057,10 @@ 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 STAGE DEPENDENCIES: @@ -1118,24 +1078,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: string), c2 (type: char(50)), c3 (type: char(15)), c4 (type: varchar(50)), c5 (type: varchar(15)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 9 Data size: 4764 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 9 Data size: 4764 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: string), _col3 (type: char(50)), _col4 (type: char(15)), _col5 (type: varchar(50)), _col6 (type: varchar(15)), _col7 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: string), VALUE._col2 (type: char(50)), VALUE._col3 (type: char(15)), VALUE._col4 (type: varchar(50)), VALUE._col5 (type: varchar(15)), VALUE._col6 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 - Statistics: Num rows: 9 Data size: 4764 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 9 Data size: 4764 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -1143,13 +1093,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -1218,12 +1168,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 @@ -1278,10 +1228,10 @@ 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 STAGE DEPENDENCIES: @@ -1299,24 +1249,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: string), c2 (type: string), c3 (type: string), c4 (type: string), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string), VALUE._col4 (type: string), VALUE._col5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -1324,13 +1264,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -1392,12 +1332,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 @@ -1452,10 +1392,10 @@ 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 STAGE DEPENDENCIES: @@ -1473,24 +1413,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: char(50)), c2 (type: char(50)), c3 (type: char(50)), c4 (type: char(50)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 10 Data size: 4222 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 4222 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: char(50)), _col3 (type: char(50)), _col4 (type: char(50)), _col5 (type: char(50)), _col6 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(50)), VALUE._col2 (type: char(50)), VALUE._col3 (type: char(50)), VALUE._col4 (type: char(50)), VALUE._col5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 10 Data size: 4222 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 4222 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -1498,13 +1428,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -1566,12 +1496,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 @@ -1626,10 +1556,10 @@ 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 STAGE DEPENDENCIES: @@ -1647,24 +1577,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: char(5)), c2 (type: char(5)), c3 (type: char(5)), c4 (type: char(5)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 10 Data size: 3142 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3142 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: char(5)), _col3 (type: char(5)), _col4 (type: char(5)), _col5 (type: char(5)), _col6 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(5)), VALUE._col2 (type: char(5)), VALUE._col3 (type: char(5)), VALUE._col4 (type: char(5)), VALUE._col5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 10 Data size: 3142 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3142 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -1672,13 +1592,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -1740,12 +1660,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 @@ -1800,10 +1720,10 @@ 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 STAGE DEPENDENCIES: @@ -1821,24 +1741,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: varchar(50)), c2 (type: varchar(50)), c3 (type: varchar(50)), c4 (type: varchar(50)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: varchar(50)), _col3 (type: varchar(50)), _col4 (type: varchar(50)), _col5 (type: varchar(50)), _col6 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: varchar(50)), VALUE._col2 (type: varchar(50)), VALUE._col3 (type: varchar(50)), VALUE._col4 (type: varchar(50)), VALUE._col5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3138 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -1846,13 +1756,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -1914,12 +1824,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 @@ -1974,10 +1884,10 @@ 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 STAGE DEPENDENCIES: @@ -1995,24 +1905,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: varchar(5)), c2 (type: varchar(5)), c3 (type: varchar(5)), c4 (type: varchar(5)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 10 Data size: 3116 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3116 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: varchar(5)), _col3 (type: varchar(5)), _col4 (type: varchar(5)), _col5 (type: varchar(5)), _col6 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: varchar(5)), VALUE._col2 (type: varchar(5)), VALUE._col3 (type: varchar(5)), VALUE._col4 (type: varchar(5)), VALUE._col5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 10 Data size: 3116 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3116 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -2020,13 +1920,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -2087,12 +1987,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 @@ -2145,10 +2045,10 @@ 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 STAGE DEPENDENCIES: @@ -2166,24 +2066,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: string), c2 (type: string), c3 (type: string), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string), VALUE._col4 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -2191,13 +2081,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -2258,12 +2148,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 @@ -2316,10 +2206,10 @@ 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 STAGE DEPENDENCIES: @@ -2337,24 +2227,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: char(50)), c2 (type: char(50)), c3 (type: char(50)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 10 Data size: 3838 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3838 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: char(50)), _col3 (type: char(50)), _col4 (type: char(50)), _col5 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(50)), VALUE._col2 (type: char(50)), VALUE._col3 (type: char(50)), VALUE._col4 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 10 Data size: 3838 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3838 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -2362,13 +2242,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -2429,12 +2309,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 @@ -2487,10 +2367,10 @@ 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 STAGE DEPENDENCIES: @@ -2508,24 +2388,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: char(7)), c2 (type: char(7)), c3 (type: char(7)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 10 Data size: 3064 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3064 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: char(7)), _col3 (type: char(7)), _col4 (type: char(7)), _col5 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(7)), VALUE._col2 (type: char(7)), VALUE._col3 (type: char(7)), VALUE._col4 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 10 Data size: 3064 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3064 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -2533,13 +2403,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -2600,12 +2470,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 @@ -2658,10 +2528,10 @@ 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 STAGE DEPENDENCIES: @@ -2679,24 +2549,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: varchar(50)), c2 (type: varchar(50)), c3 (type: varchar(50)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: varchar(50)), _col3 (type: varchar(50)), _col4 (type: varchar(50)), _col5 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: varchar(50)), VALUE._col2 (type: varchar(50)), VALUE._col3 (type: varchar(50)), VALUE._col4 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3046 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -2704,13 +2564,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -2771,12 +2631,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 @@ -2829,10 +2689,10 @@ 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 STAGE DEPENDENCIES: @@ -2850,24 +2710,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: varchar(7)), c2 (type: varchar(7)), c3 (type: varchar(7)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 10 Data size: 3024 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 3024 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: varchar(7)), _col3 (type: varchar(7)), _col4 (type: varchar(7)), _col5 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: varchar(7)), VALUE._col2 (type: varchar(7)), VALUE._col3 (type: varchar(7)), VALUE._col4 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 10 Data size: 3024 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 3024 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -2875,13 +2725,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -2951,12 +2801,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 @@ -3011,10 +2861,10 @@ 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 STAGE DEPENDENCIES: @@ -3032,24 +2882,14 @@ STAGE PLANS: expressions: insert_num (type: int), part (type: int), c1 (type: char(50)), c2 (type: char(9)), c3 (type: varchar(50)), c4 (type: char(9)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 10 Data size: 4964 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + + File Output Operator + compressed: false Statistics: Num rows: 10 Data size: 4964 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: char(50)), _col3 (type: char(9)), _col4 (type: varchar(50)), _col5 (type: char(9)), _col6 (type: string) + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Execution mode: vectorized - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(50)), VALUE._col2 (type: char(9)), VALUE._col3 (type: varchar(50)), VALUE._col4 (type: char(9)), VALUE._col5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 10 Data size: 4964 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 4964 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -3057,13 +2897,13 @@ STAGE PLANS: Processor Tree: ListSink -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 @@ -3124,12 +2964,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 @@ -3182,10 +3022,10 @@ 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_
<TRUNCATED>
