HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / llap / vectorized_timestamp.q.out
1 PREHOOK: query: DROP TABLE IF EXISTS test
2 PREHOOK: type: DROPTABLE
3 POSTHOOK: query: DROP TABLE IF EXISTS test
4 POSTHOOK: type: DROPTABLE
5 PREHOOK: query: CREATE TABLE test(ts TIMESTAMP) STORED AS ORC
6 PREHOOK: type: CREATETABLE
7 PREHOOK: Output: database:default
8 PREHOOK: Output: default@test
9 POSTHOOK: query: CREATE TABLE test(ts TIMESTAMP) STORED AS ORC
10 POSTHOOK: type: CREATETABLE
11 POSTHOOK: Output: database:default
12 POSTHOOK: Output: default@test
13 PREHOOK: query: INSERT INTO TABLE test VALUES ('0001-01-01 00:00:00.000000000'), ('9999-12-31 23:59:59.999999999')
14 PREHOOK: type: QUERY
15 PREHOOK: Input: _dummy_database@_dummy_table
16 PREHOOK: Output: default@test
17 POSTHOOK: query: INSERT INTO TABLE test VALUES ('0001-01-01 00:00:00.000000000'), ('9999-12-31 23:59:59.999999999')
18 POSTHOOK: type: QUERY
19 POSTHOOK: Input: _dummy_database@_dummy_table
20 POSTHOOK: Output: default@test
21 POSTHOOK: Lineage: test.ts SCRIPT []
22 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
23 SELECT ts FROM test
24 PREHOOK: type: QUERY
25 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
26 SELECT ts FROM test
27 POSTHOOK: type: QUERY
28 PLAN VECTORIZATION:
29   enabled: false
30   enabledConditionsNotMet: [hive.vectorized.execution.enabled IS false]
31
32 STAGE DEPENDENCIES:
33   Stage-1 is a root stage
34   Stage-0 depends on stages: Stage-1
35
36 STAGE PLANS:
37   Stage: Stage-1
38     Tez
39 #### A masked pattern was here ####
40       Vertices:
41         Map 1 
42             Map Operator Tree:
43                 TableScan
44                   alias: test
45                   Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
46                   Select Operator
47                     expressions: ts (type: timestamp)
48                     outputColumnNames: _col0
49                     Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
50                     File Output Operator
51                       compressed: false
52                       Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
53                       table:
54                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
55                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
56                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
57             Execution mode: llap
58             LLAP IO: all inputs
59
60   Stage: Stage-0
61     Fetch Operator
62       limit: -1
63       Processor Tree:
64         ListSink
65
66 PREHOOK: query: SELECT ts FROM test
67 PREHOOK: type: QUERY
68 PREHOOK: Input: default@test
69 #### A masked pattern was here ####
70 POSTHOOK: query: SELECT ts FROM test
71 POSTHOOK: type: QUERY
72 POSTHOOK: Input: default@test
73 #### A masked pattern was here ####
74 0001-01-01 00:00:00
75 9999-12-31 23:59:59.999999999
76 PREHOOK: query: SELECT MIN(ts), MAX(ts), MAX(ts) - MIN(ts) FROM test
77 PREHOOK: type: QUERY
78 PREHOOK: Input: default@test
79 #### A masked pattern was here ####
80 POSTHOOK: query: SELECT MIN(ts), MAX(ts), MAX(ts) - MIN(ts) FROM test
81 POSTHOOK: type: QUERY
82 POSTHOOK: Input: default@test
83 #### A masked pattern was here ####
84 0001-01-01 00:00:00     9999-12-31 23:59:59.999999999   3652060 23:59:59.999999999
85 PREHOOK: query: SELECT ts FROM test WHERE ts IN (timestamp '0001-01-01 00:00:00.000000000', timestamp '0002-02-02 00:00:00.000000000')
86 PREHOOK: type: QUERY
87 PREHOOK: Input: default@test
88 #### A masked pattern was here ####
89 POSTHOOK: query: SELECT ts FROM test WHERE ts IN (timestamp '0001-01-01 00:00:00.000000000', timestamp '0002-02-02 00:00:00.000000000')
90 POSTHOOK: type: QUERY
91 POSTHOOK: Input: default@test
92 #### A masked pattern was here ####
93 0001-01-01 00:00:00
94 PREHOOK: query: SELECT ts FROM test
95 PREHOOK: type: QUERY
96 PREHOOK: Input: default@test
97 #### A masked pattern was here ####
98 POSTHOOK: query: SELECT ts FROM test
99 POSTHOOK: type: QUERY
100 POSTHOOK: Input: default@test
101 #### A masked pattern was here ####
102 0001-01-01 00:00:00
103 9999-12-31 23:59:59.999999999
104 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
105 SELECT MIN(ts), MAX(ts), MAX(ts) - MIN(ts) FROM test
106 PREHOOK: type: QUERY
107 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
108 SELECT MIN(ts), MAX(ts), MAX(ts) - MIN(ts) FROM test
109 POSTHOOK: type: QUERY
110 PLAN VECTORIZATION:
111   enabled: true
112   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
113
114 STAGE DEPENDENCIES:
115   Stage-1 is a root stage
116   Stage-0 depends on stages: Stage-1
117
118 STAGE PLANS:
119   Stage: Stage-1
120     Tez
121 #### A masked pattern was here ####
122       Edges:
123         Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
124 #### A masked pattern was here ####
125       Vertices:
126         Map 1 
127             Map Operator Tree:
128                 TableScan
129                   alias: test
130                   Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
131                   TableScan Vectorization:
132                       native: true
133                       vectorizationSchemaColumns: [0:ts:timestamp, 1:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
134                   Select Operator
135                     expressions: ts (type: timestamp)
136                     outputColumnNames: ts
137                     Select Vectorization:
138                         className: VectorSelectOperator
139                         native: true
140                         projectedOutputColumnNums: [0]
141                     Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
142                     Group By Operator
143                       aggregations: min(ts), max(ts)
144                       Group By Vectorization:
145                           aggregators: VectorUDAFMinTimestamp(col 0:timestamp) -> timestamp, VectorUDAFMaxTimestamp(col 0:timestamp) -> timestamp
146                           className: VectorGroupByOperator
147                           groupByMode: HASH
148                           native: false
149                           vectorProcessingMode: HASH
150                           projectedOutputColumnNums: [0, 1]
151                       mode: hash
152                       outputColumnNames: _col0, _col1
153                       Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
154                       Reduce Output Operator
155                         sort order: 
156                         Reduce Sink Vectorization:
157                             className: VectorReduceSinkEmptyKeyOperator
158                             keyColumnNums: []
159                             native: true
160                             nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez 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
161                             valueColumnNums: [0, 1]
162                         Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
163                         value expressions: _col0 (type: timestamp), _col1 (type: timestamp)
164             Execution mode: vectorized, llap
165             LLAP IO: all inputs
166             Map Vectorization:
167                 enabled: true
168                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
169                 inputFormatFeatureSupport: []
170                 featureSupportInUse: []
171                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
172                 allNative: false
173                 usesVectorUDFAdaptor: false
174                 vectorized: true
175                 rowBatchContext:
176                     dataColumnCount: 1
177                     includeColumns: [0]
178                     dataColumns: ts:timestamp
179                     partitionColumnCount: 0
180                     scratchColumnTypeNames: []
181         Reducer 2 
182             Execution mode: vectorized, llap
183             Reduce Vectorization:
184                 enabled: true
185                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true
186                 reduceColumnNullOrder: 
187                 reduceColumnSortOrder: 
188                 allNative: false
189                 usesVectorUDFAdaptor: false
190                 vectorized: true
191                 rowBatchContext:
192                     dataColumnCount: 2
193                     dataColumns: VALUE._col0:timestamp, VALUE._col1:timestamp
194                     partitionColumnCount: 0
195                     scratchColumnTypeNames: []
196             Reduce Operator Tree:
197               Group By Operator
198                 aggregations: min(VALUE._col0), max(VALUE._col1)
199                 Group By Vectorization:
200                     aggregators: VectorUDAFMinTimestamp(col 0:timestamp) -> timestamp, VectorUDAFMaxTimestamp(col 1:timestamp) -> timestamp
201                     className: VectorGroupByOperator
202                     groupByMode: MERGEPARTIAL
203                     native: false
204                     vectorProcessingMode: GLOBAL
205                     projectedOutputColumnNums: [0, 1]
206                 mode: mergepartial
207                 outputColumnNames: _col0, _col1
208                 Statistics: Num rows: 1 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
209                 Select Operator
210                   expressions: _col0 (type: timestamp), _col1 (type: timestamp), (_col1 - _col0) (type: interval_day_time)
211                   outputColumnNames: _col0, _col1, _col2
212                   Select Vectorization:
213                       className: VectorSelectOperator
214                       native: true
215                       projectedOutputColumnNums: [0, 1, 2]
216                       selectExpressions: TimestampColSubtractTimestampColumn(col 1:timestamp, col 0:timestamp) -> 2:interval_day_time
217                   Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: COMPLETE
218                   File Output Operator
219                     compressed: false
220                     File Sink Vectorization:
221                         className: VectorFileSinkOperator
222                         native: false
223                     Statistics: Num rows: 1 Data size: 92 Basic stats: COMPLETE Column stats: COMPLETE
224                     table:
225                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
226                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
227                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
228
229   Stage: Stage-0
230     Fetch Operator
231       limit: -1
232       Processor Tree:
233         ListSink
234
235 PREHOOK: query: SELECT MIN(ts), MAX(ts), MAX(ts) - MIN(ts) FROM test
236 PREHOOK: type: QUERY
237 PREHOOK: Input: default@test
238 #### A masked pattern was here ####
239 POSTHOOK: query: SELECT MIN(ts), MAX(ts), MAX(ts) - MIN(ts) FROM test
240 POSTHOOK: type: QUERY
241 POSTHOOK: Input: default@test
242 #### A masked pattern was here ####
243 0001-01-01 00:00:00     9999-12-31 23:59:59.999999999   3652060 23:59:59.999999999
244 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
245 SELECT ts FROM test WHERE ts IN (timestamp '0001-01-01 00:00:00.000000000', timestamp '0002-02-02 00:00:00.000000000')
246 PREHOOK: type: QUERY
247 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
248 SELECT ts FROM test WHERE ts IN (timestamp '0001-01-01 00:00:00.000000000', timestamp '0002-02-02 00:00:00.000000000')
249 POSTHOOK: type: QUERY
250 PLAN VECTORIZATION:
251   enabled: true
252   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
253
254 STAGE DEPENDENCIES:
255   Stage-1 is a root stage
256   Stage-0 depends on stages: Stage-1
257
258 STAGE PLANS:
259   Stage: Stage-1
260     Tez
261 #### A masked pattern was here ####
262       Vertices:
263         Map 1 
264             Map Operator Tree:
265                 TableScan
266                   alias: test
267                   Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
268                   TableScan Vectorization:
269                       native: true
270                       vectorizationSchemaColumns: [0:ts:timestamp, 1:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
271                   Filter Operator
272                     Filter Vectorization:
273                         className: VectorFilterOperator
274                         native: true
275                         predicateExpression: FilterTimestampColumnInList(col 0:timestamp, values [0001-01-01 00:00:00.0, 0002-02-02 00:00:00.0])
276                     predicate: (ts) IN (TIMESTAMP'0001-01-01 00:00:00.0', TIMESTAMP'0002-02-02 00:00:00.0') (type: boolean)
277                     Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
278                     Select Operator
279                       expressions: ts (type: timestamp)
280                       outputColumnNames: _col0
281                       Select Vectorization:
282                           className: VectorSelectOperator
283                           native: true
284                           projectedOutputColumnNums: [0]
285                       Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
286                       File Output Operator
287                         compressed: false
288                         File Sink Vectorization:
289                             className: VectorFileSinkOperator
290                             native: false
291                         Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
292                         table:
293                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
294                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
295                             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
296             Execution mode: vectorized, llap
297             LLAP IO: all inputs
298             Map Vectorization:
299                 enabled: true
300                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
301                 inputFormatFeatureSupport: []
302                 featureSupportInUse: []
303                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
304                 allNative: false
305                 usesVectorUDFAdaptor: false
306                 vectorized: true
307                 rowBatchContext:
308                     dataColumnCount: 1
309                     includeColumns: [0]
310                     dataColumns: ts:timestamp
311                     partitionColumnCount: 0
312                     scratchColumnTypeNames: []
313
314   Stage: Stage-0
315     Fetch Operator
316       limit: -1
317       Processor Tree:
318         ListSink
319
320 PREHOOK: query: SELECT ts FROM test WHERE ts IN (timestamp '0001-01-01 00:00:00.000000000', timestamp '0002-02-02 00:00:00.000000000')
321 PREHOOK: type: QUERY
322 PREHOOK: Input: default@test
323 #### A masked pattern was here ####
324 POSTHOOK: query: SELECT ts FROM test WHERE ts IN (timestamp '0001-01-01 00:00:00.000000000', timestamp '0002-02-02 00:00:00.000000000')
325 POSTHOOK: type: QUERY
326 POSTHOOK: Input: default@test
327 #### A masked pattern was here ####
328 0001-01-01 00:00:00
329 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
330 SELECT AVG(ts), CAST(AVG(ts) AS TIMESTAMP) FROM test
331 PREHOOK: type: QUERY
332 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
333 SELECT AVG(ts), CAST(AVG(ts) AS TIMESTAMP) FROM test
334 POSTHOOK: type: QUERY
335 PLAN VECTORIZATION:
336   enabled: true
337   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
338
339 STAGE DEPENDENCIES:
340   Stage-1 is a root stage
341   Stage-0 depends on stages: Stage-1
342
343 STAGE PLANS:
344   Stage: Stage-1
345     Tez
346 #### A masked pattern was here ####
347       Edges:
348         Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
349 #### A masked pattern was here ####
350       Vertices:
351         Map 1 
352             Map Operator Tree:
353                 TableScan
354                   alias: test
355                   Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
356                   TableScan Vectorization:
357                       native: true
358                       vectorizationSchemaColumns: [0:ts:timestamp, 1:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
359                   Select Operator
360                     expressions: ts (type: timestamp)
361                     outputColumnNames: ts
362                     Select Vectorization:
363                         className: VectorSelectOperator
364                         native: true
365                         projectedOutputColumnNums: [0]
366                     Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
367                     Group By Operator
368                       aggregations: avg(ts)
369                       Group By Vectorization:
370                           aggregators: VectorUDAFAvgTimestamp(col 0:timestamp) -> struct<count:bigint,sum:double,input:timestamp>
371                           className: VectorGroupByOperator
372                           groupByMode: HASH
373                           native: false
374                           vectorProcessingMode: HASH
375                           projectedOutputColumnNums: [0]
376                       mode: hash
377                       outputColumnNames: _col0
378                       Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE
379                       Reduce Output Operator
380                         sort order: 
381                         Reduce Sink Vectorization:
382                             className: VectorReduceSinkEmptyKeyOperator
383                             keyColumnNums: []
384                             native: true
385                             nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez 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
386                             valueColumnNums: [0]
387                         Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE
388                         value expressions: _col0 (type: struct<count:bigint,sum:double,input:timestamp>)
389             Execution mode: vectorized, llap
390             LLAP IO: all inputs
391             Map Vectorization:
392                 enabled: true
393                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
394                 inputFormatFeatureSupport: []
395                 featureSupportInUse: []
396                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
397                 allNative: false
398                 usesVectorUDFAdaptor: false
399                 vectorized: true
400                 rowBatchContext:
401                     dataColumnCount: 1
402                     includeColumns: [0]
403                     dataColumns: ts:timestamp
404                     partitionColumnCount: 0
405                     scratchColumnTypeNames: []
406         Reducer 2 
407             Execution mode: vectorized, llap
408             Reduce Vectorization:
409                 enabled: true
410                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true
411                 reduceColumnNullOrder: 
412                 reduceColumnSortOrder: 
413                 allNative: false
414                 usesVectorUDFAdaptor: false
415                 vectorized: true
416                 rowBatchContext:
417                     dataColumnCount: 1
418                     dataColumns: VALUE._col0:struct<count:bigint,sum:double,input:timestamp>
419                     partitionColumnCount: 0
420                     scratchColumnTypeNames: []
421             Reduce Operator Tree:
422               Group By Operator
423                 aggregations: avg(VALUE._col0)
424                 Group By Vectorization:
425                     aggregators: VectorUDAFAvgFinal(col 0:struct<count:bigint,sum:double,input:timestamp>) -> double
426                     className: VectorGroupByOperator
427                     groupByMode: MERGEPARTIAL
428                     native: false
429                     vectorProcessingMode: GLOBAL
430                     projectedOutputColumnNums: [0]
431                 mode: mergepartial
432                 outputColumnNames: _col0
433                 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
434                 Select Operator
435                   expressions: _col0 (type: double), CAST( _col0 AS TIMESTAMP) (type: timestamp)
436                   outputColumnNames: _col0, _col1
437                   Select Vectorization:
438                       className: VectorSelectOperator
439                       native: true
440                       projectedOutputColumnNums: [0, 1]
441                       selectExpressions: CastDoubleToTimestamp(col 0:double) -> 1:timestamp
442                   Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
443                   File Output Operator
444                     compressed: false
445                     File Sink Vectorization:
446                         className: VectorFileSinkOperator
447                         native: false
448                     Statistics: Num rows: 1 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
449                     table:
450                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
451                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
452                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
453
454   Stage: Stage-0
455     Fetch Operator
456       limit: -1
457       Processor Tree:
458         ListSink
459
460 PREHOOK: query: SELECT AVG(ts), CAST(AVG(ts) AS TIMESTAMP) FROM test
461 PREHOOK: type: QUERY
462 PREHOOK: Input: default@test
463 #### A masked pattern was here ####
464 POSTHOOK: query: SELECT AVG(ts), CAST(AVG(ts) AS TIMESTAMP) FROM test
465 POSTHOOK: type: QUERY
466 POSTHOOK: Input: default@test
467 #### A masked pattern was here ####
468 9.56332944E10   5000-07-01 13:00:00
469 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL
470 SELECT variance(ts), var_pop(ts), var_samp(ts), std(ts), stddev(ts), stddev_pop(ts), stddev_samp(ts) FROM test
471 PREHOOK: type: QUERY
472 POSTHOOK: query: EXPLAIN VECTORIZATION DETAIL
473 SELECT variance(ts), var_pop(ts), var_samp(ts), std(ts), stddev(ts), stddev_pop(ts), stddev_samp(ts) FROM test
474 POSTHOOK: type: QUERY
475 PLAN VECTORIZATION:
476   enabled: true
477   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
478
479 STAGE DEPENDENCIES:
480   Stage-1 is a root stage
481   Stage-0 depends on stages: Stage-1
482
483 STAGE PLANS:
484   Stage: Stage-1
485     Tez
486 #### A masked pattern was here ####
487       Edges:
488         Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
489 #### A masked pattern was here ####
490       Vertices:
491         Map 1 
492             Map Operator Tree:
493                 TableScan
494                   alias: test
495                   Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
496                   TableScan Vectorization:
497                       native: true
498                       vectorizationSchemaColumns: [0:ts:timestamp, 1:ROW__ID:struct<transactionid:bigint,bucketid:int,rowid:bigint>]
499                   Select Operator
500                     expressions: ts (type: timestamp)
501                     outputColumnNames: ts
502                     Select Vectorization:
503                         className: VectorSelectOperator
504                         native: true
505                         projectedOutputColumnNums: [0]
506                     Statistics: Num rows: 2 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
507                     Group By Operator
508                       aggregations: variance(ts), var_pop(ts), var_samp(ts), std(ts), stddev(ts), stddev_pop(ts), stddev_samp(ts)
509                       Group By Vectorization:
510                           aggregators: 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
511                           className: VectorGroupByOperator
512                           groupByMode: HASH
513                           native: false
514                           vectorProcessingMode: HASH
515                           projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6]
516                       mode: hash
517                       outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
518                       Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: COMPLETE
519                       Reduce Output Operator
520                         sort order: 
521                         Reduce Sink Vectorization:
522                             className: VectorReduceSinkEmptyKeyOperator
523                             keyColumnNums: []
524                             native: true
525                             nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez 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
526                             valueColumnNums: [0, 1, 2, 3, 4, 5, 6]
527                         Statistics: Num rows: 1 Data size: 560 Basic stats: COMPLETE Column stats: COMPLETE
528                         value expressions: _col0 (type: struct<count:bigint,sum:double,variance:double>), _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>)
529             Execution mode: vectorized, llap
530             LLAP IO: all inputs
531             Map Vectorization:
532                 enabled: true
533                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
534                 inputFormatFeatureSupport: []
535                 featureSupportInUse: []
536                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
537                 allNative: false
538                 usesVectorUDFAdaptor: false
539                 vectorized: true
540                 rowBatchContext:
541                     dataColumnCount: 1
542                     includeColumns: [0]
543                     dataColumns: ts:timestamp
544                     partitionColumnCount: 0
545                     scratchColumnTypeNames: []
546         Reducer 2 
547             Execution mode: llap
548             Reduce Vectorization:
549                 enabled: true
550                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true
551                 notVectorizedReason: GROUPBY operator: Vector aggregation : "variance" for input type: "STRUCT" and output type: "DOUBLE" and mode: FINAL not supported for evaluator GenericUDAFVarianceEvaluator
552                 vectorized: false
553             Reduce Operator Tree:
554               Group By Operator
555                 aggregations: variance(VALUE._col0), var_pop(VALUE._col1), var_samp(VALUE._col2), std(VALUE._col3), stddev(VALUE._col4), stddev_pop(VALUE._col5), stddev_samp(VALUE._col6)
556                 mode: mergepartial
557                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
558                 Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: COMPLETE
559                 File Output Operator
560                   compressed: false
561                   Statistics: Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: COMPLETE
562                   table:
563                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
564                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
565                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
566
567   Stage: Stage-0
568     Fetch Operator
569       limit: -1
570       Processor Tree:
571         ListSink
572
573 PREHOOK: query: SELECT variance(ts), var_pop(ts), var_samp(ts), std(ts), stddev(ts), stddev_pop(ts), stddev_samp(ts) FROM test
574 PREHOOK: type: QUERY
575 PREHOOK: Input: default@test
576 #### A masked pattern was here ####
577 POSTHOOK: query: SELECT variance(ts), var_pop(ts), var_samp(ts), std(ts), stddev(ts), stddev_pop(ts), stddev_samp(ts) FROM test
578 POSTHOOK: type: QUERY
579 POSTHOOK: Input: default@test
580 #### A masked pattern was here ####
581 2.489106846793884E22    2.489106846793884E22    4.978213693587768E22    1.577690352E11  1.577690352E11  1.577690352E11  2.2311910930235822E11