HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / spark / vectorized_timestamp_funcs.q.out
1 PREHOOK: query: CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC
2 PREHOOK: type: CREATETABLE
3 PREHOOK: Output: database:default
4 PREHOOK: Output: default@alltypesorc_string
5 POSTHOOK: query: CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC
6 POSTHOOK: type: CREATETABLE
7 POSTHOOK: Output: database:default
8 POSTHOOK: Output: default@alltypesorc_string
9 PREHOOK: query: INSERT OVERWRITE TABLE alltypesorc_string
10 SELECT
11   to_utc_timestamp(ctimestamp1, 'America/Los_Angeles') AS toutc,
12   CAST(to_utc_timestamp(ctimestamp1, 'America/Los_Angeles') AS STRING) as cst
13 FROM alltypesorc
14 ORDER BY toutc, cst
15 LIMIT 40
16 PREHOOK: type: QUERY
17 PREHOOK: Input: default@alltypesorc
18 PREHOOK: Output: default@alltypesorc_string
19 POSTHOOK: query: INSERT OVERWRITE TABLE alltypesorc_string
20 SELECT
21   to_utc_timestamp(ctimestamp1, 'America/Los_Angeles') AS toutc,
22   CAST(to_utc_timestamp(ctimestamp1, 'America/Los_Angeles') AS STRING) as cst
23 FROM alltypesorc
24 ORDER BY toutc, cst
25 LIMIT 40
26 POSTHOOK: type: QUERY
27 POSTHOOK: Input: default@alltypesorc
28 POSTHOOK: Output: default@alltypesorc_string
29 POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
30 POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
31 PREHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC
32 PREHOOK: type: CREATETABLE
33 PREHOOK: Output: database:default
34 PREHOOK: Output: default@alltypesorc_wrong
35 POSTHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC
36 POSTHOOK: type: CREATETABLE
37 POSTHOOK: Output: database:default
38 POSTHOOK: Output: default@alltypesorc_wrong
39 PREHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT 'abcd' FROM alltypesorc LIMIT 1
40 PREHOOK: type: QUERY
41 PREHOOK: Input: default@alltypesorc
42 PREHOOK: Output: default@alltypesorc_wrong
43 POSTHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT 'abcd' FROM alltypesorc LIMIT 1
44 POSTHOOK: type: QUERY
45 POSTHOOK: Input: default@alltypesorc
46 POSTHOOK: Output: default@alltypesorc_wrong
47 POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
48 PREHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '2000:01:01 00-00-00' FROM alltypesorc LIMIT 1
49 PREHOOK: type: QUERY
50 PREHOOK: Input: default@alltypesorc
51 PREHOOK: Output: default@alltypesorc_wrong
52 POSTHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '2000:01:01 00-00-00' FROM alltypesorc LIMIT 1
53 POSTHOOK: type: QUERY
54 POSTHOOK: Input: default@alltypesorc
55 POSTHOOK: Output: default@alltypesorc_wrong
56 POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
57 PREHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '0000-00-00 99:99:99' FROM alltypesorc LIMIT 1
58 PREHOOK: type: QUERY
59 PREHOOK: Input: default@alltypesorc
60 PREHOOK: Output: default@alltypesorc_wrong
61 POSTHOOK: query: INSERT INTO TABLE alltypesorc_wrong SELECT '0000-00-00 99:99:99' FROM alltypesorc LIMIT 1
62 POSTHOOK: type: QUERY
63 POSTHOOK: Input: default@alltypesorc
64 POSTHOOK: Output: default@alltypesorc_wrong
65 POSTHOOK: Lineage: alltypesorc_wrong.stimestamp1 SIMPLE []
66 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
67   to_unix_timestamp(ctimestamp1) AS c1,
68   year(ctimestamp1),
69   month(ctimestamp1),
70   day(ctimestamp1),
71   dayofmonth(ctimestamp1),
72   weekofyear(ctimestamp1),
73   hour(ctimestamp1),
74   minute(ctimestamp1),
75   second(ctimestamp1)
76 FROM alltypesorc_string
77 ORDER BY c1
78 PREHOOK: type: QUERY
79 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
80   to_unix_timestamp(ctimestamp1) AS c1,
81   year(ctimestamp1),
82   month(ctimestamp1),
83   day(ctimestamp1),
84   dayofmonth(ctimestamp1),
85   weekofyear(ctimestamp1),
86   hour(ctimestamp1),
87   minute(ctimestamp1),
88   second(ctimestamp1)
89 FROM alltypesorc_string
90 ORDER BY c1
91 POSTHOOK: type: QUERY
92 PLAN VECTORIZATION:
93   enabled: true
94   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
95
96 STAGE DEPENDENCIES:
97   Stage-1 is a root stage
98   Stage-0 depends on stages: Stage-1
99
100 STAGE PLANS:
101   Stage: Stage-1
102     Spark
103       Edges:
104         Reducer 2 <- Map 1 (SORT, 1)
105 #### A masked pattern was here ####
106       Vertices:
107         Map 1 
108             Map Operator Tree:
109                 TableScan
110                   alias: alltypesorc_string
111                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
112                   TableScan Vectorization:
113                       native: true
114                   Select Operator
115                     expressions: to_unix_timestamp(ctimestamp1) (type: bigint), year(ctimestamp1) (type: int), month(ctimestamp1) (type: int), day(ctimestamp1) (type: int), dayofmonth(ctimestamp1) (type: int), weekofyear(ctimestamp1) (type: int), hour(ctimestamp1) (type: int), minute(ctimestamp1) (type: int), second(ctimestamp1) (type: int)
116                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
117                     Select Vectorization:
118                         className: VectorSelectOperator
119                         native: true
120                         projectedOutputColumnNums: [3, 4, 5, 6, 7, 8, 9, 10, 11]
121                         selectExpressions: VectorUDFUnixTimeStampTimestamp(col 0:timestamp) -> 3:bigint, VectorUDFYearTimestamp(col 0:timestamp, field YEAR) -> 4:int, VectorUDFMonthTimestamp(col 0:timestamp, field MONTH) -> 5:int, VectorUDFDayOfMonthTimestamp(col 0:timestamp, field DAY_OF_MONTH) -> 6:int, VectorUDFDayOfMonthTimestamp(col 0:timestamp, field DAY_OF_MONTH) -> 7:int, VectorUDFWeekOfYearTimestamp(col 0:timestamp, field WEEK_OF_YEAR) -> 8:int, VectorUDFHourTimestamp(col 0:timestamp, field HOUR_OF_DAY) -> 9:int, VectorUDFMinuteTimestamp(col 0:timestamp, field MINUTE) -> 10:int, VectorUDFSecondTimestamp(col 0:timestamp, field SECOND) -> 11:int
122                     Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
123                     Reduce Output Operator
124                       key expressions: _col0 (type: bigint)
125                       sort order: +
126                       Reduce Sink Vectorization:
127                           className: VectorReduceSinkObjectHashOperator
128                           native: true
129                           nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
130                       Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
131                       value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
132             Execution mode: vectorized
133             Map Vectorization:
134                 enabled: true
135                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
136                 inputFormatFeatureSupport: []
137                 featureSupportInUse: []
138                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
139                 allNative: true
140                 usesVectorUDFAdaptor: false
141                 vectorized: true
142         Reducer 2 
143             Execution mode: vectorized
144             Reduce Vectorization:
145                 enabled: true
146                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
147                 allNative: false
148                 usesVectorUDFAdaptor: false
149                 vectorized: true
150             Reduce Operator Tree:
151               Select Operator
152                 expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
153                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
154                 Select Vectorization:
155                     className: VectorSelectOperator
156                     native: true
157                     projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8]
158                 Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
159                 File Output Operator
160                   compressed: false
161                   File Sink Vectorization:
162                       className: VectorFileSinkOperator
163                       native: false
164                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
165                   table:
166                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
167                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
168                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
169
170   Stage: Stage-0
171     Fetch Operator
172       limit: -1
173       Processor Tree:
174         ListSink
175
176 PREHOOK: query: SELECT
177   to_unix_timestamp(ctimestamp1) AS c1,
178   year(ctimestamp1),
179   month(ctimestamp1),
180   day(ctimestamp1),
181   dayofmonth(ctimestamp1),
182   weekofyear(ctimestamp1),
183   hour(ctimestamp1),
184   minute(ctimestamp1),
185   second(ctimestamp1)
186 FROM alltypesorc_string
187 ORDER BY c1
188 PREHOOK: type: QUERY
189 PREHOOK: Input: default@alltypesorc_string
190 #### A masked pattern was here ####
191 POSTHOOK: query: SELECT
192   to_unix_timestamp(ctimestamp1) AS c1,
193   year(ctimestamp1),
194   month(ctimestamp1),
195   day(ctimestamp1),
196   dayofmonth(ctimestamp1),
197   weekofyear(ctimestamp1),
198   hour(ctimestamp1),
199   minute(ctimestamp1),
200   second(ctimestamp1)
201 FROM alltypesorc_string
202 ORDER BY c1
203 POSTHOOK: type: QUERY
204 POSTHOOK: Input: default@alltypesorc_string
205 #### A masked pattern was here ####
206 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
207 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
208 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
209 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
210 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
211 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
212 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
213 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
214 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
215 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
216 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
217 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
218 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
219 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
220 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
221 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
222 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
223 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
224 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
225 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
226 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
227 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
228 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
229 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
230 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
231 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
232 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
233 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
234 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
235 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
236 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
237 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
238 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
239 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
240 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
241 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
242 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
243 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
244 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
245 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
246 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
247   to_unix_timestamp(stimestamp1) AS c1,
248   year(stimestamp1),
249   month(stimestamp1),
250   day(stimestamp1),
251   dayofmonth(stimestamp1),
252   weekofyear(stimestamp1),
253   hour(stimestamp1),
254   minute(stimestamp1),
255   second(stimestamp1)
256 FROM alltypesorc_string
257 ORDER BY c1
258 PREHOOK: type: QUERY
259 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
260   to_unix_timestamp(stimestamp1) AS c1,
261   year(stimestamp1),
262   month(stimestamp1),
263   day(stimestamp1),
264   dayofmonth(stimestamp1),
265   weekofyear(stimestamp1),
266   hour(stimestamp1),
267   minute(stimestamp1),
268   second(stimestamp1)
269 FROM alltypesorc_string
270 ORDER BY c1
271 POSTHOOK: type: QUERY
272 PLAN VECTORIZATION:
273   enabled: true
274   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
275
276 STAGE DEPENDENCIES:
277   Stage-1 is a root stage
278   Stage-0 depends on stages: Stage-1
279
280 STAGE PLANS:
281   Stage: Stage-1
282     Spark
283       Edges:
284         Reducer 2 <- Map 1 (SORT, 1)
285 #### A masked pattern was here ####
286       Vertices:
287         Map 1 
288             Map Operator Tree:
289                 TableScan
290                   alias: alltypesorc_string
291                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
292                   TableScan Vectorization:
293                       native: true
294                   Select Operator
295                     expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int)
296                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
297                     Select Vectorization:
298                         className: VectorSelectOperator
299                         native: true
300                         projectedOutputColumnNums: [3, 4, 5, 6, 7, 8, 9, 10, 11]
301                         selectExpressions: VectorUDFUnixTimeStampString(col 1:string) -> 3:bigint, VectorUDFYearString(col 1:string, fieldStart 0, fieldLength 4) -> 4:int, VectorUDFMonthString(col 1:string, fieldStart 5, fieldLength 2) -> 5:int, VectorUDFDayOfMonthString(col 1:string, fieldStart 8, fieldLength 2) -> 6:int, VectorUDFDayOfMonthString(col 1:string, fieldStart 8, fieldLength 2) -> 7:int, VectorUDFWeekOfYearString(col 1:string) -> 8:int, VectorUDFHourString(col 1:string, fieldStart 11, fieldLength 2) -> 9:int, VectorUDFMinuteString(col 1:string, fieldStart 14, fieldLength 2) -> 10:int, VectorUDFSecondString(col 1:string, fieldStart 17, fieldLength 2) -> 11:int
302                     Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
303                     Reduce Output Operator
304                       key expressions: _col0 (type: bigint)
305                       sort order: +
306                       Reduce Sink Vectorization:
307                           className: VectorReduceSinkObjectHashOperator
308                           native: true
309                           nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
310                       Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
311                       value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
312             Execution mode: vectorized
313             Map Vectorization:
314                 enabled: true
315                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
316                 inputFormatFeatureSupport: []
317                 featureSupportInUse: []
318                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
319                 allNative: true
320                 usesVectorUDFAdaptor: false
321                 vectorized: true
322         Reducer 2 
323             Execution mode: vectorized
324             Reduce Vectorization:
325                 enabled: true
326                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
327                 allNative: false
328                 usesVectorUDFAdaptor: false
329                 vectorized: true
330             Reduce Operator Tree:
331               Select Operator
332                 expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
333                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
334                 Select Vectorization:
335                     className: VectorSelectOperator
336                     native: true
337                     projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8]
338                 Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
339                 File Output Operator
340                   compressed: false
341                   File Sink Vectorization:
342                       className: VectorFileSinkOperator
343                       native: false
344                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
345                   table:
346                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
347                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
348                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
349
350   Stage: Stage-0
351     Fetch Operator
352       limit: -1
353       Processor Tree:
354         ListSink
355
356 PREHOOK: query: SELECT
357   to_unix_timestamp(stimestamp1) AS c1,
358   year(stimestamp1),
359   month(stimestamp1),
360   day(stimestamp1),
361   dayofmonth(stimestamp1),
362   weekofyear(stimestamp1),
363   hour(stimestamp1),
364   minute(stimestamp1),
365   second(stimestamp1)
366 FROM alltypesorc_string
367 ORDER BY c1
368 PREHOOK: type: QUERY
369 PREHOOK: Input: default@alltypesorc_string
370 #### A masked pattern was here ####
371 POSTHOOK: query: SELECT
372   to_unix_timestamp(stimestamp1) AS c1,
373   year(stimestamp1),
374   month(stimestamp1),
375   day(stimestamp1),
376   dayofmonth(stimestamp1),
377   weekofyear(stimestamp1),
378   hour(stimestamp1),
379   minute(stimestamp1),
380   second(stimestamp1)
381 FROM alltypesorc_string
382 ORDER BY c1
383 POSTHOOK: type: QUERY
384 POSTHOOK: Input: default@alltypesorc_string
385 #### A masked pattern was here ####
386 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
387 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
388 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
389 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
390 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
391 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
392 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
393 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
394 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
395 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
396 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
397 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
398 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
399 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
400 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
401 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
402 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
403 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
404 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
405 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
406 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
407 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
408 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
409 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
410 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
411 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
412 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
413 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
414 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
415 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
416 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
417 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
418 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
419 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
420 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
421 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
422 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
423 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
424 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
425 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
426 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
427   to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
428   year(ctimestamp1) = year(stimestamp1),
429   month(ctimestamp1) = month(stimestamp1),
430   day(ctimestamp1) = day(stimestamp1),
431   dayofmonth(ctimestamp1) = dayofmonth(stimestamp1),
432   weekofyear(ctimestamp1) = weekofyear(stimestamp1),
433   hour(ctimestamp1) = hour(stimestamp1),
434   minute(ctimestamp1) = minute(stimestamp1),
435   second(ctimestamp1) = second(stimestamp1)
436 FROM alltypesorc_string
437 ORDER BY c1
438 PREHOOK: type: QUERY
439 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
440   to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
441   year(ctimestamp1) = year(stimestamp1),
442   month(ctimestamp1) = month(stimestamp1),
443   day(ctimestamp1) = day(stimestamp1),
444   dayofmonth(ctimestamp1) = dayofmonth(stimestamp1),
445   weekofyear(ctimestamp1) = weekofyear(stimestamp1),
446   hour(ctimestamp1) = hour(stimestamp1),
447   minute(ctimestamp1) = minute(stimestamp1),
448   second(ctimestamp1) = second(stimestamp1)
449 FROM alltypesorc_string
450 ORDER BY c1
451 POSTHOOK: type: QUERY
452 PLAN VECTORIZATION:
453   enabled: true
454   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
455
456 STAGE DEPENDENCIES:
457   Stage-1 is a root stage
458   Stage-0 depends on stages: Stage-1
459
460 STAGE PLANS:
461   Stage: Stage-1
462     Spark
463       Edges:
464         Reducer 2 <- Map 1 (SORT, 1)
465 #### A masked pattern was here ####
466       Vertices:
467         Map 1 
468             Map Operator Tree:
469                 TableScan
470                   alias: alltypesorc_string
471                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
472                   TableScan Vectorization:
473                       native: true
474                   Select Operator
475                     expressions: (to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1)) (type: boolean), (year(ctimestamp1) = year(stimestamp1)) (type: boolean), (month(ctimestamp1) = month(stimestamp1)) (type: boolean), (day(ctimestamp1) = day(stimestamp1)) (type: boolean), (dayofmonth(ctimestamp1) = dayofmonth(stimestamp1)) (type: boolean), (weekofyear(ctimestamp1) = weekofyear(stimestamp1)) (type: boolean), (hour(ctimestamp1) = hour(stimestamp1)) (type: boolean), (minute(ctimestamp1) = minute(stimestamp1)) (type: boolean), (second(ctimestamp1) = second(stimestamp1)) (type: boolean)
476                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
477                     Select Vectorization:
478                         className: VectorSelectOperator
479                         native: true
480                         projectedOutputColumnNums: [5, 6, 7, 8, 9, 10, 11, 12, 13]
481                         selectExpressions: LongColEqualLongColumn(col 3:bigint, col 4:bigint)(children: VectorUDFUnixTimeStampTimestamp(col 0:timestamp) -> 3:bigint, VectorUDFUnixTimeStampString(col 1:string) -> 4:bigint) -> 5:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFYearTimestamp(col 0:timestamp, field YEAR) -> 3:int, VectorUDFYearString(col 1:string, fieldStart 0, fieldLength 4) -> 4:int) -> 6:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFMonthTimestamp(col 0:timestamp, field MONTH) -> 3:int, VectorUDFMonthString(col 1:string, fieldStart 5, fieldLength 2) -> 4:int) -> 7:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFDayOfMonthTimestamp(col 0:timestamp, field DAY_OF_MONTH) -> 3:int, VectorUDFDayOfMonthString(col 1:string, fieldStart 8, fieldLength 2) -> 4:int) -> 8:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFDayOfMonthTimestamp(col 0:timestamp, field DAY_OF_MONTH) -> 3:int, VectorUDFDayOfMonthString(col 1:string, fieldStart 8, fieldLength 2) -> 4:int) -> 9:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFWeekOfYearTimestamp(col 0:timestamp, field WEEK_OF_YEAR) -> 3:int, VectorUDFWeekOfYearString(col 1:string) -> 4:int) -> 10:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFHourTimestamp(col 0:timestamp, field HOUR_OF_DAY) -> 3:int, VectorUDFHourString(col 1:string, fieldStart 11, fieldLength 2) -> 4:int) -> 11:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFMinuteTimestamp(col 0:timestamp, field MINUTE) -> 3:int, VectorUDFMinuteString(col 1:string, fieldStart 14, fieldLength 2) -> 4:int) -> 12:boolean, LongColEqualLongColumn(col 3:int, col 4:int)(children: VectorUDFSecondTimestamp(col 0:timestamp, field SECOND) -> 3:int, VectorUDFSecondString(col 1:string, fieldStart 17, fieldLength 2) -> 4:int) -> 13:boolean
482                     Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
483                     Reduce Output Operator
484                       key expressions: _col0 (type: boolean)
485                       sort order: +
486                       Reduce Sink Vectorization:
487                           className: VectorReduceSinkObjectHashOperator
488                           native: true
489                           nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
490                       Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
491                       value expressions: _col1 (type: boolean), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean)
492             Execution mode: vectorized
493             Map Vectorization:
494                 enabled: true
495                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
496                 inputFormatFeatureSupport: []
497                 featureSupportInUse: []
498                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
499                 allNative: true
500                 usesVectorUDFAdaptor: false
501                 vectorized: true
502         Reducer 2 
503             Execution mode: vectorized
504             Reduce Vectorization:
505                 enabled: true
506                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
507                 allNative: false
508                 usesVectorUDFAdaptor: false
509                 vectorized: true
510             Reduce Operator Tree:
511               Select Operator
512                 expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: boolean), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean)
513                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
514                 Select Vectorization:
515                     className: VectorSelectOperator
516                     native: true
517                     projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8]
518                 Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
519                 File Output Operator
520                   compressed: false
521                   File Sink Vectorization:
522                       className: VectorFileSinkOperator
523                       native: false
524                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
525                   table:
526                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
527                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
528                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
529
530   Stage: Stage-0
531     Fetch Operator
532       limit: -1
533       Processor Tree:
534         ListSink
535
536 PREHOOK: query: SELECT
537   to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
538   year(ctimestamp1) = year(stimestamp1),
539   month(ctimestamp1) = month(stimestamp1),
540   day(ctimestamp1) = day(stimestamp1),
541   dayofmonth(ctimestamp1) = dayofmonth(stimestamp1),
542   weekofyear(ctimestamp1) = weekofyear(stimestamp1),
543   hour(ctimestamp1) = hour(stimestamp1),
544   minute(ctimestamp1) = minute(stimestamp1),
545   second(ctimestamp1) = second(stimestamp1)
546 FROM alltypesorc_string
547 ORDER BY c1
548 PREHOOK: type: QUERY
549 PREHOOK: Input: default@alltypesorc_string
550 #### A masked pattern was here ####
551 POSTHOOK: query: SELECT
552   to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1,
553   year(ctimestamp1) = year(stimestamp1),
554   month(ctimestamp1) = month(stimestamp1),
555   day(ctimestamp1) = day(stimestamp1),
556   dayofmonth(ctimestamp1) = dayofmonth(stimestamp1),
557   weekofyear(ctimestamp1) = weekofyear(stimestamp1),
558   hour(ctimestamp1) = hour(stimestamp1),
559   minute(ctimestamp1) = minute(stimestamp1),
560   second(ctimestamp1) = second(stimestamp1)
561 FROM alltypesorc_string
562 ORDER BY c1
563 POSTHOOK: type: QUERY
564 POSTHOOK: Input: default@alltypesorc_string
565 #### A masked pattern was here ####
566 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
567 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
568 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
569 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
570 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
571 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
572 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
573 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
574 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
575 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
576 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
577 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
578 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
579 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
580 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
581 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
582 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
583 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
584 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
585 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
586 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
587 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
588 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
589 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
590 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
591 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
592 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
593 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
594 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
595 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
596 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
597 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
598 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
599 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
600 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
601 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
602 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
603 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
604 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
605 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
606 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
607   to_unix_timestamp(stimestamp1) AS c1,
608   year(stimestamp1),
609   month(stimestamp1),
610   day(stimestamp1),
611   dayofmonth(stimestamp1),
612   weekofyear(stimestamp1),
613   hour(stimestamp1),
614   minute(stimestamp1),
615   second(stimestamp1)
616 FROM alltypesorc_wrong
617 ORDER BY c1
618 PREHOOK: type: QUERY
619 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
620   to_unix_timestamp(stimestamp1) AS c1,
621   year(stimestamp1),
622   month(stimestamp1),
623   day(stimestamp1),
624   dayofmonth(stimestamp1),
625   weekofyear(stimestamp1),
626   hour(stimestamp1),
627   minute(stimestamp1),
628   second(stimestamp1)
629 FROM alltypesorc_wrong
630 ORDER BY c1
631 POSTHOOK: type: QUERY
632 PLAN VECTORIZATION:
633   enabled: true
634   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
635
636 STAGE DEPENDENCIES:
637   Stage-1 is a root stage
638   Stage-0 depends on stages: Stage-1
639
640 STAGE PLANS:
641   Stage: Stage-1
642     Spark
643       Edges:
644         Reducer 2 <- Map 1 (SORT, 1)
645 #### A masked pattern was here ####
646       Vertices:
647         Map 1 
648             Map Operator Tree:
649                 TableScan
650                   alias: alltypesorc_wrong
651                   Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: NONE
652                   TableScan Vectorization:
653                       native: true
654                   Select Operator
655                     expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int)
656                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
657                     Select Vectorization:
658                         className: VectorSelectOperator
659                         native: true
660                         projectedOutputColumnNums: [2, 3, 4, 5, 6, 7, 8, 9, 10]
661                         selectExpressions: VectorUDFUnixTimeStampString(col 0:string) -> 2:bigint, VectorUDFYearString(col 0:string, fieldStart 0, fieldLength 4) -> 3:int, VectorUDFMonthString(col 0:string, fieldStart 5, fieldLength 2) -> 4:int, VectorUDFDayOfMonthString(col 0:string, fieldStart 8, fieldLength 2) -> 5:int, VectorUDFDayOfMonthString(col 0:string, fieldStart 8, fieldLength 2) -> 6:int, VectorUDFWeekOfYearString(col 0:string) -> 7:int, VectorUDFHourString(col 0:string, fieldStart 11, fieldLength 2) -> 8:int, VectorUDFMinuteString(col 0:string, fieldStart 14, fieldLength 2) -> 9:int, VectorUDFSecondString(col 0:string, fieldStart 17, fieldLength 2) -> 10:int
662                     Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: NONE
663                     Reduce Output Operator
664                       key expressions: _col0 (type: bigint)
665                       sort order: +
666                       Reduce Sink Vectorization:
667                           className: VectorReduceSinkObjectHashOperator
668                           native: true
669                           nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
670                       Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: NONE
671                       value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
672             Execution mode: vectorized
673             Map Vectorization:
674                 enabled: true
675                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
676                 inputFormatFeatureSupport: []
677                 featureSupportInUse: []
678                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
679                 allNative: true
680                 usesVectorUDFAdaptor: false
681                 vectorized: true
682         Reducer 2 
683             Execution mode: vectorized
684             Reduce Vectorization:
685                 enabled: true
686                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
687                 allNative: false
688                 usesVectorUDFAdaptor: false
689                 vectorized: true
690             Reduce Operator Tree:
691               Select Operator
692                 expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
693                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
694                 Select Vectorization:
695                     className: VectorSelectOperator
696                     native: true
697                     projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8]
698                 Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: NONE
699                 File Output Operator
700                   compressed: false
701                   File Sink Vectorization:
702                       className: VectorFileSinkOperator
703                       native: false
704                   Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: NONE
705                   table:
706                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
707                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
708                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
709
710   Stage: Stage-0
711     Fetch Operator
712       limit: -1
713       Processor Tree:
714         ListSink
715
716 PREHOOK: query: SELECT
717   to_unix_timestamp(stimestamp1) AS c1,
718   year(stimestamp1),
719   month(stimestamp1),
720   day(stimestamp1),
721   dayofmonth(stimestamp1),
722   weekofyear(stimestamp1),
723   hour(stimestamp1),
724   minute(stimestamp1),
725   second(stimestamp1)
726 FROM alltypesorc_wrong
727 ORDER BY c1
728 PREHOOK: type: QUERY
729 PREHOOK: Input: default@alltypesorc_wrong
730 #### A masked pattern was here ####
731 POSTHOOK: query: SELECT
732   to_unix_timestamp(stimestamp1) AS c1,
733   year(stimestamp1),
734   month(stimestamp1),
735   day(stimestamp1),
736   dayofmonth(stimestamp1),
737   weekofyear(stimestamp1),
738   hour(stimestamp1),
739   minute(stimestamp1),
740   second(stimestamp1)
741 FROM alltypesorc_wrong
742 ORDER BY c1
743 POSTHOOK: type: QUERY
744 POSTHOOK: Input: default@alltypesorc_wrong
745 #### A masked pattern was here ####
746 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
747 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
748 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
749 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
750   min(ctimestamp1),
751   max(ctimestamp1),
752   count(ctimestamp1),
753   count(*)
754 FROM alltypesorc_string
755 PREHOOK: type: QUERY
756 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
757   min(ctimestamp1),
758   max(ctimestamp1),
759   count(ctimestamp1),
760   count(*)
761 FROM alltypesorc_string
762 POSTHOOK: type: QUERY
763 PLAN VECTORIZATION:
764   enabled: true
765   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
766
767 STAGE DEPENDENCIES:
768   Stage-1 is a root stage
769   Stage-0 depends on stages: Stage-1
770
771 STAGE PLANS:
772   Stage: Stage-1
773     Spark
774       Edges:
775         Reducer 2 <- Map 1 (GROUP, 1)
776 #### A masked pattern was here ####
777       Vertices:
778         Map 1 
779             Map Operator Tree:
780                 TableScan
781                   alias: alltypesorc_string
782                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
783                   TableScan Vectorization:
784                       native: true
785                   Select Operator
786                     expressions: ctimestamp1 (type: timestamp)
787                     outputColumnNames: ctimestamp1
788                     Select Vectorization:
789                         className: VectorSelectOperator
790                         native: true
791                         projectedOutputColumnNums: [0]
792                     Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
793                     Group By Operator
794                       aggregations: min(ctimestamp1), max(ctimestamp1), count(ctimestamp1), count()
795                       Group By Vectorization:
796                           aggregators: VectorUDAFMinTimestamp(col 0:timestamp) -> timestamp, VectorUDAFMaxTimestamp(col 0:timestamp) -> timestamp, VectorUDAFCount(col 0:timestamp) -> bigint, VectorUDAFCountStar(*) -> bigint
797                           className: VectorGroupByOperator
798                           groupByMode: HASH
799                           native: false
800                           vectorProcessingMode: HASH
801                           projectedOutputColumnNums: [0, 1, 2, 3]
802                       mode: hash
803                       outputColumnNames: _col0, _col1, _col2, _col3
804                       Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: NONE
805                       Reduce Output Operator
806                         sort order: 
807                         Reduce Sink Vectorization:
808                             className: VectorReduceSinkEmptyKeyOperator
809                             native: true
810                             nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
811                         Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: NONE
812                         value expressions: _col0 (type: timestamp), _col1 (type: timestamp), _col2 (type: bigint), _col3 (type: bigint)
813             Execution mode: vectorized
814             Map Vectorization:
815                 enabled: true
816                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
817                 inputFormatFeatureSupport: []
818                 featureSupportInUse: []
819                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
820                 allNative: false
821                 usesVectorUDFAdaptor: false
822                 vectorized: true
823         Reducer 2 
824             Execution mode: vectorized
825             Reduce Vectorization:
826                 enabled: true
827                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
828                 allNative: false
829                 usesVectorUDFAdaptor: false
830                 vectorized: true
831             Reduce Operator Tree:
832               Group By Operator
833                 aggregations: min(VALUE._col0), max(VALUE._col1), count(VALUE._col2), count(VALUE._col3)
834                 Group By Vectorization:
835                     aggregators: VectorUDAFMinTimestamp(col 0:timestamp) -> timestamp, VectorUDAFMaxTimestamp(col 1:timestamp) -> timestamp, VectorUDAFCountMerge(col 2:bigint) -> bigint, VectorUDAFCountMerge(col 3:bigint) -> bigint
836                     className: VectorGroupByOperator
837                     groupByMode: MERGEPARTIAL
838                     native: false
839                     vectorProcessingMode: GLOBAL
840                     projectedOutputColumnNums: [0, 1, 2, 3]
841                 mode: mergepartial
842                 outputColumnNames: _col0, _col1, _col2, _col3
843                 Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: NONE
844                 File Output Operator
845                   compressed: false
846                   File Sink Vectorization:
847                       className: VectorFileSinkOperator
848                       native: false
849                   Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: NONE
850                   table:
851                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
852                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
853                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
854
855   Stage: Stage-0
856     Fetch Operator
857       limit: -1
858       Processor Tree:
859         ListSink
860
861 PREHOOK: query: SELECT
862   min(ctimestamp1),
863   max(ctimestamp1),
864   count(ctimestamp1),
865   count(*)
866 FROM alltypesorc_string
867 PREHOOK: type: QUERY
868 PREHOOK: Input: default@alltypesorc_string
869 #### A masked pattern was here ####
870 POSTHOOK: query: SELECT
871   min(ctimestamp1),
872   max(ctimestamp1),
873   count(ctimestamp1),
874   count(*)
875 FROM alltypesorc_string
876 POSTHOOK: type: QUERY
877 POSTHOOK: Input: default@alltypesorc_string
878 #### A masked pattern was here ####
879 NULL    NULL    0       40
880 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
881   round(sum(ctimestamp1), 3)
882 FROM alltypesorc_string
883 PREHOOK: type: QUERY
884 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
885   round(sum(ctimestamp1), 3)
886 FROM alltypesorc_string
887 POSTHOOK: type: QUERY
888 PLAN VECTORIZATION:
889   enabled: true
890   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
891
892 STAGE DEPENDENCIES:
893   Stage-1 is a root stage
894   Stage-0 depends on stages: Stage-1
895
896 STAGE PLANS:
897   Stage: Stage-1
898     Spark
899       Edges:
900         Reducer 2 <- Map 1 (GROUP, 1)
901 #### A masked pattern was here ####
902       Vertices:
903         Map 1 
904             Map Operator Tree:
905                 TableScan
906                   alias: alltypesorc_string
907                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
908                   TableScan Vectorization:
909                       native: true
910                   Select Operator
911                     expressions: ctimestamp1 (type: timestamp)
912                     outputColumnNames: ctimestamp1
913                     Select Vectorization:
914                         className: VectorSelectOperator
915                         native: true
916                         projectedOutputColumnNums: [0]
917                     Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
918                     Group By Operator
919                       aggregations: sum(ctimestamp1)
920                       Group By Vectorization:
921                           aggregators: VectorUDAFSumTimestamp(col 0:timestamp) -> double
922                           className: VectorGroupByOperator
923                           groupByMode: HASH
924                           native: false
925                           vectorProcessingMode: HASH
926                           projectedOutputColumnNums: [0]
927                       mode: hash
928                       outputColumnNames: _col0
929                       Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
930                       Reduce Output Operator
931                         sort order: 
932                         Reduce Sink Vectorization:
933                             className: VectorReduceSinkEmptyKeyOperator
934                             native: true
935                             nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
936                         Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
937                         value expressions: _col0 (type: double)
938             Execution mode: vectorized
939             Map Vectorization:
940                 enabled: true
941                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
942                 inputFormatFeatureSupport: []
943                 featureSupportInUse: []
944                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
945                 allNative: false
946                 usesVectorUDFAdaptor: false
947                 vectorized: true
948         Reducer 2 
949             Execution mode: vectorized
950             Reduce Vectorization:
951                 enabled: true
952                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
953                 allNative: false
954                 usesVectorUDFAdaptor: false
955                 vectorized: true
956             Reduce Operator Tree:
957               Group By Operator
958                 aggregations: sum(VALUE._col0)
959                 Group By Vectorization:
960                     aggregators: VectorUDAFSumDouble(col 0:double) -> double
961                     className: VectorGroupByOperator
962                     groupByMode: MERGEPARTIAL
963                     native: false
964                     vectorProcessingMode: GLOBAL
965                     projectedOutputColumnNums: [0]
966                 mode: mergepartial
967                 outputColumnNames: _col0
968                 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
969                 Select Operator
970                   expressions: round(_col0, 3) (type: double)
971                   outputColumnNames: _col0
972                   Select Vectorization:
973                       className: VectorSelectOperator
974                       native: true
975                       projectedOutputColumnNums: [1]
976                       selectExpressions: RoundWithNumDigitsDoubleToDouble(col 0, decimalPlaces 3) -> 1:double
977                   Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
978                   File Output Operator
979                     compressed: false
980                     File Sink Vectorization:
981                         className: VectorFileSinkOperator
982                         native: false
983                     Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
984                     table:
985                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
986                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
987                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
988
989   Stage: Stage-0
990     Fetch Operator
991       limit: -1
992       Processor Tree:
993         ListSink
994
995 PREHOOK: query: SELECT
996  round(sum(ctimestamp1), 3)
997 FROM alltypesorc_string
998 PREHOOK: type: QUERY
999 PREHOOK: Input: default@alltypesorc_string
1000 #### A masked pattern was here ####
1001 POSTHOOK: query: SELECT
1002  round(sum(ctimestamp1), 3)
1003 FROM alltypesorc_string
1004 POSTHOOK: type: QUERY
1005 POSTHOOK: Input: default@alltypesorc_string
1006 #### A masked pattern was here ####
1007 NULL
1008 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
1009   round(avg(ctimestamp1), 0),
1010   variance(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1011   var_pop(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1012   var_samp(ctimestamp1) between 9.20684592523616E19 and 9.20684592523617E19,
1013   round(std(ctimestamp1), 3),
1014   round(stddev(ctimestamp1), 3),
1015   round(stddev_pop(ctimestamp1), 3),
1016   round(stddev_samp(ctimestamp1), 3)
1017 FROM alltypesorc_string
1018 PREHOOK: type: QUERY
1019 POSTHOOK: query: EXPLAIN VECTORIZATION EXPRESSION  SELECT
1020   round(avg(ctimestamp1), 0),
1021   variance(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1022   var_pop(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1023   var_samp(ctimestamp1) between 9.20684592523616E19 and 9.20684592523617E19,
1024   round(std(ctimestamp1), 3),
1025   round(stddev(ctimestamp1), 3),
1026   round(stddev_pop(ctimestamp1), 3),
1027   round(stddev_samp(ctimestamp1), 3)
1028 FROM alltypesorc_string
1029 POSTHOOK: type: QUERY
1030 PLAN VECTORIZATION:
1031   enabled: true
1032   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
1033
1034 STAGE DEPENDENCIES:
1035   Stage-1 is a root stage
1036   Stage-0 depends on stages: Stage-1
1037
1038 STAGE PLANS:
1039   Stage: Stage-1
1040     Spark
1041       Edges:
1042         Reducer 2 <- Map 1 (GROUP, 1)
1043 #### A masked pattern was here ####
1044       Vertices:
1045         Map 1 
1046             Map Operator Tree:
1047                 TableScan
1048                   alias: alltypesorc_string
1049                   Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
1050                   TableScan Vectorization:
1051                       native: true
1052                   Select Operator
1053                     expressions: ctimestamp1 (type: timestamp)
1054                     outputColumnNames: ctimestamp1
1055                     Select Vectorization:
1056                         className: VectorSelectOperator
1057                         native: true
1058                         projectedOutputColumnNums: [0]
1059                     Statistics: Num rows: 40 Data size: 84 Basic stats: COMPLETE Column stats: NONE
1060                     Group By Operator
1061                       aggregations: avg(ctimestamp1), variance(ctimestamp1), var_pop(ctimestamp1), var_samp(ctimestamp1), std(ctimestamp1), stddev(ctimestamp1), stddev_pop(ctimestamp1), stddev_samp(ctimestamp1)
1062                       Group By Vectorization:
1063                           aggregators: VectorUDAFAvgTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,input:timestamp>, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: variance, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: var_pop, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: var_samp, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: std, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_pop, VectorUDAFVarTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,variance:double> aggregation: stddev_samp
1064                           className: VectorGroupByOperator
1065                           groupByMode: HASH
1066                           native: false
1067                           vectorProcessingMode: HASH
1068                           projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7]
1069                       mode: hash
1070                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
1071                       Statistics: Num rows: 1 Data size: 672 Basic stats: COMPLETE Column stats: NONE
1072                       Reduce Output Operator
1073                         sort order: 
1074                         Reduce Sink Vectorization:
1075                             className: VectorReduceSinkEmptyKeyOperator
1076                             native: true
1077                             nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
1078                         Statistics: Num rows: 1 Data size: 672 Basic stats: COMPLETE Column stats: NONE
1079                         value expressions: _col0 (type: struct<count:bigint,sum:double,input:timestamp>), _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>), _col3 (type: struct<count:bigint,sum:double,variance:double>), _col4 (type: struct<count:bigint,sum:double,variance:double>), _col5 (type: struct<count:bigint,sum:double,variance:double>), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>)
1080             Execution mode: vectorized
1081             Map Vectorization:
1082                 enabled: true
1083                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
1084                 inputFormatFeatureSupport: []
1085                 featureSupportInUse: []
1086                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
1087                 allNative: false
1088                 usesVectorUDFAdaptor: false
1089                 vectorized: true
1090         Reducer 2 
1091             Reduce Vectorization:
1092                 enabled: true
1093                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
1094                 notVectorizedReason: GROUPBY operator: Vector aggregation : "variance" for input type: "STRUCT" and output type: "DOUBLE" and mode: FINAL not supported for evaluator GenericUDAFVarianceEvaluator
1095                 vectorized: false
1096             Reduce Operator Tree:
1097               Group By Operator
1098                 aggregations: avg(VALUE._col0), variance(VALUE._col1), var_pop(VALUE._col2), var_samp(VALUE._col3), std(VALUE._col4), stddev(VALUE._col5), stddev_pop(VALUE._col6), stddev_samp(VALUE._col7)
1099                 mode: mergepartial
1100                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
1101                 Statistics: Num rows: 1 Data size: 672 Basic stats: COMPLETE Column stats: NONE
1102                 Select Operator
1103                   expressions: round(_col0, 0) (type: double), _col1 BETWEEN 8.97077295279421E19D AND 8.97077295279422E19D (type: boolean), _col2 BETWEEN 8.97077295279421E19D AND 8.97077295279422E19D (type: boolean), _col3 BETWEEN 9.20684592523616E19D AND 9.20684592523617E19D (type: boolean), round(_col4, 3) (type: double), round(_col5, 3) (type: double), round(_col6, 3) (type: double), round(_col7, 3) (type: double)
1104                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
1105                   Statistics: Num rows: 1 Data size: 672 Basic stats: COMPLETE Column stats: NONE
1106                   File Output Operator
1107                     compressed: false
1108                     Statistics: Num rows: 1 Data size: 672 Basic stats: COMPLETE Column stats: NONE
1109                     table:
1110                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
1111                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
1112                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1113
1114   Stage: Stage-0
1115     Fetch Operator
1116       limit: -1
1117       Processor Tree:
1118         ListSink
1119
1120 PREHOOK: query: SELECT
1121   round(avg(ctimestamp1), 0),
1122   variance(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1123   var_pop(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1124   var_samp(ctimestamp1) between 9.20684592523616E19 and 9.20684592523617E19,
1125   round(std(ctimestamp1), 3),
1126   round(stddev(ctimestamp1), 3),
1127   round(stddev_pop(ctimestamp1), 3),
1128   round(stddev_samp(ctimestamp1), 3)
1129 FROM alltypesorc_string
1130 PREHOOK: type: QUERY
1131 PREHOOK: Input: default@alltypesorc_string
1132 #### A masked pattern was here ####
1133 POSTHOOK: query: SELECT
1134   round(avg(ctimestamp1), 0),
1135   variance(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1136   var_pop(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19,
1137   var_samp(ctimestamp1) between 9.20684592523616E19 and 9.20684592523617E19,
1138   round(std(ctimestamp1), 3),
1139   round(stddev(ctimestamp1), 3),
1140   round(stddev_pop(ctimestamp1), 3),
1141   round(stddev_samp(ctimestamp1), 3)
1142 FROM alltypesorc_string
1143 POSTHOOK: type: QUERY
1144 POSTHOOK: Input: default@alltypesorc_string
1145 #### A masked pattern was here ####
1146 NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL