HIVE-19200: Vectorization: Disable vectorization for LLAP I/O when a non-VECTORIZED_I...
[hive.git] / ql / src / test / results / clientpositive / llap / schema_evol_text_vec_part_all_primitive_llap_io.q.out
1 PREHOOK: query: CREATE TABLE schema_evolution_data(insert_num int, boolean1 boolean, tinyint1 tinyint, smallint1 smallint, int1 int, bigint1 bigint, decimal1 decimal(38,18), float1 float, double1 double, string1 string, string2 string, date1 date, timestamp1 timestamp, boolean_str string, tinyint_str string, smallint_str string, int_str string, bigint_str string, decimal_str string, float_str string, double_str string, date_str string, timestamp_str string, filler string)
2 row format delimited fields terminated by '|' stored as textfile
3 PREHOOK: type: CREATETABLE
4 PREHOOK: Output: database:default
5 PREHOOK: Output: default@schema_evolution_data
6 POSTHOOK: query: CREATE TABLE schema_evolution_data(insert_num int, boolean1 boolean, tinyint1 tinyint, smallint1 smallint, int1 int, bigint1 bigint, decimal1 decimal(38,18), float1 float, double1 double, string1 string, string2 string, date1 date, timestamp1 timestamp, boolean_str string, tinyint_str string, smallint_str string, int_str string, bigint_str string, decimal_str string, float_str string, double_str string, date_str string, timestamp_str string, filler string)
7 row format delimited fields terminated by '|' stored as textfile
8 POSTHOOK: type: CREATETABLE
9 POSTHOOK: Output: database:default
10 POSTHOOK: Output: default@schema_evolution_data
11 PREHOOK: query: load data local inpath '../../data/files/schema_evolution/schema_evolution_data.txt' overwrite into table schema_evolution_data
12 PREHOOK: type: LOAD
13 #### A masked pattern was here ####
14 PREHOOK: Output: default@schema_evolution_data
15 POSTHOOK: query: load data local inpath '../../data/files/schema_evolution/schema_evolution_data.txt' overwrite into table schema_evolution_data
16 POSTHOOK: type: LOAD
17 #### A masked pattern was here ####
18 POSTHOOK: Output: default@schema_evolution_data
19 PREHOOK: query: CREATE TABLE schema_evolution_data_2(insert_num int, boolean1 boolean, tinyint1 tinyint, smallint1 smallint, int1 int, bigint1 bigint, decimal1 decimal(38,18), float1 float, double1 double, string1 string, string2 string, date1 date, timestamp1 timestamp, boolean_str string, tinyint_str string, smallint_str string, int_str string, bigint_str string, decimal_str string, float_str string, double_str string, date_str string, timestamp_str string, filler string)
20 row format delimited fields terminated by '|' stored as textfile
21 PREHOOK: type: CREATETABLE
22 PREHOOK: Output: database:default
23 PREHOOK: Output: default@schema_evolution_data_2
24 POSTHOOK: query: CREATE TABLE schema_evolution_data_2(insert_num int, boolean1 boolean, tinyint1 tinyint, smallint1 smallint, int1 int, bigint1 bigint, decimal1 decimal(38,18), float1 float, double1 double, string1 string, string2 string, date1 date, timestamp1 timestamp, boolean_str string, tinyint_str string, smallint_str string, int_str string, bigint_str string, decimal_str string, float_str string, double_str string, date_str string, timestamp_str string, filler string)
25 row format delimited fields terminated by '|' stored as textfile
26 POSTHOOK: type: CREATETABLE
27 POSTHOOK: Output: database:default
28 POSTHOOK: Output: default@schema_evolution_data_2
29 PREHOOK: query: load data local inpath '../../data/files/schema_evolution/schema_evolution_data_2.txt' overwrite into table schema_evolution_data_2
30 PREHOOK: type: LOAD
31 #### A masked pattern was here ####
32 PREHOOK: Output: default@schema_evolution_data_2
33 POSTHOOK: query: load data local inpath '../../data/files/schema_evolution/schema_evolution_data_2.txt' overwrite into table schema_evolution_data_2
34 POSTHOOK: type: LOAD
35 #### A masked pattern was here ####
36 POSTHOOK: Output: default@schema_evolution_data_2
37 PREHOOK: query: CREATE TABLE part_change_various_various_boolean_to_bigint(insert_num int,
38               c1 TINYINT, c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 TIMESTAMP,
39               c10 BOOLEAN, c11 SMALLINT, c12 INT, c13 BIGINT, c14 FLOAT, c15 DOUBLE, c16 DECIMAL(38,18), c17 STRING, c18 CHAR(25), c19 VARCHAR(25), c20 TIMESTAMP,
40               c21 BOOLEAN, c22 TINYINT, c23 INT, c24 BIGINT, c25 FLOAT, c26 DOUBLE, c27 DECIMAL(38,18), c28 STRING, c29 CHAR(25), c30 VARCHAR(25), c31 TIMESTAMP,
41               c32 BOOLEAN, c33 TINYINT, c34 SMALLINT, c35 BIGINT, c36 FLOAT, c37 DOUBLE, c38 DECIMAL(38,18), c39 STRING, c40 CHAR(25), c41 VARCHAR(25), c42 TIMESTAMP,
42               c43 BOOLEAN, c44 TINYINT, c45 SMALLINT, c46 INT, c47 FLOAT, c48 DOUBLE, c49 DECIMAL(38,18), c50 STRING, c51 CHAR(25), c52 VARCHAR(25), c53 TIMESTAMP,
43               b STRING) PARTITIONED BY(part INT)
44 PREHOOK: type: CREATETABLE
45 PREHOOK: Output: database:default
46 PREHOOK: Output: default@part_change_various_various_boolean_to_bigint
47 POSTHOOK: query: CREATE TABLE part_change_various_various_boolean_to_bigint(insert_num int,
48               c1 TINYINT, c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 TIMESTAMP,
49               c10 BOOLEAN, c11 SMALLINT, c12 INT, c13 BIGINT, c14 FLOAT, c15 DOUBLE, c16 DECIMAL(38,18), c17 STRING, c18 CHAR(25), c19 VARCHAR(25), c20 TIMESTAMP,
50               c21 BOOLEAN, c22 TINYINT, c23 INT, c24 BIGINT, c25 FLOAT, c26 DOUBLE, c27 DECIMAL(38,18), c28 STRING, c29 CHAR(25), c30 VARCHAR(25), c31 TIMESTAMP,
51               c32 BOOLEAN, c33 TINYINT, c34 SMALLINT, c35 BIGINT, c36 FLOAT, c37 DOUBLE, c38 DECIMAL(38,18), c39 STRING, c40 CHAR(25), c41 VARCHAR(25), c42 TIMESTAMP,
52               c43 BOOLEAN, c44 TINYINT, c45 SMALLINT, c46 INT, c47 FLOAT, c48 DOUBLE, c49 DECIMAL(38,18), c50 STRING, c51 CHAR(25), c52 VARCHAR(25), c53 TIMESTAMP,
53               b STRING) PARTITIONED BY(part INT)
54 POSTHOOK: type: CREATETABLE
55 POSTHOOK: Output: database:default
56 POSTHOOK: Output: default@part_change_various_various_boolean_to_bigint
57 PREHOOK: query: insert into table part_change_various_various_boolean_to_bigint partition(part=1) SELECT insert_num,
58              tinyint1, smallint1, int1, bigint1, float1, double1, decimal1, boolean_str, timestamp1,
59              boolean1, smallint1, int1, bigint1, float1, double1, decimal1, tinyint_str, tinyint_str, tinyint_str, timestamp1,
60              boolean1, tinyint1, int1, bigint1, float1, double1, decimal1, smallint_str, smallint_str, smallint_str, timestamp1,
61              boolean1, tinyint1, smallint1, bigint1, float1, double1, decimal1, int_str, int_str, int_str, timestamp1,
62              boolean1, tinyint1, smallint1, int1, float1, double1, decimal1, bigint_str, bigint_str, bigint_str, timestamp1,
63              'original' FROM schema_evolution_data
64 PREHOOK: type: QUERY
65 PREHOOK: Input: default@schema_evolution_data
66 PREHOOK: Output: default@part_change_various_various_boolean_to_bigint@part=1
67 POSTHOOK: query: insert into table part_change_various_various_boolean_to_bigint partition(part=1) SELECT insert_num,
68              tinyint1, smallint1, int1, bigint1, float1, double1, decimal1, boolean_str, timestamp1,
69              boolean1, smallint1, int1, bigint1, float1, double1, decimal1, tinyint_str, tinyint_str, tinyint_str, timestamp1,
70              boolean1, tinyint1, int1, bigint1, float1, double1, decimal1, smallint_str, smallint_str, smallint_str, timestamp1,
71              boolean1, tinyint1, smallint1, bigint1, float1, double1, decimal1, int_str, int_str, int_str, timestamp1,
72              boolean1, tinyint1, smallint1, int1, float1, double1, decimal1, bigint_str, bigint_str, bigint_str, timestamp1,
73              'original' FROM schema_evolution_data
74 POSTHOOK: type: QUERY
75 POSTHOOK: Input: default@schema_evolution_data
76 POSTHOOK: Output: default@part_change_various_various_boolean_to_bigint@part=1
77 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).b SIMPLE []
78 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c1 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
79 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c10 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
80 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c11 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
81 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c12 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
82 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c13 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
83 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c14 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
84 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c15 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
85 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c16 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
86 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c17 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint_str, type:string, comment:null), ]
87 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c18 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint_str, type:string, comment:null), ]
88 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c19 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint_str, type:string, comment:null), ]
89 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c2 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
90 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c20 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
91 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c21 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
92 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c22 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
93 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c23 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
94 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c24 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
95 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c25 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
96 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c26 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
97 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c27 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
98 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c28 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint_str, type:string, comment:null), ]
99 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c29 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint_str, type:string, comment:null), ]
100 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c3 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
101 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c30 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint_str, type:string, comment:null), ]
102 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c31 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
103 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c32 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
104 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c33 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
105 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c34 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
106 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c35 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
107 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c36 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
108 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c37 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
109 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c38 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
110 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c39 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int_str, type:string, comment:null), ]
111 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c4 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
112 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c40 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int_str, type:string, comment:null), ]
113 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c41 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int_str, type:string, comment:null), ]
114 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c42 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
115 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c43 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
116 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c44 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
117 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c45 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
118 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c46 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
119 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c47 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
120 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c48 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
121 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c49 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
122 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c5 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
123 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c50 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint_str, type:string, comment:null), ]
124 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c51 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint_str, type:string, comment:null), ]
125 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c52 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint_str, type:string, comment:null), ]
126 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c53 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
127 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c6 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
128 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c7 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
129 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c8 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean_str, type:string, comment:null), ]
130 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c9 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
131 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:insert_num, type:int, comment:null), ]
132 _col0   _col1   _col2   _col3   _col4   _col5   _col6   _col7   _col8   _col9   _col10  _col11  _col12  _col13  _col14  _col15  _col16  _col17  _col18  _col19  _col20  _col21  _col22  _col23  _col24  _col25  _col26  _col27  _col28  _col29  _col30  _col31  _col32  _col33  _col34  _col35  _col36  _col37  _col38  _col39  _col40  _col41  _col42  _col43  _col44  _col45  _col46  _col47  _col48  _col49  _col50  _col51  _col52  _col53  _col54
133 PREHOOK: query: explain vectorization detail
134 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
135 PREHOOK: type: QUERY
136 POSTHOOK: query: explain vectorization detail
137 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
138 POSTHOOK: type: QUERY
139 Explain
140 PLAN VECTORIZATION:
141   enabled: true
142   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
143
144 STAGE DEPENDENCIES:
145   Stage-1 is a root stage
146   Stage-0 depends on stages: Stage-1
147
148 STAGE PLANS:
149   Stage: Stage-1
150     Tez
151 #### A masked pattern was here ####
152       Vertices:
153         Map 1 
154             Map Operator Tree:
155                 TableScan
156                   alias: part_change_various_various_boolean_to_bigint
157                   Statistics: Num rows: 5 Data size: 10802 Basic stats: COMPLETE Column stats: PARTIAL
158                   TableScan Vectorization:
159                       native: true
160                       vectorizationSchemaColumns: [0:insert_num:int, 1:c1:tinyint, 2:c2:smallint, 3:c3:int, 4:c4:bigint, 5:c5:float, 6:c6:double, 7:c7:decimal(38,18), 8:c8:string, 9:c9:timestamp, 10:c10:boolean, 11:c11:smallint, 12:c12:int, 13:c13:bigint, 14:c14:float, 15:c15:double, 16:c16:decimal(38,18), 17:c17:string, 18:c18:char(25), 19:c19:varchar(25), 20:c20:timestamp, 21:c21:boolean, 22:c22:tinyint, 23:c23:int, 24:c24:bigint, 25:c25:float, 26:c26:double, 27:c27:decimal(38,18), 28:c28:string, 29:c29:char(25), 30:c30:varchar(25), 31:c31:timestamp, 32:c32:boolean, 33:c33:tinyint, 34:c34:smallint, 35:c35:bigint, 36:c36:float, 37:c37:double, 38:c38:decimal(38,18), 39:c39:string, 40:c40:char(25), 41:c41:varchar(25), 42:c42:timestamp, 43:c43:boolean, 44:c44:tinyint, 45:c45:smallint, 46:c46:int, 47:c47:float, 48:c48:double, 49:c49:decimal(38,18), 50:c50:string, 51:c51:char(25), 52:c52:varchar(25), 53:c53:timestamp, 54:b:string, 55:part:int, 56:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
161                   Select Operator
162                     expressions: insert_num (type: int), part (type: int), c1 (type: tinyint), c2 (type: smallint), c3 (type: int), c4 (type: bigint), c5 (type: float), c6 (type: double), c7 (type: decimal(38,18)), c8 (type: string), c9 (type: timestamp), c10 (type: boolean), c11 (type: smallint), c12 (type: int), c13 (type: bigint), c14 (type: float), c15 (type: double), c16 (type: decimal(38,18)), c17 (type: string), c18 (type: char(25)), c19 (type: varchar(25)), c20 (type: timestamp), c21 (type: boolean), c22 (type: tinyint), c23 (type: int), c24 (type: bigint), c25 (type: float), c26 (type: double), c27 (type: decimal(38,18)), c28 (type: string), c29 (type: char(25)), c30 (type: varchar(25)), c31 (type: timestamp), c32 (type: boolean), c33 (type: tinyint), c34 (type: smallint), c35 (type: bigint), c36 (type: float), c37 (type: double), c38 (type: decimal(38,18)), c39 (type: string), c40 (type: char(25)), c41 (type: varchar(25)), c42 (type: timestamp), c43 (type: boolean), c44 (type: tinyint), c45 (type: smallint), c46 (type: int), c47 (type: float), c48 (type: double), c49 (type: decimal(38,18)), c50 (type: string), c51 (type: char(25)), c52 (type: varchar(25)), c53 (type: timestamp), b (type: string)
163                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35, _col36, _col37, _col38, _col39, _col40, _col41, _col42, _col43, _col44, _col45, _col46, _col47, _col48, _col49, _col50, _col51, _col52, _col53, _col54, _col55
164                     Select Vectorization:
165                         className: VectorSelectOperator
166                         native: true
167                         projectedOutputColumnNums: [0, 55, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54]
168                     Statistics: Num rows: 5 Data size: 10802 Basic stats: COMPLETE Column stats: PARTIAL
169                     File Output Operator
170                       compressed: false
171                       File Sink Vectorization:
172                           className: VectorFileSinkOperator
173                           native: false
174                       Statistics: Num rows: 5 Data size: 10802 Basic stats: COMPLETE Column stats: PARTIAL
175                       table:
176                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
177                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
178                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
179             Execution mode: vectorized, llap
180             LLAP IO: no inputs
181             Map Vectorization:
182                 enabled: true
183                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
184                 inputFormatFeatureSupport: [DECIMAL_64]
185                 vectorizationSupportRemovedReasons: [DECIMAL_64 disabled because LLAP is enabled]
186                 featureSupportInUse: []
187                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
188                 allNative: false
189                 usesVectorUDFAdaptor: false
190                 vectorized: true
191                 rowBatchContext:
192                     dataColumnCount: 55
193                     includeColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54]
194                     dataColumns: insert_num:int, c1:tinyint, c2:smallint, c3:int, c4:bigint, c5:float, c6:double, c7:decimal(38,18), c8:string, c9:timestamp, c10:boolean, c11:smallint, c12:int, c13:bigint, c14:float, c15:double, c16:decimal(38,18), c17:string, c18:char(25), c19:varchar(25), c20:timestamp, c21:boolean, c22:tinyint, c23:int, c24:bigint, c25:float, c26:double, c27:decimal(38,18), c28:string, c29:char(25), c30:varchar(25), c31:timestamp, c32:boolean, c33:tinyint, c34:smallint, c35:bigint, c36:float, c37:double, c38:decimal(38,18), c39:string, c40:char(25), c41:varchar(25), c42:timestamp, c43:boolean, c44:tinyint, c45:smallint, c46:int, c47:float, c48:double, c49:decimal(38,18), c50:string, c51:char(25), c52:varchar(25), c53:timestamp, b:string
195                     partitionColumnCount: 1
196                     partitionColumns: part:int
197                     scratchColumnTypeNames: []
198
199   Stage: Stage-0
200     Fetch Operator
201       limit: -1
202       Processor Tree:
203         ListSink
204
205 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
206 PREHOOK: type: QUERY
207 PREHOOK: Input: default@part_change_various_various_boolean_to_bigint
208 PREHOOK: Input: default@part_change_various_various_boolean_to_bigint@part=1
209 #### A masked pattern was here ####
210 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
211 POSTHOOK: type: QUERY
212 POSTHOOK: Input: default@part_change_various_various_boolean_to_bigint
213 POSTHOOK: Input: default@part_change_various_various_boolean_to_bigint@part=1
214 #### A masked pattern was here ####
215 insert_num      part    c1      c2      c3      c4      c5      c6      c7      c8      c9      c10     c11     c12     c13     c14     c15     c16     c17     c18     c19     c20     c21     c22     c23     c24     c25     c26     c27     c28     c29     c30     c31     c32     c33     c34     c35     c36     c37     c38     c39     c40     c41     c42     c43     c44     c45     c46     c47     c48     c49     c50     c51     c52     c53     b
216 101     1       -128    NULL    -2147483648     NULL    Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 true    6229-06-28 02:54:28.970117179   true    NULL    -2147483648     NULL    Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 -128    -128                            -128    6229-06-28 02:54:28.970117179   true    -128    -2147483648     NULL    Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 –32768        –32768                        –32768        6229-06-28 02:54:28.970117179   true    -128    NULL    NULL    Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 -2147483648     -2147483648                     -2147483648     6229-06-28 02:54:28.970117179   true    -128    NULL    -2147483648     Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 –9223372036854775808  –9223372036854775808          –9223372036854775808  6229-06-28 02:54:28.970117179   original
217 102     1       127     32767   2147483647      9223372036854775807     -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        false   5966-07-09 03:30:50.597 false   32767   2147483647      9223372036854775807     -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        127     127                             127     5966-07-09 03:30:50.597 false   127     2147483647      9223372036854775807     -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        32767   32767                           32767   5966-07-09 03:30:50.597 false   127     32767   9223372036854775807     -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        2147483647      2147483647                      2147483647      5966-07-09 03:30:50.597 false   127     32767   2147483647      -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        9223372036854775807     9223372036854775807             9223372036854775807     5966-07-09 03:30:50.597 original
218 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL            NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    original
219 104     1       23      834     203332  888888857923222 -100.35978      30.774  66475.561431000000000000        true    1978-08-02 06:34:14     true    834     203332  888888857923222 -100.35978      30.774  66475.561431000000000000        23      23                              23      1978-08-02 06:34:14     true    23      203332  888888857923222 -100.35978      30.774  66475.561431000000000000        834     834                             834     1978-08-02 06:34:14     true    23      834     888888857923222 -100.35978      30.774  66475.561431000000000000        203332  203332                          203332  1978-08-02 06:34:14     true    23      834     203332  -100.35978      30.774  66475.561431000000000000        888888857923222 888888857923222                 888888857923222 1978-08-02 06:34:14     original
220 105     1       -99     -28300  -999992 -222282153733   NULL    46114.28        9250340.750000000000000000      false   1991-01-06 16:20:39.72036854    false   -28300  -999992 -222282153733   NULL    46114.28        9250340.750000000000000000      -99     -99                             -99     1991-01-06 16:20:39.72036854    false   -99     -999992 -222282153733   NULL    46114.28        9250340.750000000000000000      -28300  -28300                          -28300  1991-01-06 16:20:39.72036854    false   -99     -28300  -222282153733   NULL    46114.28        9250340.750000000000000000      -999992 -999992                         -999992 1991-01-06 16:20:39.72036854    false   -99     -28300  -999992 NULL    46114.28        9250340.750000000000000000      -222282153733   -222282153733                   -222282153733   1991-01-06 16:20:39.72036854    original
221 PREHOOK: query: alter table part_change_various_various_boolean_to_bigint replace columns (insert_num int,
222              c1 BOOLEAN, c2 BOOLEAN, c3 BOOLEAN, c4 BOOLEAN, c5 BOOLEAN, c6 BOOLEAN, c7 BOOLEAN, c8 BOOLEAN, c9 BOOLEAN,
223              c10 TINYINT, c11 TINYINT, c12 TINYINT, c13 TINYINT, c14 TINYINT, c15 TINYINT, c16 TINYINT, c17 TINYINT, c18 TINYINT, c19 TINYINT, c20 TINYINT,
224              c21 SMALLINT, c22 SMALLINT, c23 SMALLINT, c24 SMALLINT, c25 SMALLINT, c26 SMALLINT, c27 SMALLINT, c28 SMALLINT, c29 SMALLINT, c30 SMALLINT, c31 SMALLINT,
225              c32 INT, c33 INT, c34 INT, c35 INT, c36 INT, c37 INT, c38 INT, c39 INT, c40 INT, c41 INT, c42 INT,
226              c43 BIGINT, c44 BIGINT, c45 BIGINT, c46 BIGINT, c47 BIGINT, c48 BIGINT, c49 BIGINT, c50 BIGINT, c51 BIGINT, c52 BIGINT, c53 BIGINT,
227              b STRING)
228 PREHOOK: type: ALTERTABLE_REPLACECOLS
229 PREHOOK: Input: default@part_change_various_various_boolean_to_bigint
230 PREHOOK: Output: default@part_change_various_various_boolean_to_bigint
231 POSTHOOK: query: alter table part_change_various_various_boolean_to_bigint replace columns (insert_num int,
232              c1 BOOLEAN, c2 BOOLEAN, c3 BOOLEAN, c4 BOOLEAN, c5 BOOLEAN, c6 BOOLEAN, c7 BOOLEAN, c8 BOOLEAN, c9 BOOLEAN,
233              c10 TINYINT, c11 TINYINT, c12 TINYINT, c13 TINYINT, c14 TINYINT, c15 TINYINT, c16 TINYINT, c17 TINYINT, c18 TINYINT, c19 TINYINT, c20 TINYINT,
234              c21 SMALLINT, c22 SMALLINT, c23 SMALLINT, c24 SMALLINT, c25 SMALLINT, c26 SMALLINT, c27 SMALLINT, c28 SMALLINT, c29 SMALLINT, c30 SMALLINT, c31 SMALLINT,
235              c32 INT, c33 INT, c34 INT, c35 INT, c36 INT, c37 INT, c38 INT, c39 INT, c40 INT, c41 INT, c42 INT,
236              c43 BIGINT, c44 BIGINT, c45 BIGINT, c46 BIGINT, c47 BIGINT, c48 BIGINT, c49 BIGINT, c50 BIGINT, c51 BIGINT, c52 BIGINT, c53 BIGINT,
237              b STRING)
238 POSTHOOK: type: ALTERTABLE_REPLACECOLS
239 POSTHOOK: Input: default@part_change_various_various_boolean_to_bigint
240 POSTHOOK: Output: default@part_change_various_various_boolean_to_bigint
241 PREHOOK: query: insert into table part_change_various_various_boolean_to_bigint partition(part=1) SELECT insert_num,
242              boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, boolean1,
243              tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1,
244              smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1,
245              int1, int1, int1, int1, int1, int1, int1, int1, int1, int1, int1,
246              bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, 
247               'new' FROM schema_evolution_data
248 PREHOOK: type: QUERY
249 PREHOOK: Input: default@schema_evolution_data
250 PREHOOK: Output: default@part_change_various_various_boolean_to_bigint@part=1
251 POSTHOOK: query: insert into table part_change_various_various_boolean_to_bigint partition(part=1) SELECT insert_num,
252              boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, boolean1,
253              tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1,
254              smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, smallint1,
255              int1, int1, int1, int1, int1, int1, int1, int1, int1, int1, int1,
256              bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, 
257               'new' FROM schema_evolution_data
258 POSTHOOK: type: QUERY
259 POSTHOOK: Input: default@schema_evolution_data
260 POSTHOOK: Output: default@part_change_various_various_boolean_to_bigint@part=1
261 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).b SIMPLE []
262 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c1 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
263 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c10 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
264 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c11 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
265 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c12 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
266 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c13 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
267 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c14 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
268 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c15 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
269 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c16 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
270 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c17 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
271 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c18 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
272 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c19 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
273 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c2 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
274 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c20 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
275 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c21 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
276 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c22 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
277 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c23 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
278 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c24 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
279 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c25 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
280 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c26 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
281 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c27 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
282 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c28 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
283 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c29 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
284 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c3 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
285 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c30 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
286 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c31 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
287 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c32 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
288 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c33 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
289 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c34 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
290 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c35 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
291 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c36 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
292 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c37 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
293 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c38 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
294 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c39 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
295 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c4 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
296 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c40 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
297 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c41 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
298 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c42 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
299 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c43 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
300 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c44 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
301 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c45 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
302 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c46 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
303 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c47 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
304 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c48 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
305 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c49 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
306 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c5 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
307 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c50 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
308 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c51 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
309 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c52 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
310 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c53 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
311 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c6 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
312 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c7 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
313 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c8 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
314 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).c9 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
315 POSTHOOK: Lineage: part_change_various_various_boolean_to_bigint PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:insert_num, type:int, comment:null), ]
316 insert_num      boolean1        boolean1        boolean1        boolean1        boolean1        boolean1        boolean1        boolean1        boolean1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        tinyint1        smallint1       smallint1       smallint1       smallint1       smallint1       smallint1       smallint1       smallint1       smallint1       smallint1       smallint1       int1    int1    int1    int1    int1    int1    int1    int1    int1    int1    int1    bigint1 bigint1 bigint1 bigint1 bigint1 bigint1 bigint1 bigint1 bigint1 bigint1 bigint1 _c54
317 PREHOOK: query: explain vectorization detail
318 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
319 PREHOOK: type: QUERY
320 POSTHOOK: query: explain vectorization detail
321 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
322 POSTHOOK: type: QUERY
323 Explain
324 PLAN VECTORIZATION:
325   enabled: true
326   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
327
328 STAGE DEPENDENCIES:
329   Stage-1 is a root stage
330   Stage-0 depends on stages: Stage-1
331
332 STAGE PLANS:
333   Stage: Stage-1
334     Tez
335 #### A masked pattern was here ####
336       Vertices:
337         Map 1 
338             Map Operator Tree:
339                 TableScan
340                   alias: part_change_various_various_boolean_to_bigint
341                   Statistics: Num rows: 10 Data size: 1228 Basic stats: COMPLETE Column stats: PARTIAL
342                   Select Operator
343                     expressions: insert_num (type: int), part (type: int), c1 (type: boolean), c2 (type: boolean), c3 (type: boolean), c4 (type: boolean), c5 (type: boolean), c6 (type: boolean), c7 (type: boolean), c8 (type: boolean), c9 (type: boolean), c10 (type: tinyint), c11 (type: tinyint), c12 (type: tinyint), c13 (type: tinyint), c14 (type: tinyint), c15 (type: tinyint), c16 (type: tinyint), c17 (type: tinyint), c18 (type: tinyint), c19 (type: tinyint), c20 (type: tinyint), c21 (type: smallint), c22 (type: smallint), c23 (type: smallint), c24 (type: smallint), c25 (type: smallint), c26 (type: smallint), c27 (type: smallint), c28 (type: smallint), c29 (type: smallint), c30 (type: smallint), c31 (type: smallint), c32 (type: int), c33 (type: int), c34 (type: int), c35 (type: int), c36 (type: int), c37 (type: int), c38 (type: int), c39 (type: int), c40 (type: int), c41 (type: int), c42 (type: int), c43 (type: bigint), c44 (type: bigint), c45 (type: bigint), c46 (type: bigint), c47 (type: bigint), c48 (type: bigint), c49 (type: bigint), c50 (type: bigint), c51 (type: bigint), c52 (type: bigint), c53 (type: bigint), b (type: string)
344                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35, _col36, _col37, _col38, _col39, _col40, _col41, _col42, _col43, _col44, _col45, _col46, _col47, _col48, _col49, _col50, _col51, _col52, _col53, _col54, _col55
345                     Statistics: Num rows: 10 Data size: 1228 Basic stats: COMPLETE Column stats: PARTIAL
346                     File Output Operator
347                       compressed: false
348                       Statistics: Num rows: 10 Data size: 1228 Basic stats: COMPLETE Column stats: PARTIAL
349                       table:
350                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
351                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
352                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
353             Execution mode: llap
354             LLAP IO: no inputs
355             Map Vectorization:
356                 enabled: false
357                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
358                 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
359                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
360
361   Stage: Stage-0
362     Fetch Operator
363       limit: -1
364       Processor Tree:
365         ListSink
366
367 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
368 PREHOOK: type: QUERY
369 PREHOOK: Input: default@part_change_various_various_boolean_to_bigint
370 PREHOOK: Input: default@part_change_various_various_boolean_to_bigint@part=1
371 #### A masked pattern was here ####
372 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b from part_change_various_various_boolean_to_bigint
373 POSTHOOK: type: QUERY
374 POSTHOOK: Input: default@part_change_various_various_boolean_to_bigint
375 POSTHOOK: Input: default@part_change_various_various_boolean_to_bigint@part=1
376 #### A masked pattern was here ####
377 insert_num      part    c1      c2      c3      c4      c5      c6      c7      c8      c9      c10     c11     c12     c13     c14     c15     c16     c17     c18     c19     c20     c21     c22     c23     c24     c25     c26     c27     c28     c29     c30     c31     c32     c33     c34     c35     c36     c37     c38     c39     c40     c41     c42     c43     c44     c45     c46     c47     c48     c49     c50     c51     c52     c53     b
378 101     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    true    NULL    NULL    -128    -128    -128    -128    -128    -128    -128    -128    -128    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    -2147483648     -2147483648     -2147483648     -2147483648     -2147483648     -2147483648     -2147483648     NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    new
379 101     1       true    NULL    true    NULL    true    true    true    true    true    1       NULL    0       NULL    -1      -1      NULL    -128    -128    -128    84      1       -128    0       NULL    -1      -1      NULL    NULL    NULL    NULL    -8620   1       -128    NULL    NULL    2147483647      2147483647      NULL    -2147483648     -2147483648     -2147483648     1272503892      1       -128    NULL    -2147483648     9223372036854775807     9223372036854775807     NULL    NULL    NULL    NULL    134416490068    original
380 102     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    false   NULL    NULL    127     127     127     127     127     127     127     127     127     NULL    NULL    NULL    32767   32767   32767   32767   32767   32767   32767   32767   NULL    NULL    NULL    NULL    2147483647      2147483647      2147483647      2147483647      2147483647      2147483647      2147483647      NULL    NULL    NULL    NULL    NULL    9223372036854775807     9223372036854775807     9223372036854775807     9223372036854775807     9223372036854775807     9223372036854775807     NULL    new
381 102     1       true    true    true    true    true    true    true    false   true    0       -1      -1      -1      0       0       NULL    127     127     127     -38     0       127     -1      -1      0       0       NULL    32767   32767   32767   7898    0       127     32767   -1      -2147483648     -2147483648     NULL    2147483647      2147483647      2147483647      1563893466      0       127     32767   2147483647      -9223372036854775808    -9223372036854775808    NULL    9223372036854775807     9223372036854775807     9223372036854775807     126117945050    original
382 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    new
383 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    false   NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    original
384 104     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    true    NULL    NULL    23      23      23      23      23      23      23      23      23      NULL    NULL    NULL    834     834     834     834     834     834     834     834     NULL    NULL    NULL    NULL    203332  203332  203332  203332  203332  203332  203332  NULL    NULL    NULL    NULL    NULL    888888847499264 888888857923222 888888857923222 888888857923222 888888857923222 888888857923222 NULL    new
385 104     1       true    true    true    true    true    true    true    true    true    1       66      68      -106    -100    30      NULL    23      23      23      86      1       23      6724    3734    -100    30      NULL    834     834     834     -12970  1       23      834     -1868624234     -100    30      66475   203332  203332  203332  270912854       1       23      834     203332  -100    30      66475   888888857923222 888888857923222 888888857923222 270912854       original
386 105     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    false   NULL    NULL    -99     -99     -99     -99     -99     -99     -99     -99     -99     NULL    NULL    NULL    -28300  -28300  -28300  -28300  -28300  -28300  -28300  -28300  NULL    NULL    NULL    NULL    -999992 -999992 -999992 -999992 -999992 -999992 -999992 NULL    NULL    NULL    NULL    NULL    -222282153984   -222282153733   -222282153733   -222282153733   -222282153733   -222282153733   NULL    new
387 105     1       true    true    true    true    NULL    true    true    false   true    0       116     -56     -5      NULL    34      NULL    -99     -99     -99     -41     0       -99     -16952  -32517  NULL    -19422  NULL    -28300  -28300  -28300  -16681  0       -99     -28300  1056145659      NULL    46114   9250340 -999992 -999992 -999992 663207639       0       -99     -28300  -999992 NULL    46114   9250340 -222282153733   -222282153733   -222282153733   663207639       original
388 PREHOOK: query: drop table part_change_various_various_boolean_to_bigint
389 PREHOOK: type: DROPTABLE
390 PREHOOK: Input: default@part_change_various_various_boolean_to_bigint
391 PREHOOK: Output: default@part_change_various_various_boolean_to_bigint
392 POSTHOOK: query: drop table part_change_various_various_boolean_to_bigint
393 POSTHOOK: type: DROPTABLE
394 POSTHOOK: Input: default@part_change_various_various_boolean_to_bigint
395 POSTHOOK: Output: default@part_change_various_various_boolean_to_bigint
396 PREHOOK: query: CREATE TABLE part_change_various_various_decimal_to_double(insert_num int,
397             c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP,
398             c12 BOOLEAN, c13 TINYINT, c14 SMALLINT, c15 INT, c16 BIGINT, c17 DECIMAL(38,18), c18 DOUBLE, c19 STRING, c20 CHAR(25), c21 VARCHAR(25), c22 TIMESTAMP,
399             c23 BOOLEAN, c24 TINYINT, c25 SMALLINT, c26 INT, c27 BIGINT, c28 DECIMAL(38,18), c29 FLOAT, c30 STRING, c31 CHAR(25), c32 VARCHAR(25), c33 TIMESTAMP,
400             b STRING) PARTITIONED BY(part INT)
401 PREHOOK: type: CREATETABLE
402 PREHOOK: Output: database:default
403 PREHOOK: Output: default@part_change_various_various_decimal_to_double
404 POSTHOOK: query: CREATE TABLE part_change_various_various_decimal_to_double(insert_num int,
405             c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP,
406             c12 BOOLEAN, c13 TINYINT, c14 SMALLINT, c15 INT, c16 BIGINT, c17 DECIMAL(38,18), c18 DOUBLE, c19 STRING, c20 CHAR(25), c21 VARCHAR(25), c22 TIMESTAMP,
407             c23 BOOLEAN, c24 TINYINT, c25 SMALLINT, c26 INT, c27 BIGINT, c28 DECIMAL(38,18), c29 FLOAT, c30 STRING, c31 CHAR(25), c32 VARCHAR(25), c33 TIMESTAMP,
408             b STRING) PARTITIONED BY(part INT)
409 POSTHOOK: type: CREATETABLE
410 POSTHOOK: Output: database:default
411 POSTHOOK: Output: default@part_change_various_various_decimal_to_double
412 PREHOOK: query: insert into table part_change_various_various_decimal_to_double partition(part=1) SELECT insert_num,
413             boolean1, tinyint1, smallint1, int1, bigint1, float1, double1, decimal_str, decimal_str, decimal_str, timestamp1,
414             boolean1, tinyint1, smallint1, int1, bigint1, decimal1, double1, float_str, float_str, float_str, timestamp1,
415             boolean1, tinyint1, smallint1, int1, bigint1, decimal1, float1, double_str, double_str, double_str, timestamp1,
416             'original' FROM schema_evolution_data
417 PREHOOK: type: QUERY
418 PREHOOK: Input: default@schema_evolution_data
419 PREHOOK: Output: default@part_change_various_various_decimal_to_double@part=1
420 POSTHOOK: query: insert into table part_change_various_various_decimal_to_double partition(part=1) SELECT insert_num,
421             boolean1, tinyint1, smallint1, int1, bigint1, float1, double1, decimal_str, decimal_str, decimal_str, timestamp1,
422             boolean1, tinyint1, smallint1, int1, bigint1, decimal1, double1, float_str, float_str, float_str, timestamp1,
423             boolean1, tinyint1, smallint1, int1, bigint1, decimal1, float1, double_str, double_str, double_str, timestamp1,
424             'original' FROM schema_evolution_data
425 POSTHOOK: type: QUERY
426 POSTHOOK: Input: default@schema_evolution_data
427 POSTHOOK: Output: default@part_change_various_various_decimal_to_double@part=1
428 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).b SIMPLE []
429 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c1 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
430 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c10 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal_str, type:string, comment:null), ]
431 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c11 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
432 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c12 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
433 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c13 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
434 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c14 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
435 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c15 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
436 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c16 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
437 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c17 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
438 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c18 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
439 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c19 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float_str, type:string, comment:null), ]
440 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c2 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
441 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c20 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float_str, type:string, comment:null), ]
442 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c21 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float_str, type:string, comment:null), ]
443 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c22 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
444 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c23 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
445 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c24 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
446 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c25 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
447 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c26 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
448 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c27 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
449 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c28 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
450 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c29 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
451 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c3 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
452 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c30 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double_str, type:string, comment:null), ]
453 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c31 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double_str, type:string, comment:null), ]
454 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c32 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double_str, type:string, comment:null), ]
455 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c33 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
456 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c4 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
457 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c5 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
458 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c6 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
459 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c7 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
460 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c8 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal_str, type:string, comment:null), ]
461 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c9 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal_str, type:string, comment:null), ]
462 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:insert_num, type:int, comment:null), ]
463 _col0   _col1   _col2   _col3   _col4   _col5   _col6   _col7   _col8   _col9   _col10  _col11  _col12  _col13  _col14  _col15  _col16  _col17  _col18  _col19  _col20  _col21  _col22  _col23  _col24  _col25  _col26  _col27  _col28  _col29  _col30  _col31  _col32  _col33  _col34
464 PREHOOK: query: explain vectorization detail
465 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
466 PREHOOK: type: QUERY
467 POSTHOOK: query: explain vectorization detail
468 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
469 POSTHOOK: type: QUERY
470 Explain
471 PLAN VECTORIZATION:
472   enabled: true
473   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
474
475 STAGE DEPENDENCIES:
476   Stage-1 is a root stage
477   Stage-0 depends on stages: Stage-1
478
479 STAGE PLANS:
480   Stage: Stage-1
481     Tez
482 #### A masked pattern was here ####
483       Vertices:
484         Map 1 
485             Map Operator Tree:
486                 TableScan
487                   alias: part_change_various_various_decimal_to_double
488                   Statistics: Num rows: 5 Data size: 7084 Basic stats: COMPLETE Column stats: PARTIAL
489                   TableScan Vectorization:
490                       native: true
491                       vectorizationSchemaColumns: [0:insert_num:int, 1:c1:boolean, 2:c2:tinyint, 3:c3:smallint, 4:c4:int, 5:c5:bigint, 6:c6:float, 7:c7:double, 8:c8:string, 9:c9:char(25), 10:c10:varchar(25), 11:c11:timestamp, 12:c12:boolean, 13:c13:tinyint, 14:c14:smallint, 15:c15:int, 16:c16:bigint, 17:c17:decimal(38,18), 18:c18:double, 19:c19:string, 20:c20:char(25), 21:c21:varchar(25), 22:c22:timestamp, 23:c23:boolean, 24:c24:tinyint, 25:c25:smallint, 26:c26:int, 27:c27:bigint, 28:c28:decimal(38,18), 29:c29:float, 30:c30:string, 31:c31:char(25), 32:c32:varchar(25), 33:c33:timestamp, 34:b:string, 35:part:int, 36:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
492                   Select Operator
493                     expressions: insert_num (type: int), part (type: int), c1 (type: boolean), c2 (type: tinyint), c3 (type: smallint), c4 (type: int), c5 (type: bigint), c6 (type: float), c7 (type: double), c8 (type: string), c9 (type: char(25)), c10 (type: varchar(25)), c11 (type: timestamp), c12 (type: boolean), c13 (type: tinyint), c14 (type: smallint), c15 (type: int), c16 (type: bigint), c17 (type: decimal(38,18)), c18 (type: double), c19 (type: string), c20 (type: char(25)), c21 (type: varchar(25)), c22 (type: timestamp), c23 (type: boolean), c24 (type: tinyint), c25 (type: smallint), c26 (type: int), c27 (type: bigint), c28 (type: decimal(38,18)), c29 (type: float), c30 (type: string), c31 (type: char(25)), c32 (type: varchar(25)), c33 (type: timestamp), b (type: string)
494                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35
495                     Select Vectorization:
496                         className: VectorSelectOperator
497                         native: true
498                         projectedOutputColumnNums: [0, 35, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34]
499                     Statistics: Num rows: 5 Data size: 7084 Basic stats: COMPLETE Column stats: PARTIAL
500                     File Output Operator
501                       compressed: false
502                       File Sink Vectorization:
503                           className: VectorFileSinkOperator
504                           native: false
505                       Statistics: Num rows: 5 Data size: 7084 Basic stats: COMPLETE Column stats: PARTIAL
506                       table:
507                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
508                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
509                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
510             Execution mode: vectorized, llap
511             LLAP IO: no inputs
512             Map Vectorization:
513                 enabled: true
514                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
515                 inputFormatFeatureSupport: [DECIMAL_64]
516                 vectorizationSupportRemovedReasons: [DECIMAL_64 disabled because LLAP is enabled]
517                 featureSupportInUse: []
518                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
519                 allNative: false
520                 usesVectorUDFAdaptor: false
521                 vectorized: true
522                 rowBatchContext:
523                     dataColumnCount: 35
524                     includeColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34]
525                     dataColumns: insert_num:int, c1:boolean, c2:tinyint, c3:smallint, c4:int, c5:bigint, c6:float, c7:double, c8:string, c9:char(25), c10:varchar(25), c11:timestamp, c12:boolean, c13:tinyint, c14:smallint, c15:int, c16:bigint, c17:decimal(38,18), c18:double, c19:string, c20:char(25), c21:varchar(25), c22:timestamp, c23:boolean, c24:tinyint, c25:smallint, c26:int, c27:bigint, c28:decimal(38,18), c29:float, c30:string, c31:char(25), c32:varchar(25), c33:timestamp, b:string
526                     partitionColumnCount: 1
527                     partitionColumns: part:int
528                     scratchColumnTypeNames: []
529
530   Stage: Stage-0
531     Fetch Operator
532       limit: -1
533       Processor Tree:
534         ListSink
535
536 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
537 PREHOOK: type: QUERY
538 PREHOOK: Input: default@part_change_various_various_decimal_to_double
539 PREHOOK: Input: default@part_change_various_various_decimal_to_double@part=1
540 #### A masked pattern was here ####
541 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
542 POSTHOOK: type: QUERY
543 POSTHOOK: Input: default@part_change_various_various_decimal_to_double
544 POSTHOOK: Input: default@part_change_various_various_decimal_to_double@part=1
545 #### A masked pattern was here ####
546 insert_num      part    c1      c2      c3      c4      c5      c6      c7      c8      c9      c10     c11     c12     c13     c14     c15     c16     c17     c18     c19     c20     c21     c22     c23     c24     c25     c26     c27     c28     c29     c30     c31     c32     c33     b
547 101     1       true    -128    NULL    -2147483648     NULL    Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 99999999999999999999.9999       99999999999999999999.9999       6229-06-28 02:54:28.970117179   true    -128    NULL    -2147483648     NULL    99999999999999999999.999999999999999999 1.7976931348623157E308  340282347000000000000000000000000000000000      3402823470000000000000000       3402823470000000000000000       6229-06-28 02:54:28.970117179   true    -128    NULL    -2147483648     NULL    99999999999999999999.999999999999999999 Infinity        1.79769313486231570E+308        1.79769313486231570E+308        1.79769313486231570E+308        6229-06-28 02:54:28.970117179   original
548 102     1       false   127     32767   2147483647      9223372036854775807     -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        -99999999999999999999.999       -99999999999999999999.999       5966-07-09 03:30:50.597 false   127     32767   2147483647      9223372036854775807     -99999999999999999999.999999999999999999        -1.7976931348623157E308 -340282347000000000000000000000000000000000     -340282347000000000000000       -340282347000000000000000       5966-07-09 03:30:50.597 false   127     32767   2147483647      9223372036854775807     -99999999999999999999.999999999999999999        -Infinity       -1.79769313486231570E+308       -1.79769313486231570E+308       -1.79769313486231570E+308       5966-07-09 03:30:50.597 original
549 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    original
550 104     1       true    23      834     203332  888888857923222 -100.35978      30.774  66475.561431    66475.561431                    66475.561431    1978-08-02 06:34:14     true    23      834     203332  888888857923222 66475.561431000000000000        30.774  -100.3597812    -100.3597812                    -100.3597812    1978-08-02 06:34:14     true    23      834     203332  888888857923222 66475.561431000000000000        -100.35978      30.774  30.774                          30.774  1978-08-02 06:34:14     original
551 105     1       false   -99     -28300  -999992 -222282153733   NULL    46114.28        9250340.75      9250340.75                      9250340.75      1991-01-06 16:20:39.72036854    false   -99     -28300  -999992 -222282153733   9250340.750000000000000000      46114.28        –32768        –32768                        –32768        1991-01-06 16:20:39.72036854    false   -99     -28300  -999992 -222282153733   9250340.750000000000000000      NULL    46114.28        46114.28                        46114.28        1991-01-06 16:20:39.72036854    original
552 PREHOOK: query: alter table part_change_various_various_decimal_to_double replace columns (insert_num int,
553              c1 DECIMAL(38,18), c2 DECIMAL(38,18), c3 DECIMAL(38,18), c4 DECIMAL(38,18), c5 DECIMAL(38,18), c6 DECIMAL(38,18), c7 DECIMAL(38,18), c8 DECIMAL(38,18), c9 DECIMAL(38,18), c10 DECIMAL(38,18), c11 DECIMAL(38,18), 
554              c12 FLOAT, c13 FLOAT, c14 FLOAT, c15 FLOAT, c16 FLOAT, c17 FLOAT, c18 FLOAT, c19 FLOAT, c20 FLOAT, c21 FLOAT, c22 FLOAT,
555              c23 DOUBLE, c24 DOUBLE, c25 DOUBLE, c26 DOUBLE, c27 DOUBLE, c28 DOUBLE, c29 DOUBLE, c30 DOUBLE, c31 DOUBLE, c32 DOUBLE, c33 DOUBLE,
556              b STRING)
557 PREHOOK: type: ALTERTABLE_REPLACECOLS
558 PREHOOK: Input: default@part_change_various_various_decimal_to_double
559 PREHOOK: Output: default@part_change_various_various_decimal_to_double
560 POSTHOOK: query: alter table part_change_various_various_decimal_to_double replace columns (insert_num int,
561              c1 DECIMAL(38,18), c2 DECIMAL(38,18), c3 DECIMAL(38,18), c4 DECIMAL(38,18), c5 DECIMAL(38,18), c6 DECIMAL(38,18), c7 DECIMAL(38,18), c8 DECIMAL(38,18), c9 DECIMAL(38,18), c10 DECIMAL(38,18), c11 DECIMAL(38,18), 
562              c12 FLOAT, c13 FLOAT, c14 FLOAT, c15 FLOAT, c16 FLOAT, c17 FLOAT, c18 FLOAT, c19 FLOAT, c20 FLOAT, c21 FLOAT, c22 FLOAT,
563              c23 DOUBLE, c24 DOUBLE, c25 DOUBLE, c26 DOUBLE, c27 DOUBLE, c28 DOUBLE, c29 DOUBLE, c30 DOUBLE, c31 DOUBLE, c32 DOUBLE, c33 DOUBLE,
564              b STRING)
565 POSTHOOK: type: ALTERTABLE_REPLACECOLS
566 POSTHOOK: Input: default@part_change_various_various_decimal_to_double
567 POSTHOOK: Output: default@part_change_various_various_decimal_to_double
568 PREHOOK: query: insert into table part_change_various_various_decimal_to_double partition(part=1) SELECT insert_num,
569              decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1,
570              float1, float1, float1, float1, float1, float1, float1, float1, float1, float1, float1,
571              double1, double1, double1, double1, double1, double1, double1, double1, double1, double1, double1,
572              'new' FROM schema_evolution_data_2 WHERE insert_num=111
573 PREHOOK: type: QUERY
574 PREHOOK: Input: default@schema_evolution_data_2
575 PREHOOK: Output: default@part_change_various_various_decimal_to_double@part=1
576 POSTHOOK: query: insert into table part_change_various_various_decimal_to_double partition(part=1) SELECT insert_num,
577              decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, decimal1,
578              float1, float1, float1, float1, float1, float1, float1, float1, float1, float1, float1,
579              double1, double1, double1, double1, double1, double1, double1, double1, double1, double1, double1,
580              'new' FROM schema_evolution_data_2 WHERE insert_num=111
581 POSTHOOK: type: QUERY
582 POSTHOOK: Input: default@schema_evolution_data_2
583 POSTHOOK: Output: default@part_change_various_various_decimal_to_double@part=1
584 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).b SIMPLE []
585 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c1 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
586 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c10 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
587 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c11 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
588 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c12 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
589 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c13 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
590 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c14 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
591 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c15 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
592 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c16 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
593 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c17 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
594 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c18 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
595 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c19 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
596 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c2 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
597 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c20 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
598 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c21 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
599 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c22 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:float1, type:float, comment:null), ]
600 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c23 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
601 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c24 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
602 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c25 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
603 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c26 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
604 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c27 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
605 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c28 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
606 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c29 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
607 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c3 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
608 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c30 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
609 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c31 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
610 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c32 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
611 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c33 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:double1, type:double, comment:null), ]
612 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c4 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
613 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c5 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
614 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c6 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
615 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c7 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
616 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c8 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
617 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).c9 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
618 POSTHOOK: Lineage: part_change_various_various_decimal_to_double PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:insert_num, type:int, comment:null), ]
619 insert_num      decimal1        decimal1        decimal1        decimal1        decimal1        decimal1        decimal1        decimal1        decimal1        decimal1        decimal1        float1  float1  float1  float1  float1  float1  float1  float1  float1  float1  float1  double1 double1 double1 double1 double1 double1 double1 double1 double1 double1 double1 _c34
620 PREHOOK: query: explain vectorization detail
621 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
622 PREHOOK: type: QUERY
623 POSTHOOK: query: explain vectorization detail
624 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
625 POSTHOOK: type: QUERY
626 Explain
627 PLAN VECTORIZATION:
628   enabled: true
629   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
630
631 STAGE DEPENDENCIES:
632   Stage-1 is a root stage
633   Stage-0 depends on stages: Stage-1
634
635 STAGE PLANS:
636   Stage: Stage-1
637     Tez
638 #### A masked pattern was here ####
639       Vertices:
640         Map 1 
641             Map Operator Tree:
642                 TableScan
643                   alias: part_change_various_various_decimal_to_double
644                   Statistics: Num rows: 6 Data size: 1320 Basic stats: COMPLETE Column stats: PARTIAL
645                   Select Operator
646                     expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), c2 (type: decimal(38,18)), c3 (type: decimal(38,18)), c4 (type: decimal(38,18)), c5 (type: decimal(38,18)), c6 (type: decimal(38,18)), c7 (type: decimal(38,18)), c8 (type: decimal(38,18)), c9 (type: decimal(38,18)), c10 (type: decimal(38,18)), c11 (type: decimal(38,18)), c12 (type: float), c13 (type: float), c14 (type: float), c15 (type: float), c16 (type: float), c17 (type: float), c18 (type: float), c19 (type: float), c20 (type: float), c21 (type: float), c22 (type: float), c23 (type: double), c24 (type: double), c25 (type: double), c26 (type: double), c27 (type: double), c28 (type: double), c29 (type: double), c30 (type: double), c31 (type: double), c32 (type: double), c33 (type: double), b (type: string)
647                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33, _col34, _col35
648                     Statistics: Num rows: 6 Data size: 1320 Basic stats: COMPLETE Column stats: PARTIAL
649                     File Output Operator
650                       compressed: false
651                       Statistics: Num rows: 6 Data size: 1320 Basic stats: COMPLETE Column stats: PARTIAL
652                       table:
653                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
654                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
655                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
656             Execution mode: llap
657             LLAP IO: no inputs
658             Map Vectorization:
659                 enabled: false
660                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
661                 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
662                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
663
664   Stage: Stage-0
665     Fetch Operator
666       limit: -1
667       Processor Tree:
668         ListSink
669
670 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
671 PREHOOK: type: QUERY
672 PREHOOK: Input: default@part_change_various_various_decimal_to_double
673 PREHOOK: Input: default@part_change_various_various_decimal_to_double@part=1
674 #### A masked pattern was here ####
675 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,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b from part_change_various_various_decimal_to_double
676 POSTHOOK: type: QUERY
677 POSTHOOK: Input: default@part_change_various_various_decimal_to_double
678 POSTHOOK: Input: default@part_change_various_various_decimal_to_double@part=1
679 #### A masked pattern was here ####
680 insert_num      part    c1      c2      c3      c4      c5      c6      c7      c8      c9      c10     c11     c12     c13     c14     c15     c16     c17     c18     c19     c20     c21     c22     c23     c24     c25     c26     c27     c28     c29     c30     c31     c32     c33     b
681 101     1       1.000000000000000000    -128.000000000000000000 NULL    -2147483648.000000000000000000  NULL    NULL    NULL    99999999999999999999.999999999999999999 99999999999999999999.999900000000000000 99999999999999999999.999900000000000000 134416490068.970120000000000000 1.0     -128.0  NULL    -2.14748365E9   NULL    1.0E20  Infinity        Infinity        3.4028236E24    3.4028236E24    1.3441649E11    1.0     -128.0  NULL    -2.147483648E9  NULL    1.0E20  Infinity        1.7976931348623157E308  1.7976931348623157E308  1.7976931348623157E308  1.3441649006897012E11   original
682 102     1       0.000000000000000000    127.000000000000000000  32767.000000000000000000        2147483647.000000000000000000   9223372036854775807.000000000000000000  NULL    NULL    -99999999999999999999.999999999999999999        -99999999999999999999.999000000000000000        -99999999999999999999.999000000000000000        126117945050.597000000000000000 0.0     127.0   32767.0 2.14748365E9    9.223372E18     -1.0E20 -Infinity       -Infinity       -3.4028233E23   -3.4028233E23   1.26117945E11   0.0     127.0   32767.0 2.147483647E9   9.223372036854776E18    -1.0E20 -Infinity       -1.7976931348623157E308 -1.7976931348623157E308 -1.7976931348623157E308 1.26117945050597E11     original
683 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    original
684 104     1       1.000000000000000000    23.000000000000000000   834.000000000000000000  203332.000000000000000000       888888857923222.000000000000000000      -100.359780000000000000 30.774000000000000000   66475.561431000000000000        66475.561431000000000000        66475.561431000000000000        270912854.000000000000000000    1.0     23.0    834.0   203332.0        8.8888885E14    66475.56        30.774  -100.35978      -100.35978      -100.35978      2.70912864E8    1.0     23.0    834.0   203332.0        8.88888857923222E14     66475.561431    -100.35977935791016     30.774  30.774  30.774  2.70912854E8    original
685 105     1       0.000000000000000000    -99.000000000000000000  -28300.000000000000000000       -999992.000000000000000000      -222282153733.000000000000000000        NULL    46114.280000000000000000        9250340.750000000000000000      9250340.750000000000000000      9250340.750000000000000000      663207639.720368500000000000    0.0     -99.0   -28300.0        -999992.0       -2.22282154E11  9250341.0       46114.28        NULL    NULL    NULL    6.6320762E8     0.0     -99.0   -28300.0        -999992.0       -2.22282153733E11       9250340.75      NULL    46114.28        46114.28        46114.28        6.632076397203685E8     original
686 111     1       NULL    NULL    NULL    -46114.000000000000000000       -46114.000000000000000000       -46114.285000000000000000       -46114.284799488000000000       -46114.284799488000000000       -46114.284799488000000000       -46114.284799488000000000       NULL    NULL    NULL    NULL    NULL    NULL    -9.0E-8 -9.0E-8 -9.0E-8 -9.0E-8 -9.0E-8 NULL    NULL    NULL    NULL    NULL    NULL    -9.0E-8 -9.000000034120603E-8   -9.0E-8 -9.0E-8 -9.0E-8 NULL    new
687 PREHOOK: query: drop table part_change_various_various_decimal_to_double
688 PREHOOK: type: DROPTABLE
689 PREHOOK: Input: default@part_change_various_various_decimal_to_double
690 PREHOOK: Output: default@part_change_various_various_decimal_to_double
691 POSTHOOK: query: drop table part_change_various_various_decimal_to_double
692 POSTHOOK: type: DROPTABLE
693 POSTHOOK: Input: default@part_change_various_various_decimal_to_double
694 POSTHOOK: Output: default@part_change_various_various_decimal_to_double
695 PREHOOK: query: CREATE TABLE part_change_various_various_timestamp(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 CHAR(25), c11 VARCHAR(25), c12 DATE, b STRING) PARTITIONED BY(part INT)
696 PREHOOK: type: CREATETABLE
697 PREHOOK: Output: database:default
698 PREHOOK: Output: default@part_change_various_various_timestamp
699 POSTHOOK: query: CREATE TABLE part_change_various_various_timestamp(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 CHAR(25), c11 VARCHAR(25), c12 DATE, b STRING) PARTITIONED BY(part INT)
700 POSTHOOK: type: CREATETABLE
701 POSTHOOK: Output: database:default
702 POSTHOOK: Output: default@part_change_various_various_timestamp
703 PREHOOK: query: insert into table part_change_various_various_timestamp partition(part=1) SELECT insert_num, boolean1, tinyint1, smallint1, int1, bigint1, float1, double1, decimal1, timestamp_str, timestamp_str, timestamp_str, date1, 'original' FROM schema_evolution_data
704 PREHOOK: type: QUERY
705 PREHOOK: Input: default@schema_evolution_data
706 PREHOOK: Output: default@part_change_various_various_timestamp@part=1
707 POSTHOOK: query: insert into table part_change_various_various_timestamp partition(part=1) SELECT insert_num, boolean1, tinyint1, smallint1, int1, bigint1, float1, double1, decimal1, timestamp_str, timestamp_str, timestamp_str, date1, 'original' FROM schema_evolution_data
708 POSTHOOK: type: QUERY
709 POSTHOOK: Input: default@schema_evolution_data
710 POSTHOOK: Output: default@part_change_various_various_timestamp@part=1
711 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).b SIMPLE []
712 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c1 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:boolean1, type:boolean, comment:null), ]
713 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c10 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp_str, type:string, comment:null), ]
714 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c11 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp_str, type:string, comment:null), ]
715 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c12 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:date1, type:date, comment:null), ]
716 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c2 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:tinyint1, type:tinyint, comment:null), ]
717 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c3 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:smallint1, type:smallint, comment:null), ]
718 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c4 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:int1, type:int, comment:null), ]
719 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c5 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:bigint1, type:bigint, comment:null), ]
720 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c6 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:float1, type:float, comment:null), ]
721 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c7 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:double1, type:double, comment:null), ]
722 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c8 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:decimal1, type:decimal(38,18), comment:null), ]
723 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c9 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp_str, type:string, comment:null), ]
724 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:insert_num, type:int, comment:null), ]
725 _col0   _col1   _col2   _col3   _col4   _col5   _col6   _col7   _col8   _col9   _col10  _col11  _col12  _col13
726 PREHOOK: query: explain vectorization detail
727 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
728 PREHOOK: type: QUERY
729 POSTHOOK: query: explain vectorization detail
730 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
731 POSTHOOK: type: QUERY
732 Explain
733 PLAN VECTORIZATION:
734   enabled: true
735   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
736
737 STAGE DEPENDENCIES:
738   Stage-1 is a root stage
739   Stage-0 depends on stages: Stage-1
740
741 STAGE PLANS:
742   Stage: Stage-1
743     Tez
744 #### A masked pattern was here ####
745       Vertices:
746         Map 1 
747             Map Operator Tree:
748                 TableScan
749                   alias: part_change_various_various_timestamp
750                   Statistics: Num rows: 5 Data size: 4830 Basic stats: COMPLETE Column stats: PARTIAL
751                   TableScan Vectorization:
752                       native: true
753                       vectorizationSchemaColumns: [0:insert_num:int, 1:c1:boolean, 2:c2:tinyint, 3:c3:smallint, 4:c4:int, 5:c5:bigint, 6:c6:float, 7:c7:double, 8:c8:decimal(38,18), 9:c9:string, 10:c10:char(25), 11:c11:varchar(25), 12:c12:date, 13:b:string, 14:part:int, 15:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
754                   Select Operator
755                     expressions: insert_num (type: int), part (type: int), c1 (type: boolean), c2 (type: tinyint), c3 (type: smallint), c4 (type: int), c5 (type: bigint), c6 (type: float), c7 (type: double), c8 (type: decimal(38,18)), c9 (type: string), c10 (type: char(25)), c11 (type: varchar(25)), c12 (type: date), b (type: string)
756                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14
757                     Select Vectorization:
758                         className: VectorSelectOperator
759                         native: true
760                         projectedOutputColumnNums: [0, 14, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]
761                     Statistics: Num rows: 5 Data size: 3990 Basic stats: COMPLETE Column stats: PARTIAL
762                     File Output Operator
763                       compressed: false
764                       File Sink Vectorization:
765                           className: VectorFileSinkOperator
766                           native: false
767                       Statistics: Num rows: 5 Data size: 3990 Basic stats: COMPLETE Column stats: PARTIAL
768                       table:
769                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
770                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
771                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
772             Execution mode: vectorized, llap
773             LLAP IO: no inputs
774             Map Vectorization:
775                 enabled: true
776                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
777                 inputFormatFeatureSupport: [DECIMAL_64]
778                 vectorizationSupportRemovedReasons: [DECIMAL_64 disabled because LLAP is enabled]
779                 featureSupportInUse: []
780                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
781                 allNative: false
782                 usesVectorUDFAdaptor: false
783                 vectorized: true
784                 rowBatchContext:
785                     dataColumnCount: 14
786                     includeColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]
787                     dataColumns: insert_num:int, c1:boolean, c2:tinyint, c3:smallint, c4:int, c5:bigint, c6:float, c7:double, c8:decimal(38,18), c9:string, c10:char(25), c11:varchar(25), c12:date, b:string
788                     partitionColumnCount: 1
789                     partitionColumns: part:int
790                     scratchColumnTypeNames: []
791
792   Stage: Stage-0
793     Fetch Operator
794       limit: -1
795       Processor Tree:
796         ListSink
797
798 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
799 PREHOOK: type: QUERY
800 PREHOOK: Input: default@part_change_various_various_timestamp
801 PREHOOK: Input: default@part_change_various_various_timestamp@part=1
802 #### A masked pattern was here ####
803 POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
804 POSTHOOK: type: QUERY
805 POSTHOOK: Input: default@part_change_various_various_timestamp
806 POSTHOOK: Input: default@part_change_various_various_timestamp@part=1
807 #### A masked pattern was here ####
808 insert_num      part    c1      c2      c3      c4      c5      c6      c7      c8      c9      c10     c11     c12     b
809 101     1       true    -128    NULL    -2147483648     NULL    Infinity        1.7976931348623157E308  99999999999999999999.999999999999999999 6229-06-28 02:54:28.970117179   6229-06-28 02:54:28.97011       6229-06-28 02:54:28.97011       1950-12-18      original
810 102     1       false   127     32767   2147483647      9223372036854775807     -Infinity       -1.7976931348623157E308 -99999999999999999999.999999999999999999        5966-07-09 03:30:50.597 5966-07-09 03:30:50.597         5966-07-09 03:30:50.597 2049-12-18      original
811 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL                                                    NULL    original
812 104     1       true    23      834     203332  888888857923222 -100.35978      30.774  66475.561431000000000000        1978-08-02 06:34:14     1978-08-02 06:34:14             1978-08-02 06:34:14     2021-09-24      original
813 105     1       false   -99     -28300  -999992 -222282153733   NULL    46114.28        9250340.750000000000000000      1991-01-06 16:20:39.72036854    1991-01-06 16:20:39.72036       1991-01-06 16:20:39.72036       2024-11-11      original
814 PREHOOK: query: alter table part_change_various_various_timestamp replace columns (insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, c6 TIMESTAMP, c7 TIMESTAMP, c8 TIMESTAMP, c9 TIMESTAMP, c10 TIMESTAMP, c11 TIMESTAMP, c12 TIMESTAMP, b STRING)
815 PREHOOK: type: ALTERTABLE_REPLACECOLS
816 PREHOOK: Input: default@part_change_various_various_timestamp
817 PREHOOK: Output: default@part_change_various_various_timestamp
818 POSTHOOK: query: alter table part_change_various_various_timestamp replace columns (insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, c6 TIMESTAMP, c7 TIMESTAMP, c8 TIMESTAMP, c9 TIMESTAMP, c10 TIMESTAMP, c11 TIMESTAMP, c12 TIMESTAMP, b STRING)
819 POSTHOOK: type: ALTERTABLE_REPLACECOLS
820 POSTHOOK: Input: default@part_change_various_various_timestamp
821 POSTHOOK: Output: default@part_change_various_various_timestamp
822 PREHOOK: query: insert into table part_change_various_various_timestamp partition(part=1) SELECT insert_num, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, 'new' FROM schema_evolution_data_2 WHERE insert_num=111
823 PREHOOK: type: QUERY
824 PREHOOK: Input: default@schema_evolution_data_2
825 PREHOOK: Output: default@part_change_various_various_timestamp@part=1
826 POSTHOOK: query: insert into table part_change_various_various_timestamp partition(part=1) SELECT insert_num, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, 'new' FROM schema_evolution_data_2 WHERE insert_num=111
827 POSTHOOK: type: QUERY
828 POSTHOOK: Input: default@schema_evolution_data_2
829 POSTHOOK: Output: default@part_change_various_various_timestamp@part=1
830 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).b SIMPLE []
831 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c1 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
832 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c10 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
833 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c11 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
834 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c12 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
835 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c2 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
836 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c3 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
837 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c4 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
838 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c5 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
839 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c6 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
840 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c7 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
841 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c8 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
842 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).c9 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
843 POSTHOOK: Lineage: part_change_various_various_timestamp PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:insert_num, type:int, comment:null), ]
844 insert_num      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      timestamp1      _c13
845 PREHOOK: query: explain vectorization detail
846 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
847 PREHOOK: type: QUERY
848 POSTHOOK: query: explain vectorization detail
849 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
850 POSTHOOK: type: QUERY
851 Explain
852 PLAN VECTORIZATION:
853   enabled: true
854   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
855
856 STAGE DEPENDENCIES:
857   Stage-1 is a root stage
858   Stage-0 depends on stages: Stage-1
859
860 STAGE PLANS:
861   Stage: Stage-1
862     Tez
863 #### A masked pattern was here ####
864       Vertices:
865         Map 1 
866             Map Operator Tree:
867                 TableScan
868                   alias: part_change_various_various_timestamp
869                   Statistics: Num rows: 6 Data size: 4915 Basic stats: COMPLETE Column stats: PARTIAL
870                   Select Operator
871                     expressions: insert_num (type: int), part (type: int), c1 (type: timestamp), c2 (type: timestamp), c3 (type: timestamp), c4 (type: timestamp), c5 (type: timestamp), c6 (type: timestamp), c7 (type: timestamp), c8 (type: timestamp), c9 (type: timestamp), c10 (type: timestamp), c11 (type: timestamp), c12 (type: timestamp), b (type: string)
872                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14
873                     Statistics: Num rows: 6 Data size: 4032 Basic stats: COMPLETE Column stats: PARTIAL
874                     File Output Operator
875                       compressed: false
876                       Statistics: Num rows: 6 Data size: 4032 Basic stats: COMPLETE Column stats: PARTIAL
877                       table:
878                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
879                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
880                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
881             Execution mode: llap
882             LLAP IO: no inputs
883             Map Vectorization:
884                 enabled: false
885                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
886                 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
887                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
888
889   Stage: Stage-0
890     Fetch Operator
891       limit: -1
892       Processor Tree:
893         ListSink
894
895 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
896 PREHOOK: type: QUERY
897 PREHOOK: Input: default@part_change_various_various_timestamp
898 PREHOOK: Input: default@part_change_various_various_timestamp@part=1
899 #### A masked pattern was here ####
900 POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp
901 POSTHOOK: type: QUERY
902 POSTHOOK: Input: default@part_change_various_various_timestamp
903 POSTHOOK: Input: default@part_change_various_various_timestamp@part=1
904 #### A masked pattern was here ####
905 insert_num      part    c1      c2      c3      c4      c5      c6      c7      c8      c9      c10     c11     c12     b
906 101     1       1969-12-31 16:00:00.001 1969-12-31 15:59:59.872 NULL    1969-12-06 19:28:36.352 NULL    NULL    NULL    NULL    6229-06-28 02:54:28.970117179   6229-06-28 02:54:28.97011       6229-06-28 02:54:28.97011       1950-12-18 00:00:00     original
907 102     1       1969-12-31 16:00:00     1969-12-31 16:00:00.127 1969-12-31 16:00:32.767 1970-01-25 12:31:23.647 NULL    NULL    1969-12-31 16:00:00     NULL    5966-07-09 03:30:50.597 5966-07-09 03:30:50.597 5966-07-09 03:30:50.597 2049-12-18 00:00:00     original
908 103     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    original
909 104     1       1969-12-31 16:00:00.001 1969-12-31 16:00:00.023 1969-12-31 16:00:00.834 1969-12-31 16:03:23.332 NULL    1969-12-31 15:58:19.640220643   1969-12-31 16:00:30.774 1970-01-01 10:27:55.561431      1978-08-02 06:34:14     1978-08-02 06:34:14     1978-08-02 06:34:14     2021-09-24 00:00:00     original
910 105     1       1969-12-31 16:00:00     1969-12-31 15:59:59.901 1969-12-31 15:59:31.7   1969-12-31 15:43:20.008 1962-12-15 22:57:26.267 NULL    1970-01-01 04:48:34.28  1970-04-17 17:32:20.75  1991-01-06 16:20:39.72036854    1991-01-06 16:20:39.72036       1991-01-06 16:20:39.72036       2024-11-11 00:00:00     original
911 111     1       NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    new
912 PREHOOK: query: drop table part_change_various_various_timestamp
913 PREHOOK: type: DROPTABLE
914 PREHOOK: Input: default@part_change_various_various_timestamp
915 PREHOOK: Output: default@part_change_various_various_timestamp
916 POSTHOOK: query: drop table part_change_various_various_timestamp
917 POSTHOOK: type: DROPTABLE
918 POSTHOOK: Input: default@part_change_various_various_timestamp
919 POSTHOOK: Output: default@part_change_various_various_timestamp
920 PREHOOK: query: CREATE TABLE part_change_various_various_date(insert_num int, c1 STRING, c2 CHAR(25), c3 VARCHAR(25), c4 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
921 PREHOOK: type: CREATETABLE
922 PREHOOK: Output: database:default
923 PREHOOK: Output: default@part_change_various_various_date
924 POSTHOOK: query: CREATE TABLE part_change_various_various_date(insert_num int, c1 STRING, c2 CHAR(25), c3 VARCHAR(25), c4 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
925 POSTHOOK: type: CREATETABLE
926 POSTHOOK: Output: database:default
927 POSTHOOK: Output: default@part_change_various_various_date
928 PREHOOK: query: insert into table part_change_various_various_date partition(part=1) SELECT insert_num, date_str, date_str, date_str, timestamp1, 'original' FROM schema_evolution_data
929 PREHOOK: type: QUERY
930 PREHOOK: Input: default@schema_evolution_data
931 PREHOOK: Output: default@part_change_various_various_date@part=1
932 POSTHOOK: query: insert into table part_change_various_various_date partition(part=1) SELECT insert_num, date_str, date_str, date_str, timestamp1, 'original' FROM schema_evolution_data
933 POSTHOOK: type: QUERY
934 POSTHOOK: Input: default@schema_evolution_data
935 POSTHOOK: Output: default@part_change_various_various_date@part=1
936 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).b SIMPLE []
937 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c1 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:date_str, type:string, comment:null), ]
938 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c2 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:date_str, type:string, comment:null), ]
939 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c3 EXPRESSION [(schema_evolution_data)schema_evolution_data.FieldSchema(name:date_str, type:string, comment:null), ]
940 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c4 SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:timestamp1, type:timestamp, comment:null), ]
941 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data)schema_evolution_data.FieldSchema(name:insert_num, type:int, comment:null), ]
942 _col0   _col1   _col2   _col3   _col4   _col5
943 PREHOOK: query: explain vectorization detail
944 select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
945 PREHOOK: type: QUERY
946 POSTHOOK: query: explain vectorization detail
947 select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
948 POSTHOOK: type: QUERY
949 Explain
950 PLAN VECTORIZATION:
951   enabled: true
952   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
953
954 STAGE DEPENDENCIES:
955   Stage-1 is a root stage
956   Stage-0 depends on stages: Stage-1
957
958 STAGE PLANS:
959   Stage: Stage-1
960     Tez
961 #### A masked pattern was here ####
962       Vertices:
963         Map 1 
964             Map Operator Tree:
965                 TableScan
966                   alias: part_change_various_various_date
967                   Statistics: Num rows: 5 Data size: 2080 Basic stats: COMPLETE Column stats: COMPLETE
968                   TableScan Vectorization:
969                       native: true
970                       vectorizationSchemaColumns: [0:insert_num:int, 1:c1:string, 2:c2:char(25), 3:c3:varchar(25), 4:c4:timestamp, 5:b:string, 6:part:int, 7:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
971                   Select Operator
972                     expressions: insert_num (type: int), part (type: int), c1 (type: string), c2 (type: char(25)), c3 (type: varchar(25)), c4 (type: timestamp), b (type: string)
973                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
974                     Select Vectorization:
975                         className: VectorSelectOperator
976                         native: true
977                         projectedOutputColumnNums: [0, 6, 1, 2, 3, 4, 5]
978                     Statistics: Num rows: 5 Data size: 2080 Basic stats: COMPLETE Column stats: COMPLETE
979                     File Output Operator
980                       compressed: false
981                       File Sink Vectorization:
982                           className: VectorFileSinkOperator
983                           native: false
984                       Statistics: Num rows: 5 Data size: 2080 Basic stats: COMPLETE Column stats: COMPLETE
985                       table:
986                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
987                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
988                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
989             Execution mode: vectorized, llap
990             LLAP IO: no inputs
991             Map Vectorization:
992                 enabled: true
993                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
994                 inputFormatFeatureSupport: [DECIMAL_64]
995                 vectorizationSupportRemovedReasons: [DECIMAL_64 disabled because LLAP is enabled]
996                 featureSupportInUse: []
997                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
998                 allNative: false
999                 usesVectorUDFAdaptor: false
1000                 vectorized: true
1001                 rowBatchContext:
1002                     dataColumnCount: 6
1003                     includeColumns: [0, 1, 2, 3, 4, 5]
1004                     dataColumns: insert_num:int, c1:string, c2:char(25), c3:varchar(25), c4:timestamp, b:string
1005                     partitionColumnCount: 1
1006                     partitionColumns: part:int
1007                     scratchColumnTypeNames: []
1008
1009   Stage: Stage-0
1010     Fetch Operator
1011       limit: -1
1012       Processor Tree:
1013         ListSink
1014
1015 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
1016 PREHOOK: type: QUERY
1017 PREHOOK: Input: default@part_change_various_various_date
1018 PREHOOK: Input: default@part_change_various_various_date@part=1
1019 #### A masked pattern was here ####
1020 POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
1021 POSTHOOK: type: QUERY
1022 POSTHOOK: Input: default@part_change_various_various_date
1023 POSTHOOK: Input: default@part_change_various_various_date@part=1
1024 #### A masked pattern was here ####
1025 insert_num      part    c1      c2      c3      c4      b
1026 101     1       1950-12-18      1950-12-18                      1950-12-18      6229-06-28 02:54:28.970117179   original
1027 102     1       2049-12-18      2049-12-18                      2049-12-18      5966-07-09 03:30:50.597 original
1028 103     1                                                       NULL    original
1029 104     1       2021-09-24      2021-09-24                      2021-09-24      1978-08-02 06:34:14     original
1030 105     1       2024-11-11      2024-11-11                      2024-11-11      1991-01-06 16:20:39.72036854    original
1031 PREHOOK: query: alter table part_change_various_various_date replace columns (insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, b STRING)
1032 PREHOOK: type: ALTERTABLE_REPLACECOLS
1033 PREHOOK: Input: default@part_change_various_various_date
1034 PREHOOK: Output: default@part_change_various_various_date
1035 POSTHOOK: query: alter table part_change_various_various_date replace columns (insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, b STRING)
1036 POSTHOOK: type: ALTERTABLE_REPLACECOLS
1037 POSTHOOK: Input: default@part_change_various_various_date
1038 POSTHOOK: Output: default@part_change_various_various_date
1039 PREHOOK: query: insert into table part_change_various_various_date partition(part=1) SELECT insert_num, date1, date1, date1, date1, 'new' FROM schema_evolution_data_2 WHERE insert_num=111
1040 PREHOOK: type: QUERY
1041 PREHOOK: Input: default@schema_evolution_data_2
1042 PREHOOK: Output: default@part_change_various_various_date@part=1
1043 POSTHOOK: query: insert into table part_change_various_various_date partition(part=1) SELECT insert_num, date1, date1, date1, date1, 'new' FROM schema_evolution_data_2 WHERE insert_num=111
1044 POSTHOOK: type: QUERY
1045 POSTHOOK: Input: default@schema_evolution_data_2
1046 POSTHOOK: Output: default@part_change_various_various_date@part=1
1047 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).b SIMPLE []
1048 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c1 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:date1, type:date, comment:null), ]
1049 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c2 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:date1, type:date, comment:null), ]
1050 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c3 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:date1, type:date, comment:null), ]
1051 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).c4 SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:date1, type:date, comment:null), ]
1052 POSTHOOK: Lineage: part_change_various_various_date PARTITION(part=1).insert_num SIMPLE [(schema_evolution_data_2)schema_evolution_data_2.FieldSchema(name:insert_num, type:int, comment:null), ]
1053 insert_num      date1   date1   date1   date1   _c5
1054 PREHOOK: query: explain vectorization detail
1055 select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
1056 PREHOOK: type: QUERY
1057 POSTHOOK: query: explain vectorization detail
1058 select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
1059 POSTHOOK: type: QUERY
1060 Explain
1061 PLAN VECTORIZATION:
1062   enabled: true
1063   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
1064
1065 STAGE DEPENDENCIES:
1066   Stage-1 is a root stage
1067   Stage-0 depends on stages: Stage-1
1068
1069 STAGE PLANS:
1070   Stage: Stage-1
1071     Tez
1072 #### A masked pattern was here ####
1073       Vertices:
1074         Map 1 
1075             Map Operator Tree:
1076                 TableScan
1077                   alias: part_change_various_various_date
1078                   Statistics: Num rows: 6 Data size: 2496 Basic stats: COMPLETE Column stats: COMPLETE
1079                   Select Operator
1080                     expressions: insert_num (type: int), part (type: int), c1 (type: date), c2 (type: date), c3 (type: date), c4 (type: date), b (type: string)
1081                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
1082                     Statistics: Num rows: 6 Data size: 2496 Basic stats: COMPLETE Column stats: COMPLETE
1083                     File Output Operator
1084                       compressed: false
1085                       Statistics: Num rows: 6 Data size: 2496 Basic stats: COMPLETE Column stats: COMPLETE
1086                       table:
1087                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
1088                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
1089                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1090             Execution mode: llap
1091             LLAP IO: no inputs
1092             Map Vectorization:
1093                 enabled: false
1094                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
1095                 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
1096                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
1097
1098   Stage: Stage-0
1099     Fetch Operator
1100       limit: -1
1101       Processor Tree:
1102         ListSink
1103
1104 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
1105 PREHOOK: type: QUERY
1106 PREHOOK: Input: default@part_change_various_various_date
1107 PREHOOK: Input: default@part_change_various_various_date@part=1
1108 #### A masked pattern was here ####
1109 POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date
1110 POSTHOOK: type: QUERY
1111 POSTHOOK: Input: default@part_change_various_various_date
1112 POSTHOOK: Input: default@part_change_various_various_date@part=1
1113 #### A masked pattern was here ####
1114 insert_num      part    c1      c2      c3      c4      b
1115 101     1       1950-12-18      1950-12-18      1950-12-18      6229-06-28      original
1116 102     1       2049-12-18      2049-12-18      2049-12-18      5966-07-09      original
1117 103     1       NULL    NULL    NULL    NULL    original
1118 104     1       2021-09-24      2021-09-24      2021-09-24      1978-08-02      original
1119 105     1       2024-11-11      2024-11-11      2024-11-11      1991-01-06      original
1120 111     1       1964-01-24      1964-01-24      1964-01-24      NULL    new
1121 PREHOOK: query: drop table part_change_various_various_date
1122 PREHOOK: type: DROPTABLE
1123 PREHOOK: Input: default@part_change_various_various_date
1124 PREHOOK: Output: default@part_change_various_various_date
1125 POSTHOOK: query: drop table part_change_various_various_date
1126 POSTHOOK: type: DROPTABLE
1127 POSTHOOK: Input: default@part_change_various_various_date
1128 POSTHOOK: Output: default@part_change_various_various_date
1129 PREHOOK: query: CREATE TABLE part_change_same_type_different_params(insert_num int, c1 CHAR(12), c2 CHAR(25), c3 VARCHAR(25), c4 VARCHAR(10), c5 DECIMAL(12,4), c6 DECIMAL(20,10), b STRING) PARTITIONED BY(part INT)
1130 PREHOOK: type: CREATETABLE
1131 PREHOOK: Output: database:default
1132 PREHOOK: Output: default@part_change_same_type_different_params
1133 POSTHOOK: query: CREATE TABLE part_change_same_type_different_params(insert_num int, c1 CHAR(12), c2 CHAR(25), c3 VARCHAR(25), c4 VARCHAR(10), c5 DECIMAL(12,4), c6 DECIMAL(20,10), b STRING) PARTITIONED BY(part INT)
1134 POSTHOOK: type: CREATETABLE
1135 POSTHOOK: Output: database:default
1136 POSTHOOK: Output: default@part_change_same_type_different_params
1137 PREHOOK: query: CREATE TABLE same_type1_a_txt(insert_num int, c1 CHAR(12), c2 CHAR(25), c3 VARCHAR(25), c4 VARCHAR(10), c5 DECIMAL(12,4), c6 DECIMAL(20,10), b STRING)
1138 row format delimited fields terminated by '|'
1139 stored as textfile
1140 PREHOOK: type: CREATETABLE
1141 PREHOOK: Output: database:default
1142 PREHOOK: Output: default@same_type1_a_txt
1143 POSTHOOK: query: CREATE TABLE same_type1_a_txt(insert_num int, c1 CHAR(12), c2 CHAR(25), c3 VARCHAR(25), c4 VARCHAR(10), c5 DECIMAL(12,4), c6 DECIMAL(20,10), b STRING)
1144 row format delimited fields terminated by '|'
1145 stored as textfile
1146 POSTHOOK: type: CREATETABLE
1147 POSTHOOK: Output: database:default
1148 POSTHOOK: Output: default@same_type1_a_txt
1149 PREHOOK: query: load data local inpath '../../data/files/schema_evolution/same_type1_a.txt' overwrite into table same_type1_a_txt
1150 PREHOOK: type: LOAD
1151 #### A masked pattern was here ####
1152 PREHOOK: Output: default@same_type1_a_txt
1153 POSTHOOK: query: load data local inpath '../../data/files/schema_evolution/same_type1_a.txt' overwrite into table same_type1_a_txt
1154 POSTHOOK: type: LOAD
1155 #### A masked pattern was here ####
1156 POSTHOOK: Output: default@same_type1_a_txt
1157 PREHOOK: query: insert into table part_change_same_type_different_params partition(part=1) select * from same_type1_a_txt
1158 PREHOOK: type: QUERY
1159 PREHOOK: Input: default@same_type1_a_txt
1160 PREHOOK: Output: default@part_change_same_type_different_params@part=1
1161 POSTHOOK: query: insert into table part_change_same_type_different_params partition(part=1) select * from same_type1_a_txt
1162 POSTHOOK: type: QUERY
1163 POSTHOOK: Input: default@same_type1_a_txt
1164 POSTHOOK: Output: default@part_change_same_type_different_params@part=1
1165 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).b SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:b, type:string, comment:null), ]
1166 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c1 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c1, type:char(12), comment:null), ]
1167 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c2 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c2, type:char(25), comment:null), ]
1168 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c3 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c3, type:varchar(25), comment:null), ]
1169 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c4 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c4, type:varchar(10), comment:null), ]
1170 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c5 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c5, type:decimal(12,4), comment:null), ]
1171 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c6 SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:c6, type:decimal(20,10), comment:null), ]
1172 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).insert_num SIMPLE [(same_type1_a_txt)same_type1_a_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
1173 same_type1_a_txt.insert_num     same_type1_a_txt.c1     same_type1_a_txt.c2     same_type1_a_txt.c3     same_type1_a_txt.c4     same_type1_a_txt.c5     same_type1_a_txt.c6     same_type1_a_txt.b
1174 PREHOOK: query: explain vectorization detail
1175 select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1176 PREHOOK: type: QUERY
1177 POSTHOOK: query: explain vectorization detail
1178 select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1179 POSTHOOK: type: QUERY
1180 Explain
1181 PLAN VECTORIZATION:
1182   enabled: true
1183   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
1184
1185 STAGE DEPENDENCIES:
1186   Stage-1 is a root stage
1187   Stage-0 depends on stages: Stage-1
1188
1189 STAGE PLANS:
1190   Stage: Stage-1
1191     Tez
1192 #### A masked pattern was here ####
1193       Vertices:
1194         Map 1 
1195             Map Operator Tree:
1196                 TableScan
1197                   alias: part_change_same_type_different_params
1198                   Statistics: Num rows: 5 Data size: 3595 Basic stats: COMPLETE Column stats: COMPLETE
1199                   TableScan Vectorization:
1200                       native: true
1201                       vectorizationSchemaColumns: [0:insert_num:int, 1:c1:char(12), 2:c2:char(25), 3:c3:varchar(25), 4:c4:varchar(10), 5:c5:decimal(12,4), 6:c6:decimal(20,10), 7:b:string, 8:part:int, 9:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
1202                   Select Operator
1203                     expressions: insert_num (type: int), part (type: int), c1 (type: char(12)), c2 (type: char(25)), c3 (type: varchar(25)), c4 (type: varchar(10)), c5 (type: decimal(12,4)), c6 (type: decimal(20,10)), b (type: string)
1204                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
1205                     Select Vectorization:
1206                         className: VectorSelectOperator
1207                         native: true
1208                         projectedOutputColumnNums: [0, 8, 1, 2, 3, 4, 5, 6, 7]
1209                     Statistics: Num rows: 5 Data size: 3595 Basic stats: COMPLETE Column stats: COMPLETE
1210                     File Output Operator
1211                       compressed: false
1212                       File Sink Vectorization:
1213                           className: VectorFileSinkOperator
1214                           native: false
1215                       Statistics: Num rows: 5 Data size: 3595 Basic stats: COMPLETE Column stats: COMPLETE
1216                       table:
1217                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
1218                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
1219                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1220             Execution mode: vectorized, llap
1221             LLAP IO: no inputs
1222             Map Vectorization:
1223                 enabled: true
1224                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
1225                 inputFormatFeatureSupport: [DECIMAL_64]
1226                 vectorizationSupportRemovedReasons: [DECIMAL_64 disabled because LLAP is enabled]
1227                 featureSupportInUse: []
1228                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
1229                 allNative: false
1230                 usesVectorUDFAdaptor: false
1231                 vectorized: true
1232                 rowBatchContext:
1233                     dataColumnCount: 8
1234                     includeColumns: [0, 1, 2, 3, 4, 5, 6, 7]
1235                     dataColumns: insert_num:int, c1:char(12), c2:char(25), c3:varchar(25), c4:varchar(10), c5:decimal(12,4), c6:decimal(20,10), b:string
1236                     partitionColumnCount: 1
1237                     partitionColumns: part:int
1238                     scratchColumnTypeNames: []
1239
1240   Stage: Stage-0
1241     Fetch Operator
1242       limit: -1
1243       Processor Tree:
1244         ListSink
1245
1246 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1247 PREHOOK: type: QUERY
1248 PREHOOK: Input: default@part_change_same_type_different_params
1249 PREHOOK: Input: default@part_change_same_type_different_params@part=1
1250 #### A masked pattern was here ####
1251 POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1252 POSTHOOK: type: QUERY
1253 POSTHOOK: Input: default@part_change_same_type_different_params
1254 POSTHOOK: Input: default@part_change_same_type_different_params@part=1
1255 #### A masked pattern was here ####
1256 insert_num      part    c1      c2      c3      c4      c5      c6      b
1257 1       1       excess          corporation believable          gateway         thumb repe      76855494.3900   NULL    original
1258 2       1       mutation        hideout authentic               blankness sonic disfigure       hover know      42093605.0000   3182652.4066800000      original
1259 3       1       hibernation     country detox coyotes           ball pulse candle       direct  1413570.3000    8.3095808155    original
1260 4       1       aquarium        encounter existent amuse        fuse light headlock     bumper adm      5475414.6500    25937.6752563004        original
1261 5       1       123456789012    1234567890123456789012345       1234567890123456789012345       1234567890      12345678.1234   1234567890.0987654321   original
1262 PREHOOK: query: alter table part_change_same_type_different_params replace columns (insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING)
1263 PREHOOK: type: ALTERTABLE_REPLACECOLS
1264 PREHOOK: Input: default@part_change_same_type_different_params
1265 PREHOOK: Output: default@part_change_same_type_different_params
1266 POSTHOOK: query: alter table part_change_same_type_different_params replace columns (insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING)
1267 POSTHOOK: type: ALTERTABLE_REPLACECOLS
1268 POSTHOOK: Input: default@part_change_same_type_different_params
1269 POSTHOOK: Output: default@part_change_same_type_different_params
1270 PREHOOK: query: CREATE TABLE same_type1_b_txt(insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING)
1271 row format delimited fields terminated by '|'
1272 stored as textfile
1273 PREHOOK: type: CREATETABLE
1274 PREHOOK: Output: database:default
1275 PREHOOK: Output: default@same_type1_b_txt
1276 POSTHOOK: query: CREATE TABLE same_type1_b_txt(insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING)
1277 row format delimited fields terminated by '|'
1278 stored as textfile
1279 POSTHOOK: type: CREATETABLE
1280 POSTHOOK: Output: database:default
1281 POSTHOOK: Output: default@same_type1_b_txt
1282 PREHOOK: query: load data local inpath '../../data/files/schema_evolution/same_type1_b.txt' overwrite into table same_type1_b_txt
1283 PREHOOK: type: LOAD
1284 #### A masked pattern was here ####
1285 PREHOOK: Output: default@same_type1_b_txt
1286 POSTHOOK: query: load data local inpath '../../data/files/schema_evolution/same_type1_b.txt' overwrite into table same_type1_b_txt
1287 POSTHOOK: type: LOAD
1288 #### A masked pattern was here ####
1289 POSTHOOK: Output: default@same_type1_b_txt
1290 PREHOOK: query: insert into table part_change_same_type_different_params partition(part=1) select * from same_type1_b_txt
1291 PREHOOK: type: QUERY
1292 PREHOOK: Input: default@same_type1_b_txt
1293 PREHOOK: Output: default@part_change_same_type_different_params@part=1
1294 POSTHOOK: query: insert into table part_change_same_type_different_params partition(part=1) select * from same_type1_b_txt
1295 POSTHOOK: type: QUERY
1296 POSTHOOK: Input: default@same_type1_b_txt
1297 POSTHOOK: Output: default@part_change_same_type_different_params@part=1
1298 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).b SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:b, type:string, comment:null), ]
1299 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c1 SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:c1, type:char(8), comment:null), ]
1300 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c2 SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:c2, type:char(32), comment:null), ]
1301 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c3 SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:c3, type:varchar(15), comment:null), ]
1302 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c4 SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:c4, type:varchar(18), comment:null), ]
1303 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c5 SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:c5, type:decimal(10,2), comment:null), ]
1304 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).c6 SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:c6, type:decimal(25,15), comment:null), ]
1305 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=1).insert_num SIMPLE [(same_type1_b_txt)same_type1_b_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
1306 same_type1_b_txt.insert_num     same_type1_b_txt.c1     same_type1_b_txt.c2     same_type1_b_txt.c3     same_type1_b_txt.c4     same_type1_b_txt.c5     same_type1_b_txt.c6     same_type1_b_txt.b
1307 PREHOOK: query: CREATE TABLE same_type1_c_txt(insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING)
1308 row format delimited fields terminated by '|'
1309 stored as textfile
1310 PREHOOK: type: CREATETABLE
1311 PREHOOK: Output: database:default
1312 PREHOOK: Output: default@same_type1_c_txt
1313 POSTHOOK: query: CREATE TABLE same_type1_c_txt(insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING)
1314 row format delimited fields terminated by '|'
1315 stored as textfile
1316 POSTHOOK: type: CREATETABLE
1317 POSTHOOK: Output: database:default
1318 POSTHOOK: Output: default@same_type1_c_txt
1319 PREHOOK: query: load data local inpath '../../data/files/schema_evolution/same_type1_c.txt' overwrite into table same_type1_c_txt
1320 PREHOOK: type: LOAD
1321 #### A masked pattern was here ####
1322 PREHOOK: Output: default@same_type1_c_txt
1323 POSTHOOK: query: load data local inpath '../../data/files/schema_evolution/same_type1_c.txt' overwrite into table same_type1_c_txt
1324 POSTHOOK: type: LOAD
1325 #### A masked pattern was here ####
1326 POSTHOOK: Output: default@same_type1_c_txt
1327 PREHOOK: query: insert into table part_change_same_type_different_params partition(part=2) select * from same_type1_c_txt
1328 PREHOOK: type: QUERY
1329 PREHOOK: Input: default@same_type1_c_txt
1330 PREHOOK: Output: default@part_change_same_type_different_params@part=2
1331 POSTHOOK: query: insert into table part_change_same_type_different_params partition(part=2) select * from same_type1_c_txt
1332 POSTHOOK: type: QUERY
1333 POSTHOOK: Input: default@same_type1_c_txt
1334 POSTHOOK: Output: default@part_change_same_type_different_params@part=2
1335 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).b SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:b, type:string, comment:null), ]
1336 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c1 SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:c1, type:char(8), comment:null), ]
1337 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c2 SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:c2, type:char(32), comment:null), ]
1338 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c3 SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:c3, type:varchar(15), comment:null), ]
1339 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c4 SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:c4, type:varchar(18), comment:null), ]
1340 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c5 SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:c5, type:decimal(10,2), comment:null), ]
1341 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).c6 SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:c6, type:decimal(25,15), comment:null), ]
1342 POSTHOOK: Lineage: part_change_same_type_different_params PARTITION(part=2).insert_num SIMPLE [(same_type1_c_txt)same_type1_c_txt.FieldSchema(name:insert_num, type:int, comment:null), ]
1343 same_type1_c_txt.insert_num     same_type1_c_txt.c1     same_type1_c_txt.c2     same_type1_c_txt.c3     same_type1_c_txt.c4     same_type1_c_txt.c5     same_type1_c_txt.c6     same_type1_c_txt.b
1344 PREHOOK: query: explain vectorization detail
1345 select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1346 PREHOOK: type: QUERY
1347 POSTHOOK: query: explain vectorization detail
1348 select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1349 POSTHOOK: type: QUERY
1350 Explain
1351 PLAN VECTORIZATION:
1352   enabled: true
1353   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
1354
1355 STAGE DEPENDENCIES:
1356   Stage-1 is a root stage
1357   Stage-0 depends on stages: Stage-1
1358
1359 STAGE PLANS:
1360   Stage: Stage-1
1361     Tez
1362 #### A masked pattern was here ####
1363       Vertices:
1364         Map 1 
1365             Map Operator Tree:
1366                 TableScan
1367                   alias: part_change_same_type_different_params
1368                   Statistics: Num rows: 13 Data size: 9347 Basic stats: COMPLETE Column stats: PARTIAL
1369                   Select Operator
1370                     expressions: insert_num (type: int), part (type: int), c1 (type: char(8)), c2 (type: char(32)), c3 (type: varchar(15)), c4 (type: varchar(18)), c5 (type: decimal(10,2)), c6 (type: decimal(25,15)), b (type: string)
1371                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
1372                     Statistics: Num rows: 13 Data size: 9347 Basic stats: COMPLETE Column stats: PARTIAL
1373                     File Output Operator
1374                       compressed: false
1375                       Statistics: Num rows: 13 Data size: 9347 Basic stats: COMPLETE Column stats: PARTIAL
1376                       table:
1377                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
1378                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
1379                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1380             Execution mode: llap
1381             LLAP IO: no inputs
1382             Map Vectorization:
1383                 enabled: false
1384                 enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true
1385                 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
1386                 inputFileFormats: org.apache.hadoop.mapred.TextInputFormat
1387
1388   Stage: Stage-0
1389     Fetch Operator
1390       limit: -1
1391       Processor Tree:
1392         ListSink
1393
1394 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1395 PREHOOK: type: QUERY
1396 PREHOOK: Input: default@part_change_same_type_different_params
1397 PREHOOK: Input: default@part_change_same_type_different_params@part=1
1398 PREHOOK: Input: default@part_change_same_type_different_params@part=2
1399 #### A masked pattern was here ####
1400 POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params
1401 POSTHOOK: type: QUERY
1402 POSTHOOK: Input: default@part_change_same_type_different_params
1403 POSTHOOK: Input: default@part_change_same_type_different_params@part=1
1404 POSTHOOK: Input: default@part_change_same_type_different_params@part=2
1405 #### A masked pattern was here ####
1406 insert_num      part    c1      c2      c3      c4      c5      c6      b
1407 1       1       excess          corporation believable                  gateway         thumb repe      76855494.39     NULL    original
1408 10      2       dreamlan        raster  devastation                     association boa lubricant century       5830.99 NULL    new
1409 11      2       tiger           however center                          propeller agoni shocking misshapen      6946533.80      31608910.030000000000000        new
1410 12      2         bulgin        extensive  ambivalent                   rastled billion zeroes  943084.30       3090297719.717120349328271      new
1411 13      2       12345678        12345678901234567890123456789012        123456789012345 123456789012345678      NULL    1234567890.543210987654321      new
1412 2       1       mutation        hideout authentic                       blankness sonic hover know      42093605.00     3182652.406680000000000 original
1413 3       1       hibernat        country detox coyotes                   ball pulse cand direct  1413570.30      8.309580815500000       original
1414 4       1       aquarium        encounter existent amuse                fuse light head bumper adm      5475414.65      25937.675256300400000   original
1415 5       1       12345678        1234567890123456789012345               123456789012345 1234567890      12345678.12     1234567890.098765432100000      original
1416 6       1       hollow          innocent crabs blushing                 ambition ebony  liquor age      NULL    3841833197.314137090000000      new
1417 7       1       wig feel        social fork drum                        search bump     conclusion      8.31    NULL    new
1418 8       1       bubble f        drain loyal station                     racket  antique bu      0.69    22.832613278700000      new
1419 9       1       12345678        1234567890123456789012345               123456789012345 1234567890      NULL    1234567890.543210987700000      new
1420 PREHOOK: query: drop table part_change_same_type_different_params
1421 PREHOOK: type: DROPTABLE
1422 PREHOOK: Input: default@part_change_same_type_different_params
1423 PREHOOK: Output: default@part_change_same_type_different_params
1424 POSTHOOK: query: drop table part_change_same_type_different_params
1425 POSTHOOK: type: DROPTABLE
1426 POSTHOOK: Input: default@part_change_same_type_different_params
1427 POSTHOOK: Output: default@part_change_same_type_different_params