http://git-wip-us.apache.org/repos/asf/hive/blob/c46c4c90/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_part_llap_io.q.out
----------------------------------------------------------------------
diff --git
a/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_part_llap_io.q.out
b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_part_llap_io.q.out
index 1c95272..5731bef 100644
---
a/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_part_llap_io.q.out
+++
b/ql/src/test/results/clientpositive/llap/schema_evol_text_vecrow_part_llap_io.q.out
@@ -119,6 +119,98 @@ POSTHOOK: Input: default@part_add_int_permute_select@part=1
#### A masked pattern was here ####
insert_num part a b
1 1 1111 new
+PREHOOK: query: alter table part_add_int_permute_select add columns(c int)
+PREHOOK: type: ALTERTABLE_ADDCOLS
+PREHOOK: Input: default@part_add_int_permute_select
+PREHOOK: Output: default@part_add_int_permute_select
+POSTHOOK: query: alter table part_add_int_permute_select add columns(c int)
+POSTHOOK: type: ALTERTABLE_ADDCOLS
+POSTHOOK: Input: default@part_add_int_permute_select
+POSTHOOK: Output: default@part_add_int_permute_select
+PREHOOK: query: insert into table part_add_int_permute_select
partition(part=1) VALUES (2, 2222, 'new', 3333)
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output: default@part_add_int_permute_select@part=1
+POSTHOOK: query: insert into table part_add_int_permute_select
partition(part=1) VALUES (2, 2222, 'new', 3333)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output: default@part_add_int_permute_select@part=1
+POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).a SCRIPT []
+POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).c SCRIPT []
+POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).insert_num
SCRIPT []
+col1 col2 col3 col4
+PREHOOK: query: explain vectorization detail
+select insert_num,part,a,b from part_add_int_permute_select
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,a,b from part_add_int_permute_select
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: part_add_int_permute_select
+ Statistics: Num rows: 2 Data size: 198 Basic stats: COMPLETE
Column stats: COMPLETE
+ TableScan Vectorization:
+ native: true
+ vectorizationSchemaColumns: [0:insert_num:int, 1:a:int,
2:b:string, 3:c:int, 4:part:int,
5:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), a
(type: int), b (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Select Vectorization:
+ className: VectorSelectOperator
+ native: true
+ projectedOutputColumnNums: [0, 4, 1, 2]
+ Statistics: Num rows: 2 Data size: 198 Basic stats:
COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ File Sink Vectorization:
+ className: VectorFileSinkOperator
+ native: false
+ Statistics: Num rows: 2 Data size: 198 Basic stats:
COMPLETE Column stats: COMPLETE
+ 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, llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: true
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ inputFormatFeatureSupport: []
+ featureSupportInUse: []
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+ allNative: false
+ usesVectorUDFAdaptor: false
+ vectorized: true
+ rowBatchContext:
+ dataColumnCount: 4
+ includeColumns: [0, 1, 2]
+ dataColumns: insert_num:int, a:int, b:string, c:int
+ partitionColumnCount: 1
+ partitionColumns: part:int
+ scratchColumnTypeNames: []
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table part_add_int_permute_select
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_add_int_permute_select
@@ -230,6 +322,99 @@ POSTHOOK: Input:
default@part_add_int_string_permute_select@part=1
#### A masked pattern was here ####
insert_num part a b
1 1 1111 new
+PREHOOK: query: alter table part_add_int_string_permute_select add columns(c
int, d string)
+PREHOOK: type: ALTERTABLE_ADDCOLS
+PREHOOK: Input: default@part_add_int_string_permute_select
+PREHOOK: Output: default@part_add_int_string_permute_select
+POSTHOOK: query: alter table part_add_int_string_permute_select add columns(c
int, d string)
+POSTHOOK: type: ALTERTABLE_ADDCOLS
+POSTHOOK: Input: default@part_add_int_string_permute_select
+POSTHOOK: Output: default@part_add_int_string_permute_select
+PREHOOK: query: insert into table part_add_int_string_permute_select
partition(part=1) VALUES (2, 2222, 'new', 3333, '4444')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output: default@part_add_int_string_permute_select@part=1
+POSTHOOK: query: insert into table part_add_int_string_permute_select
partition(part=1) VALUES (2, 2222, 'new', 3333, '4444')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output: default@part_add_int_string_permute_select@part=1
+POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).a
SCRIPT []
+POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).b
SCRIPT []
+POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).c
SCRIPT []
+POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).d
SCRIPT []
+POSTHOOK: Lineage: part_add_int_string_permute_select
PARTITION(part=1).insert_num SCRIPT []
+col1 col2 col3 col4 col5
+PREHOOK: query: explain vectorization detail
+select insert_num,part,a,b from part_add_int_string_permute_select
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,a,b from part_add_int_string_permute_select
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: part_add_int_string_permute_select
+ Statistics: Num rows: 2 Data size: 198 Basic stats: COMPLETE
Column stats: COMPLETE
+ TableScan Vectorization:
+ native: true
+ vectorizationSchemaColumns: [0:insert_num:int, 1:a:int,
2:b:string, 3:c:int, 4:d:string, 5:part:int,
6:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), a
(type: int), b (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Select Vectorization:
+ className: VectorSelectOperator
+ native: true
+ projectedOutputColumnNums: [0, 5, 1, 2]
+ Statistics: Num rows: 2 Data size: 198 Basic stats:
COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ File Sink Vectorization:
+ className: VectorFileSinkOperator
+ native: false
+ Statistics: Num rows: 2 Data size: 198 Basic stats:
COMPLETE Column stats: COMPLETE
+ 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, llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: true
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ inputFormatFeatureSupport: []
+ featureSupportInUse: []
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+ allNative: false
+ usesVectorUDFAdaptor: false
+ vectorized: true
+ rowBatchContext:
+ dataColumnCount: 5
+ includeColumns: [0, 1, 2]
+ dataColumns: insert_num:int, a:int, b:string, c:int,
d:string
+ partitionColumnCount: 1
+ partitionColumns: part:int
+ scratchColumnTypeNames: []
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table part_add_int_string_permute_select
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_add_int_string_permute_select
@@ -347,6 +532,78 @@ insert_num part c1 c2 c3 b
103 1
original
104 1 30.774 30.774
30.774 original
105 1 46114.28 46114.28
46114.28 original
+PREHOOK: query: alter table part_change_string_group_double replace columns
(insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@part_change_string_group_double
+PREHOOK: Output: default@part_change_string_group_double
+POSTHOOK: query: alter table part_change_string_group_double replace columns
(insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@part_change_string_group_double
+POSTHOOK: Output: default@part_change_string_group_double
+PREHOOK: query: insert into table part_change_string_group_double
partition(part=1) SELECT insert_num, double1, double1, double1, 'new' FROM
schema_evolution_data WHERE insert_num = 111
+PREHOOK: type: QUERY
+PREHOOK: Input: default@schema_evolution_data
+PREHOOK: Output: default@part_change_string_group_double@part=1
+POSTHOOK: query: insert into table part_change_string_group_double
partition(part=1) SELECT insert_num, double1, double1, double1, 'new' FROM
schema_evolution_data WHERE insert_num = 111
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@schema_evolution_data
+POSTHOOK: Output: default@part_change_string_group_double@part=1
+POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).b SIMPLE
[]
+POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c1 SIMPLE
[(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1,
type:double, comment:null), ]
+POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c2 SIMPLE
[(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1,
type:double, comment:null), ]
+POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c3 SIMPLE
[(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1,
type:double, comment:null), ]
+POSTHOOK: Lineage: part_change_string_group_double
PARTITION(part=1).insert_num SIMPLE
[(schema_evolution_data)schema_evolution_data.FieldSchema(name:insert_num,
type:int, comment:null), ]
+insert_num double1 double1 double1 _c4
+PREHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,b from part_change_string_group_double
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,b from part_change_string_group_double
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: part_change_string_group_double
+ Statistics: Num rows: 5 Data size: 1955 Basic stats:
COMPLETE Column stats: COMPLETE
+ Select Operator
+ 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: 5 Data size: 1955 Basic stats:
COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 5 Data size: 1955 Basic stats:
COMPLETE Column stats: COMPLETE
+ 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: llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: false
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table part_change_string_group_double
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_string_group_double
@@ -471,6 +728,85 @@ insert_num part c1 c2 c3 c4 c5
c6 c7 c8 c9 c10 b
103 1 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL original
104 1 2021-09-24 2021-09-24 2021-09-24 2021-09-24
2021-09-24 1978-08-02 06:34:14 1978-08-02 06:34:14 1978-08-02
06:34:14 1978-08-02 06:34:14 1978-08-02 06:34:14 original
105 1 2024-11-11 2024-11-11 2024-11-11 2024-11-11
2024-11-11 1991-01-06 16:20:39.72036854 1991-01-06 16:20:39.72036854
1991-01-06 16:20:39.72036854 1991-01-06 16:20:39.72036854 1991-01-06
16:20:39.72036854 original
+PREHOOK: query: alter table part_change_date_group_string_group_date_timestamp
replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4
VARCHAR(50), c5 VARCHAR(15), c6 STRING, c7 CHAR(50), c8 CHAR(15), c9
VARCHAR(50), c10 VARCHAR(15), b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@part_change_date_group_string_group_date_timestamp
+PREHOOK: Output: default@part_change_date_group_string_group_date_timestamp
+POSTHOOK: query: alter table
part_change_date_group_string_group_date_timestamp replace columns(insert_num
int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), c6
STRING, c7 CHAR(50), c8 CHAR(15), c9 VARCHAR(50), c10 VARCHAR(15), b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@part_change_date_group_string_group_date_timestamp
+POSTHOOK: Output: default@part_change_date_group_string_group_date_timestamp
+PREHOOK: query: insert into table
part_change_date_group_string_group_date_timestamp partition(part=1) VALUES
(111, 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
'filler', 'filler', 'filler', 'new')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output:
default@part_change_date_group_string_group_date_timestamp@part=1
+POSTHOOK: query: insert into table
part_change_date_group_string_group_date_timestamp partition(part=1) VALUES
(111, 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
'filler', 'filler', 'filler', 'new')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output:
default@part_change_date_group_string_group_date_timestamp@part=1
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c1 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c10 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c2 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c3 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c4 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c5 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c6 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c7 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c8 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).c9 SCRIPT []
+POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp
PARTITION(part=1).insert_num SCRIPT []
+_col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 _col8 _col9
_col10 _col11
+PREHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from
part_change_date_group_string_group_date_timestamp
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from
part_change_date_group_string_group_date_timestamp
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: part_change_date_group_string_group_date_timestamp
+ Statistics: Num rows: 6 Data size: 9960 Basic stats:
COMPLETE Column stats: PARTIAL
+ Select Operator
+ 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)), c6 (type: string), c7 (type: char(50)),
c8 (type: char(15)), c9 (type: varchar(50)), c10 (type: varchar(15)), b (type:
string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
+ Statistics: Num rows: 6 Data size: 8952 Basic stats:
COMPLETE Column stats: PARTIAL
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 8952 Basic stats:
COMPLETE Column stats: PARTIAL
+ 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: llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: false
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table part_change_date_group_string_group_date_timestamp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_date_group_string_group_date_timestamp
@@ -558,46 +894,167 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias:
part_change_numeric_group_string_group_multi_ints_string_group
- Statistics: Num rows: 5 Data size: 940 Basic stats: COMPLETE
Column stats: COMPLETE
- TableScan Vectorization:
- native: true
- vectorizationSchemaColumns: [0:insert_num:int,
1:c1:tinyint, 2:c2:smallint, 3:c3:int, 4:c4:bigint, 5:c5:tinyint,
6:c6:smallint, 7:c7:int, 8:c8:bigint, 9:c9:tinyint, 10:c10:smallint,
11:c11:int, 12:c12:bigint, 13:c13:tinyint, 14:c14:smallint, 15:c15:int,
16:c16:bigint, 17:c17:tinyint, 18:c18:smallint, 19:c19:int, 20:c20:bigint,
21:b:string, 22:part:int,
23:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
+ Statistics: Num rows: 5 Data size: 940 Basic stats: COMPLETE
Column stats: COMPLETE
+ TableScan Vectorization:
+ native: true
+ vectorizationSchemaColumns: [0:insert_num:int,
1:c1:tinyint, 2:c2:smallint, 3:c3:int, 4:c4:bigint, 5:c5:tinyint,
6:c6:smallint, 7:c7:int, 8:c8:bigint, 9:c9:tinyint, 10:c10:smallint,
11:c11:int, 12:c12:bigint, 13:c13:tinyint, 14:c14:smallint, 15:c15:int,
16:c16:bigint, 17:c17:tinyint, 18:c18:smallint, 19:c19:int, 20:c20:bigint,
21:b:string, 22:part:int,
23:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), c1
(type: tinyint), c2 (type: smallint), c3 (type: int), c4 (type: bigint), c5
(type: tinyint), c6 (type: smallint), c7 (type: int), c8 (type: bigint), c9
(type: tinyint), c10 (type: smallint), c11 (type: int), c12 (type: bigint), c13
(type: tinyint), c14 (type: smallint), c15 (type: int), c16 (type: bigint), c17
(type: tinyint), c18 (type: smallint), c19 (type: int), c20 (type: bigint), b
(type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14,
_col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22
+ Select Vectorization:
+ className: VectorSelectOperator
+ native: true
+ projectedOutputColumnNums: [0, 22, 1, 2, 3, 4, 5, 6,
7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21]
+ Statistics: Num rows: 5 Data size: 940 Basic stats:
COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ File Sink Vectorization:
+ className: VectorFileSinkOperator
+ native: false
+ Statistics: Num rows: 5 Data size: 940 Basic stats:
COMPLETE Column stats: COMPLETE
+ 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, llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: true
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ inputFormatFeatureSupport: []
+ featureSupportInUse: []
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+ allNative: false
+ usesVectorUDFAdaptor: false
+ vectorized: true
+ rowBatchContext:
+ dataColumnCount: 22
+ includeColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12,
13, 14, 15, 16, 17, 18, 19, 20, 21]
+ dataColumns: insert_num:int, c1:tinyint, c2:smallint,
c3:int, c4:bigint, c5:tinyint, c6:smallint, c7:int, c8:bigint, c9:tinyint,
c10:smallint, c11:int, c12:bigint, c13:tinyint, c14:smallint, c15:int,
c16:bigint, c17:tinyint, c18:smallint, c19:int, c20:bigint, b:string
+ partitionColumnCount: 1
+ partitionColumns: part:int
+ scratchColumnTypeNames: []
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
from part_change_numeric_group_string_group_multi_ints_string_group
+PREHOOK: type: QUERY
+PREHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
+PREHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group@part=1
+#### A masked pattern was here ####
+POSTHOOK: query: select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
from part_change_numeric_group_string_group_multi_ints_string_group
+POSTHOOK: type: QUERY
+POSTHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
+POSTHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group@part=1
+#### A masked pattern was here ####
+insert_num part c1 c2 c3 c4 c5 c6 c7
c8 c9 c10 c11 c12 c13 c14 c15 c16 c17
c18 c19 c20 b
+101 1 -128 NULL -2147483648 NULL -128 NULL
-2147483648 NULL -128 NULL -2147483648 NULL -128 NULL
-2147483648 NULL -128 NULL -2147483648 NULL original
+102 1 127 32767 2147483647 9223372036854775807 127
32767 2147483647 9223372036854775807 127 32767 2147483647
9223372036854775807 127 32767 2147483647 9223372036854775807
127 32767 2147483647 9223372036854775807 original
+103 1 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL original
+104 1 23 834 203332 888888857923222 23 834 203332
888888857923222 23 834 203332 888888857923222 23 834 203332
888888857923222 23 834 203332 888888857923222 original
+105 1 -99 -28300 -999992 -222282153733 -99 -28300 -999992
-222282153733 -99 -28300 -999992 -222282153733 -99 -28300 -999992
-222282153733 -99 -28300 -999992 -222282153733 original
+PREHOOK: query: alter table
part_change_numeric_group_string_group_multi_ints_string_group replace columns
(insert_num int,
+ c1 STRING, c2 STRING, c3 STRING, c4 STRING,
+ c5 CHAR(50), c6 CHAR(50), c7 CHAR(50), c8 CHAR(50), c9 CHAR(5),
c10 CHAR(5), c11 CHAR(5), c12 CHAR(5),
+ c13 VARCHAR(50), c14 VARCHAR(50), c15 VARCHAR(50), c16
VARCHAR(50), c17 VARCHAR(5), c18 VARCHAR(5), c19 VARCHAR(5), c20 VARCHAR(5),
+ b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
+PREHOOK: Output:
default@part_change_numeric_group_string_group_multi_ints_string_group
+POSTHOOK: query: alter table
part_change_numeric_group_string_group_multi_ints_string_group replace columns
(insert_num int,
+ c1 STRING, c2 STRING, c3 STRING, c4 STRING,
+ c5 CHAR(50), c6 CHAR(50), c7 CHAR(50), c8 CHAR(50), c9 CHAR(5),
c10 CHAR(5), c11 CHAR(5), c12 CHAR(5),
+ c13 VARCHAR(50), c14 VARCHAR(50), c15 VARCHAR(50), c16
VARCHAR(50), c17 VARCHAR(5), c18 VARCHAR(5), c19 VARCHAR(5), c20 VARCHAR(5),
+ b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
+POSTHOOK: Output:
default@part_change_numeric_group_string_group_multi_ints_string_group
+PREHOOK: query: insert into table
part_change_numeric_group_string_group_multi_ints_string_group
partition(part=1) VALUES (111,
+ 'filler', 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
'filler', 'filler',
+ 'new')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output:
default@part_change_numeric_group_string_group_multi_ints_string_group@part=1
+POSTHOOK: query: insert into table
part_change_numeric_group_string_group_multi_ints_string_group
partition(part=1) VALUES (111,
+ 'filler', 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
'filler', 'filler',
+ 'new')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output:
default@part_change_numeric_group_string_group_multi_ints_string_group@part=1
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c1 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c10 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c11 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c12 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c13 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c14 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c15 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c16 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c17 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c18 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c19 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c2 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c20 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c3 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c4 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c5 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c6 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c7 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c8 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).c9 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_multi_ints_string_group
PARTITION(part=1).insert_num SCRIPT []
+_col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 _col8 _col9
_col10 _col11 _col12 _col13 _col14 _col15 _col16 _col17 _col18 _col19
_col20 _col21
+PREHOOK: query: explain vectorization detail
+select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
from part_change_numeric_group_string_group_multi_ints_string_group
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
from part_change_numeric_group_string_group_multi_ints_string_group
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias:
part_change_numeric_group_string_group_multi_ints_string_group
+ Statistics: Num rows: 6 Data size: 1140 Basic stats:
COMPLETE Column stats: COMPLETE
Select Operator
- expressions: insert_num (type: int), part (type: int), c1
(type: tinyint), c2 (type: smallint), c3 (type: int), c4 (type: bigint), c5
(type: tinyint), c6 (type: smallint), c7 (type: int), c8 (type: bigint), c9
(type: tinyint), c10 (type: smallint), c11 (type: int), c12 (type: bigint), c13
(type: tinyint), c14 (type: smallint), c15 (type: int), c16 (type: bigint), c17
(type: tinyint), c18 (type: smallint), c19 (type: int), c20 (type: bigint), b
(type: string)
+ expressions: insert_num (type: int), part (type: int), c1
(type: string), c2 (type: string), c3 (type: string), c4 (type: string), c5
(type: char(50)), c6 (type: char(50)), c7 (type: char(50)), c8 (type:
char(50)), c9 (type: char(5)), c10 (type: char(5)), c11 (type: char(5)), c12
(type: char(5)), c13 (type: varchar(50)), c14 (type: varchar(50)), c15 (type:
varchar(50)), c16 (type: varchar(50)), c17 (type: varchar(5)), c18 (type:
varchar(5)), c19 (type: varchar(5)), c20 (type: varchar(5)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14,
_col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22
- Select Vectorization:
- className: VectorSelectOperator
- native: true
- projectedOutputColumnNums: [0, 22, 1, 2, 3, 4, 5, 6,
7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21]
- Statistics: Num rows: 5 Data size: 940 Basic stats:
COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 6 Data size: 1140 Basic stats:
COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- File Sink Vectorization:
- className: VectorFileSinkOperator
- native: false
- Statistics: Num rows: 5 Data size: 940 Basic stats:
COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 6 Data size: 1140 Basic stats:
COMPLETE Column stats: COMPLETE
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, llap
+ Execution mode: llap
LLAP IO: no inputs
Map Vectorization:
- enabled: true
+ enabled: false
enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
- inputFormatFeatureSupport: []
- featureSupportInUse: []
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
- allNative: false
- usesVectorUDFAdaptor: false
- vectorized: true
- rowBatchContext:
- dataColumnCount: 22
- includeColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12,
13, 14, 15, 16, 17, 18, 19, 20, 21]
- dataColumns: insert_num:int, c1:tinyint, c2:smallint,
c3:int, c4:bigint, c5:tinyint, c6:smallint, c7:int, c8:bigint, c9:tinyint,
c10:smallint, c11:int, c12:bigint, c13:tinyint, c14:smallint, c15:int,
c16:bigint, c17:tinyint, c18:smallint, c19:int, c20:bigint, b:string
- partitionColumnCount: 1
- partitionColumns: part:int
- scratchColumnTypeNames: []
Stage: Stage-0
Fetch Operator
@@ -605,22 +1062,6 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
from part_change_numeric_group_string_group_multi_ints_string_group
-PREHOOK: type: QUERY
-PREHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
-PREHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group@part=1
-#### A masked pattern was here ####
-POSTHOOK: query: select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
from part_change_numeric_group_string_group_multi_ints_string_group
-POSTHOOK: type: QUERY
-POSTHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
-POSTHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group@part=1
-#### A masked pattern was here ####
-insert_num part c1 c2 c3 c4 c5 c6 c7
c8 c9 c10 c11 c12 c13 c14 c15 c16 c17
c18 c19 c20 b
-101 1 -128 NULL -2147483648 NULL -128 NULL
-2147483648 NULL -128 NULL -2147483648 NULL -128 NULL
-2147483648 NULL -128 NULL -2147483648 NULL original
-102 1 127 32767 2147483647 9223372036854775807 127
32767 2147483647 9223372036854775807 127 32767 2147483647
9223372036854775807 127 32767 2147483647 9223372036854775807
127 32767 2147483647 9223372036854775807 original
-103 1 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL original
-104 1 23 834 203332 888888857923222 23 834 203332
888888857923222 23 834 203332 888888857923222 23 834 203332
888888857923222 23 834 203332 888888857923222 original
-105 1 -99 -28300 -999992 -222282153733 -99 -28300 -999992
-222282153733 -99 -28300 -999992 -222282153733 -99 -28300 -999992
-222282153733 -99 -28300 -999992 -222282153733 original
PREHOOK: query: drop table
part_change_numeric_group_string_group_multi_ints_string_group
PREHOOK: type: DROPTABLE
PREHOOK: Input:
default@part_change_numeric_group_string_group_multi_ints_string_group
@@ -766,6 +1207,106 @@ insert_num part c1 c2 c3 c4
c5 c6 c7 c8 c9 c10 c11 c12 c13 c14
c15 b
103 1 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL original
104 1 66475.561431000000000000 -100.35978 30.774
66475.561431000000000000 -100.35978 30.774
66475.561431000000000000 -100.35978 30.774
66475.561431000000000000 -100.35978 30.774
66475.561431000000000000 -100.35978 30.774 original
105 1 9250340.750000000000000000 NULL 46114.28
9250340.750000000000000000 NULL 46114.28
9250340.750000000000000000 NULL 46114.28
9250340.750000000000000000 NULL 46114.28
9250340.750000000000000000 NULL 46114.28 original
+PREHOOK: query: alter table
part_change_numeric_group_string_group_floating_string_group replace columns
(insert_num int,
+ c1 STRING, c2 STRING, c3 STRING,
+ c4 CHAR(50), c5 CHAR(50), c6 CHAR(50), c7 CHAR(7), c8 CHAR(7),
c9 CHAR(7),
+ c10 VARCHAR(50), c11 VARCHAR(50), c12 VARCHAR(50), c13
VARCHAR(7), c14 VARCHAR(7), c15 VARCHAR(7),
+ b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input:
default@part_change_numeric_group_string_group_floating_string_group
+PREHOOK: Output:
default@part_change_numeric_group_string_group_floating_string_group
+POSTHOOK: query: alter table
part_change_numeric_group_string_group_floating_string_group replace columns
(insert_num int,
+ c1 STRING, c2 STRING, c3 STRING,
+ c4 CHAR(50), c5 CHAR(50), c6 CHAR(50), c7 CHAR(7), c8 CHAR(7),
c9 CHAR(7),
+ c10 VARCHAR(50), c11 VARCHAR(50), c12 VARCHAR(50), c13
VARCHAR(7), c14 VARCHAR(7), c15 VARCHAR(7),
+ b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input:
default@part_change_numeric_group_string_group_floating_string_group
+POSTHOOK: Output:
default@part_change_numeric_group_string_group_floating_string_group
+PREHOOK: query: insert into table
part_change_numeric_group_string_group_floating_string_group partition(part=1)
VALUES (111,
+ 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+ 'new')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output:
default@part_change_numeric_group_string_group_floating_string_group@part=1
+POSTHOOK: query: insert into table
part_change_numeric_group_string_group_floating_string_group partition(part=1)
VALUES (111,
+ 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+ 'new')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output:
default@part_change_numeric_group_string_group_floating_string_group@part=1
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c1 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c10 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c11 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c12 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c13 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c14 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c15 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c2 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c3 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c4 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c5 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c6 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c7 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c8 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).c9 SCRIPT []
+POSTHOOK: Lineage:
part_change_numeric_group_string_group_floating_string_group
PARTITION(part=1).insert_num SCRIPT []
+_col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 _col8 _col9
_col10 _col11 _col12 _col13 _col14 _col15 _col16
+PREHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b
from part_change_numeric_group_string_group_floating_string_group
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b
from part_change_numeric_group_string_group_floating_string_group
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias:
part_change_numeric_group_string_group_floating_string_group
+ Statistics: Num rows: 6 Data size: 3300 Basic stats:
COMPLETE Column stats: PARTIAL
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), c1
(type: string), c2 (type: string), c3 (type: string), c4 (type: char(50)), c5
(type: char(50)), c6 (type: char(50)), c7 (type: char(7)), c8 (type: char(7)),
c9 (type: char(7)), c10 (type: varchar(50)), c11 (type: varchar(50)), c12
(type: varchar(50)), c13 (type: varchar(7)), c14 (type: varchar(7)), c15 (type:
varchar(7)), b (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14,
_col15, _col16, _col17
+ Statistics: Num rows: 6 Data size: 3300 Basic stats:
COMPLETE Column stats: PARTIAL
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 3300 Basic stats:
COMPLETE Column stats: PARTIAL
+ 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: llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: false
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table
part_change_numeric_group_string_group_floating_string_group
PREHOOK: type: DROPTABLE
PREHOOK: Input:
default@part_change_numeric_group_string_group_floating_string_group
@@ -904,6 +1445,99 @@ insert_num part c1 c2 c3 c4
b
103 1 original
104 1 I cooked I cooked I cooked I cooked
original
105 1 200 200 200 200 original
+PREHOOK: query: alter table part_change_string_group_string_group_string
replace columns (insert_num int,
+ c1 CHAR(50), c2 CHAR(9), c3 VARCHAR(50), c4 CHAR(9),
+ c5 VARCHAR(50), c6 VARCHAR(9), c7 STRING,
+ c8 CHAR(50), c9 CHAR(9), c10 STRING, b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@part_change_string_group_string_group_string
+PREHOOK: Output: default@part_change_string_group_string_group_string
+POSTHOOK: query: alter table part_change_string_group_string_group_string
replace columns (insert_num int,
+ c1 CHAR(50), c2 CHAR(9), c3 VARCHAR(50), c4 CHAR(9),
+ c5 VARCHAR(50), c6 VARCHAR(9), c7 STRING,
+ c8 CHAR(50), c9 CHAR(9), c10 STRING, b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@part_change_string_group_string_group_string
+POSTHOOK: Output: default@part_change_string_group_string_group_string
+PREHOOK: query: insert into table part_change_string_group_string_group_string
partition(part=1) VALUES (111,
+ 'filler', 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler',
+ 'new')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output: default@part_change_string_group_string_group_string@part=1
+POSTHOOK: query: insert into table
part_change_string_group_string_group_string partition(part=1) VALUES (111,
+ 'filler', 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler',
+ 'filler', 'filler', 'filler',
+ 'new')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output: default@part_change_string_group_string_group_string@part=1
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c1 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c10 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c2 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c3 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c4 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c5 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c6 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c7 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c8 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).c9 SCRIPT []
+POSTHOOK: Lineage: part_change_string_group_string_group_string
PARTITION(part=1).insert_num SCRIPT []
+_col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 _col8 _col9
_col10 _col11
+PREHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from
part_change_string_group_string_group_string
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from
part_change_string_group_string_group_string
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: part_change_string_group_string_group_string
+ Statistics: Num rows: 6 Data size: 2712 Basic stats:
COMPLETE Column stats: PARTIAL
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), c1
(type: char(50)), c2 (type: char(9)), c3 (type: varchar(50)), c4 (type:
char(9)), c5 (type: varchar(50)), c6 (type: varchar(9)), c7 (type: string), c8
(type: char(50)), c9 (type: char(9)), c10 (type: string), b (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
+ Statistics: Num rows: 6 Data size: 2712 Basic stats:
COMPLETE Column stats: PARTIAL
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 2712 Basic stats:
COMPLETE Column stats: PARTIAL
+ 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: llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: false
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table part_change_string_group_string_group_string
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_string_group_string_group_string
@@ -1056,6 +1690,113 @@ insert_num part c1 c2 c3 c4
c5 c6 c7 c8 c9 c10 c11 c12 c13 c14
c15 c16 c17 c18 b
103 1 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
original
104 1 23 23 23 23 23 23 834 834
834 834 834 203332 203332 203332 203332 888888857923222
888888857923222 888888857923222 original
105 1 -99 -99 -99 -99 -99 -99 -28300 -28300
-28300 -28300 -28300 -999992 -999992 -999992 -999992 -222282153733
-222282153733 -222282153733 original
+PREHOOK: query: alter table
part_change_lower_to_higher_numeric_group_tinyint_to_bigint replace columns
(insert_num int,
+ c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6
DOUBLE,
+ c7 INT, c8 BIGINT, c9 decimal(38,18), c10 FLOAT, c11 DOUBLE,
+ c12 BIGINT, c13 decimal(38,18), c14 FLOAT, c15 DOUBLE,
+ c16 decimal(38,18), c17 FLOAT, c18 DOUBLE,
+ b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+PREHOOK: Output:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+POSTHOOK: query: alter table
part_change_lower_to_higher_numeric_group_tinyint_to_bigint replace columns
(insert_num int,
+ c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6
DOUBLE,
+ c7 INT, c8 BIGINT, c9 decimal(38,18), c10 FLOAT, c11 DOUBLE,
+ c12 BIGINT, c13 decimal(38,18), c14 FLOAT, c15 DOUBLE,
+ c16 decimal(38,18), c17 FLOAT, c18 DOUBLE,
+ b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+POSTHOOK: Output:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+PREHOOK: query: insert into table
part_change_lower_to_higher_numeric_group_tinyint_to_bigint partition(part=1)
VALUES (111,
+ 7000, 80000, 90000000, 1234.5678, 9876.543, 789.321,
+ 80000, 90000000, 1234.5678, 9876.543, 789.321,
+ 90000000, 1234.5678, 9876.543, 789.321,
+ 1234.5678, 9876.543, 789.321,
+ 'new')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint@part=1
+POSTHOOK: query: insert into table
part_change_lower_to_higher_numeric_group_tinyint_to_bigint partition(part=1)
VALUES (111,
+ 7000, 80000, 90000000, 1234.5678, 9876.543, 789.321,
+ 80000, 90000000, 1234.5678, 9876.543, 789.321,
+ 90000000, 1234.5678, 9876.543, 789.321,
+ 1234.5678, 9876.543, 789.321,
+ 'new')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint@part=1
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c1 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c10 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c11 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c12 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c13 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c14 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c15 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c16 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c17 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c18 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c2 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c3 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c4 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c5 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c6 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c7 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c8 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).c9 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PARTITION(part=1).insert_num SCRIPT []
+_col0 _col1 _col2 _col3 _col4 _col5 _col6 _col7 _col8 _col9
_col10 _col11 _col12 _col13 _col14 _col15 _col16 _col17 _col18 _col19
+PREHOOK: query: explain vectorization detail
+select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b
from part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b
from part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias:
part_change_lower_to_higher_numeric_group_tinyint_to_bigint
+ Statistics: Num rows: 6 Data size: 1060 Basic stats:
COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), c1
(type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: decimal(38,18)),
c5 (type: float), c6 (type: double), c7 (type: int), c8 (type: bigint), c9
(type: decimal(38,18)), c10 (type: float), c11 (type: double), c12 (type:
bigint), c13 (type: decimal(38,18)), c14 (type: float), c15 (type: double), c16
(type: decimal(38,18)), c17 (type: float), c18 (type: double), b (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14,
_col15, _col16, _col17, _col18, _col19, _col20
+ Statistics: Num rows: 6 Data size: 1060 Basic stats:
COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 1060 Basic stats:
COMPLETE Column stats: COMPLETE
+ 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: llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: false
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table
part_change_lower_to_higher_numeric_group_tinyint_to_bigint
PREHOOK: type: DROPTABLE
PREHOOK: Input:
default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint
@@ -1185,6 +1926,78 @@ insert_num part c1 c2 c3 b
103 1 NULL NULL NULL original
104 1 66475.561431000000000000 66475.561431000000000000
-100.35978 original
105 1 9250340.750000000000000000 9250340.750000000000000000
NULL original
+PREHOOK: query: alter table
part_change_lower_to_higher_numeric_group_decimal_to_float replace columns
(insert_num int, c1 float, c2 double, c3 DOUBLE, b STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input:
default@part_change_lower_to_higher_numeric_group_decimal_to_float
+PREHOOK: Output:
default@part_change_lower_to_higher_numeric_group_decimal_to_float
+POSTHOOK: query: alter table
part_change_lower_to_higher_numeric_group_decimal_to_float replace columns
(insert_num int, c1 float, c2 double, c3 DOUBLE, b STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input:
default@part_change_lower_to_higher_numeric_group_decimal_to_float
+POSTHOOK: Output:
default@part_change_lower_to_higher_numeric_group_decimal_to_float
+PREHOOK: query: insert into table
part_change_lower_to_higher_numeric_group_decimal_to_float partition(part=1)
VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new')
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output:
default@part_change_lower_to_higher_numeric_group_decimal_to_float@part=1
+POSTHOOK: query: insert into table
part_change_lower_to_higher_numeric_group_decimal_to_float partition(part=1)
VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output:
default@part_change_lower_to_higher_numeric_group_decimal_to_float@part=1
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float
PARTITION(part=1).b SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float
PARTITION(part=1).c1 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float
PARTITION(part=1).c2 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float
PARTITION(part=1).c3 SCRIPT []
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float
PARTITION(part=1).insert_num SCRIPT []
+_col0 _col1 _col2 _col3 _col4
+PREHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,b from
part_change_lower_to_higher_numeric_group_decimal_to_float
+PREHOOK: type: QUERY
+POSTHOOK: query: explain vectorization detail
+select insert_num,part,c1,c2,c3,b from
part_change_lower_to_higher_numeric_group_decimal_to_float
+POSTHOOK: type: QUERY
+Explain
+PLAN VECTORIZATION:
+ enabled: true
+ enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias:
part_change_lower_to_higher_numeric_group_decimal_to_float
+ Statistics: Num rows: 6 Data size: 648 Basic stats: COMPLETE
Column stats: PARTIAL
+ Select Operator
+ expressions: insert_num (type: int), part (type: int), c1
(type: float), c2 (type: double), c3 (type: double), b (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ Statistics: Num rows: 6 Data size: 648 Basic stats:
COMPLETE Column stats: PARTIAL
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 6 Data size: 648 Basic stats:
COMPLETE Column stats: PARTIAL
+ 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: llap
+ LLAP IO: no inputs
+ Map Vectorization:
+ enabled: false
+ enabledConditionsMet:
hive.vectorized.use.row.serde.deserialize IS true
+ enabledConditionsNotMet: Could not enable vectorization. LLAP
I/O is enabled wbich automatically deserializes into
VECTORIZED_INPUT_FILE_FORMAT. A partition requires data type conversion and
that is not supported IS false
+ inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
PREHOOK: query: drop table
part_change_lower_to_higher_numeric_group_decimal_to_float
PREHOOK: type: DROPTABLE
PREHOOK: Input:
default@part_change_lower_to_higher_numeric_group_decimal_to_float