http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out b/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out index 1791c89..4ea12d7 100644 --- a/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out +++ b/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out @@ -258,7 +258,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true Select Operator @@ -269,7 +269,7 @@ STAGE PLANS: native: true projectedOutputColumnNums: [5, 6, 7, 8, 9, 10, 11, 12, 0, 1, 3, 13, 14, 15, 16, 17] selectExpressions: VectorUDFUnixTimeStampTimestamp(col 1:timestamp) -> 5:bigint, VectorUDFYearTimestamp(col 1:timestamp, field YEAR) -> 6:int, VectorUDFMonthTimestamp(col 1:timestamp, field MONTH) -> 7:int, VectorUDFDayOfMonthTimestamp(col 1:timestamp, field DAY_OF_MONTH) -> 8:int, VectorUDFWeekOfYearTimestamp(col 1:timestamp, field WEEK_OF_YEAR) -> 9:int, VectorUDFHourTimestamp(col 1:timestamp, field HOUR_OF_DAY) -> 10:int, VectorUDFMinuteTimestamp(col 1:timestamp, field MINUTE) -> 11:int, VectorUDFSecondTimestamp(col 1:timestamp, field SECOND) -> 12:int, IfExprTimestampColumnScalar(col 0:boolean, col 1:timestamp, val 1319-01-25 08:31:57.778) -> 13:timestamp, IfExprTimestampScalarColumn(col 0:boolean, val 2000-12-18 00:42:30.0005, col 1:timestamp) -> 14:timestamp, IfExprTimestampColumnColumn(col 0:boolean, col 1:timestampcol 3:timestamp) -> 15:timestamp, IfExprColumnNull(col 0:boolean, col 1:timestamp, null)(children: col 0:boolean, col 1:timestamp) -> 16:ti mestamp, IfExprNullColumn(col 0:boolean, null, col 3)(children: col 0:boolean, col 3:timestamp) -> 17:timestamp - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: bigint) sort order: + @@ -277,7 +277,7 @@ STAGE PLANS: className: VectorReduceSinkObjectHashOperator native: true 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 - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col9 (type: boolean), _col10 (type: timestamp), _col11 (type: timestamp), _col12 (type: timestamp), _col13 (type: timestamp), _col14 (type: timestamp), _col15 (type: timestamp), _col16 (type: timestamp) Execution mode: vectorized Map Vectorization: @@ -305,13 +305,13 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [0, 1, 2, 3, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false File Sink Vectorization: className: VectorFileSinkOperator native: false - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -369,6 +369,46 @@ ORDER BY c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.628 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:43.628 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.637 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:43.637 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.64 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:43.64 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.661 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:43.661 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.676 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:43.676 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.705 1969-12-31 15:59:58.456 1319-02-02 16:31:57.778 1969-12-31 23:59:43.705 1969-12-31 15:59:58.456 NULL 1969-12-31 15:59:58.456 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.709 1969-12-31 15:59:58.456 1319-02-02 16:31:57.778 1969-12-31 23:59:43.709 1969-12-31 15:59:58.456 NULL 1969-12-31 15:59:58.456 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.72 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:43.72 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.721 1969-12-31 15:59:58.456 1319-02-02 16:31:57.778 1969-12-31 23:59:43.721 1969-12-31 15:59:58.456 NULL 1969-12-31 15:59:58.456 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.749 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:43.749 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.771 1969-12-31 15:59:58.456 1319-02-02 16:31:57.778 1969-12-31 23:59:43.771 1969-12-31 15:59:58.456 NULL 1969-12-31 15:59:58.456 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.773 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:43.773 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.782 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:43.782 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.783 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:43.783 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.807 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:43.807 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-16 1969 12 31 31 1 23 59 43 NULL 1969-12-31 23:59:43.82 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:43.82 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.619 1969-12-31 16:00:14.793 1969-12-31 23:59:43.619 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.619 1969-12-31 23:59:43.619 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.627 1969-12-31 16:00:03.679 1969-12-31 23:59:43.627 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.627 1969-12-31 23:59:43.627 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.631 1969-12-31 16:00:06.612 1969-12-31 23:59:43.631 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.631 1969-12-31 23:59:43.631 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.642 1969-12-31 16:00:04.424 1969-12-31 23:59:43.642 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.642 1969-12-31 23:59:43.642 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.643 1969-12-31 16:00:11.764 1969-12-31 23:59:43.643 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.643 1969-12-31 23:59:43.643 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.645 1969-12-31 16:00:00.077 1969-12-31 23:59:43.645 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.645 1969-12-31 23:59:43.645 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.661 1969-12-31 15:59:58.732 1969-12-31 23:59:43.661 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.661 1969-12-31 23:59:43.661 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.689 1969-12-31 15:59:46.848 1969-12-31 23:59:43.689 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.689 1969-12-31 23:59:43.689 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.695 1969-12-31 16:00:06.867 1969-12-31 23:59:43.695 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.695 1969-12-31 23:59:43.695 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.707 1969-12-31 15:59:56.965 1969-12-31 23:59:43.707 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.707 1969-12-31 23:59:43.707 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.71 1969-12-31 16:00:00.687 1969-12-31 23:59:43.71 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.71 1969-12-31 23:59:43.71 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.723 1969-12-31 16:00:03.375 1969-12-31 23:59:43.723 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.723 1969-12-31 23:59:43.723 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.745 1969-12-31 16:00:04.052 1969-12-31 23:59:43.745 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.745 1969-12-31 23:59:43.745 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.764 1969-12-31 16:00:10.52 1969-12-31 23:59:43.764 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.764 1969-12-31 23:59:43.764 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.775 1969-12-31 15:59:48.003 1969-12-31 23:59:43.775 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.775 1969-12-31 23:59:43.775 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.779 1969-12-31 15:59:53.274 1969-12-31 23:59:43.779 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.779 1969-12-31 23:59:43.779 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.785 1969-12-31 16:00:14.096 1969-12-31 23:59:43.785 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.785 1969-12-31 23:59:43.785 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.792 1969-12-31 15:59:52.041 1969-12-31 23:59:43.792 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.792 1969-12-31 23:59:43.792 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.793 1969-12-31 15:59:56.316 1969-12-31 23:59:43.793 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.793 1969-12-31 23:59:43.793 NULL +-16 1969 12 31 31 1 23 59 43 true 1969-12-31 23:59:43.811 1969-12-31 16:00:00.479 1969-12-31 23:59:43.811 2000-12-18 08:42:30.0005 1969-12-31 23:59:43.811 1969-12-31 23:59:43.811 NULL +-29 1969 12 31 31 1 23 59 30 NULL 1969-12-31 23:59:30.929 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:30.929 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-29 1969 12 31 31 1 23 59 30 NULL 1969-12-31 23:59:30.929 1969-12-31 15:59:55.451 1319-02-02 16:31:57.778 1969-12-31 23:59:30.929 1969-12-31 15:59:55.451 NULL 1969-12-31 15:59:55.451 +-29 1969 12 31 31 1 23 59 30 NULL 1969-12-31 23:59:30.929 1969-12-31 15:59:58.174 1319-02-02 16:31:57.778 1969-12-31 23:59:30.929 1969-12-31 15:59:58.174 NULL 1969-12-31 15:59:58.174 +-29 1969 12 31 31 1 23 59 30 NULL 1969-12-31 23:59:30.929 1969-12-31 15:59:58.456 1319-02-02 16:31:57.778 1969-12-31 23:59:30.929 1969-12-31 15:59:58.456 NULL 1969-12-31 15:59:58.456 -45479202281 528 10 25 25 43 8 15 18 true 0528-10-27 08:15:18.941718273 NULL 0528-10-27 08:15:18.941718273 2000-12-18 08:42:30.0005 0528-10-27 08:15:18.941718273 0528-10-27 08:15:18.941718273 NULL 1632453512 2021 9 24 24 38 3 18 32 NULL 2021-09-24 03:18:32.4 1974-10-04 17:21:03.989 1319-02-02 16:31:57.778 2021-09-24 03:18:32.4 1974-10-04 17:21:03.989 NULL 1974-10-04 17:21:03.989 1632453512 2021 9 24 24 38 3 18 32 false 2021-09-24 03:18:32.4 1999-10-03 16:59:10.396903939 1319-02-02 16:31:57.778 2021-09-24 03:18:32.4 1999-10-03 16:59:10.396903939 NULL 1999-10-03 16:59:10.396903939 @@ -378,47 +418,7 @@ POSTHOOK: Input: default@alltypesorc_string 163809583224 7160 12 2 2 48 6 0 24 NULL 7160-12-02 06:00:24.81200852 NULL 1319-02-02 16:31:57.778 7160-12-02 06:00:24.81200852 NULL NULL NULL 490699811 1985 7 20 20 29 9 30 11 true 1985-07-20 09:30:11 1319-02-02 16:31:57.778 1985-07-20 09:30:11 2000-12-18 08:42:30.0005 1985-07-20 09:30:11 1985-07-20 09:30:11 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1319-02-02 16:31:57.778 NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:47.183 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:47.183 NULL 1969-12-31 15:59:47.183 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:52.843 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:52.843 NULL 1969-12-31 15:59:52.843 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:53.087 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:53.087 NULL 1969-12-31 15:59:53.087 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:53.55 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:53.55 NULL 1969-12-31 15:59:53.55 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:54.042 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:54.042 NULL 1969-12-31 15:59:54.042 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:54.686 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:54.686 NULL 1969-12-31 15:59:54.686 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:58.459 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:58.459 NULL 1969-12-31 15:59:58.459 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:00.889 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:00.889 NULL 1969-12-31 16:00:00.889 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:01.258 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:01.258 NULL 1969-12-31 16:00:01.258 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:05.698 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:05.698 NULL 1969-12-31 16:00:05.698 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:08.602 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:08.602 NULL 1969-12-31 16:00:08.602 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:14.214 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:14.214 NULL 1969-12-31 16:00:14.214 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:15.466 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:15.466 NULL 1969-12-31 16:00:15.466 NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL NULL 1319-02-02 16:31:57.778 NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:46.123 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:49.989 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:51.119 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:52.961 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:52.967 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:53.593 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:53.641 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:55.407 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:55.439 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:56.031 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:57.719 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 15:59:58.636 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:00.176 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:00.423 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:00.477 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:00.93 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:01.839 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:02.13 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:03.151 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:03.756 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:06.134 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:07.209 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:10.361 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:11.525 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:13.589 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:13.839 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 1969-12-31 16:00:15.601 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL 2024-11-11 16:42:41.101 NULL 2000-12-18 08:42:30.0005 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL true NULL NULL NULL 2000-12-18 08:42:30.0005 NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT @@ -466,7 +466,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true Select Operator @@ -477,7 +477,7 @@ STAGE PLANS: native: true projectedOutputColumnNums: [5, 7, 8, 9, 6, 11, 10, 13, 14] selectExpressions: VectorUDFUnixTimeStampString(col 2:string) -> 5:bigint, VectorUDFYearDate(col 6, field YEAR)(children: CastStringToDate(col 2:string) -> 6:date) -> 7:int, VectorUDFMonthDate(col 6, field MONTH)(children: CastStringToDate(col 2:string) -> 6:date) -> 8:int, VectorUDFDayOfMonthDate(col 6, field DAY_OF_MONTH)(children: CastStringToDate(col 2:string) -> 6:date) -> 9:int, VectorUDFDayOfMonthString(col 2:string, fieldStart 8, fieldLength 2) -> 6:int, VectorUDFWeekOfYearDate(col 10, field WEEK_OF_YEAR)(children: CastStringToDate(col 2:string) -> 10:date) -> 11:int, VectorUDFHourTimestamp(col 12:timestamp, field HOUR_OF_DAY)(children: VectorUDFAdaptor(CAST( stimestamp1 AS TIMESTAMP)) -> 12:timestamp) -> 10:int, VectorUDFMinuteTimestamp(col 12:timestamp, field MINUTE)(children: VectorUDFAdaptor(CAST( stimestamp1 AS TIMESTAMP)) -> 12:timestamp) -> 13:int, VectorUDFSecondTimestamp(col 12:timestamp, field SECOND)(children: VectorUDFAdaptor(CAST( stimest amp1 AS TIMESTAMP)) -> 12:timestamp) -> 14:int - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: bigint) sort order: + @@ -485,7 +485,7 @@ STAGE PLANS: className: VectorReduceSinkObjectHashOperator native: true 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 - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE 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) Execution mode: vectorized Map Vectorization: @@ -513,13 +513,13 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8] - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false File Sink Vectorization: className: VectorFileSinkOperator native: false - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -561,7 +561,47 @@ ORDER BY c1 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 +-17 1969 12 31 31 1 23 59 43 -2736272726 1883 4 17 17 16 4 14 34 +-30 1969 12 31 31 1 23 59 30 +-30 1969 12 31 31 1 23 59 30 +-30 1969 12 31 31 1 23 59 30 +-30 1969 12 31 31 1 23 59 30 -62018199211 4 9 24 22 39 18 26 29 1365554626 2013 4 10 10 15 0 43 46 206730996125 8521 1 16 16 3 20 42 5 @@ -573,46 +613,6 @@ NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1) AS c1, year(ctimestamp1) = year(stimestamp1), @@ -658,7 +658,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true Select Operator @@ -669,7 +669,7 @@ STAGE PLANS: native: true projectedOutputColumnNums: [7, 6, 8, 9, 11, 10, 14, 15, 16] selectExpressions: LongColEqualLongColumn(col 5:bigint, col 6:bigint)(children: VectorUDFUnixTimeStampTimestamp(col 1:timestamp) -> 5:bigint, VectorUDFUnixTimeStampString(col 2:string) -> 6:bigint) -> 7:boolean, LongColEqualLongColumn(col 5:int, col 8:int)(children: VectorUDFYearTimestamp(col 1:timestamp, field YEAR) -> 5:int, VectorUDFYearDate(col 6, field YEAR)(children: CastStringToDate(col 2:string) -> 6:date) -> 8:int) -> 6:boolean, LongColEqualLongColumn(col 5:int, col 9:int)(children: VectorUDFMonthTimestamp(col 1:timestamp, field MONTH) -> 5:int, VectorUDFMonthDate(col 8, field MONTH)(children: CastStringToDate(col 2:string) -> 8:date) -> 9:int) -> 8:boolean, LongColEqualLongColumn(col 5:int, col 10:int)(children: VectorUDFDayOfMonthTimestamp(col 1:timestamp, field DAY_OF_MONTH) -> 5:int, VectorUDFDayOfMonthDate(col 9, field DAY_OF_MONTH)(children: CastStringToDate(col 2:string) -> 9:date) -> 10:int) -> 9:boolean, LongColEqualLongColumn(col 5:int, col 10:int)(children: VectorUDFDayOfMonthTimestamp(col 1:timestamp, field DAY_OF_MONTH) -> 5:int, VectorUDFDayOfMonthString(col 2:string, fieldStart 8, fieldLength 2) -> 10:int) -> 11:boolean, LongColEqualLongColumn(col 5:int, col 12:int)(children: VectorUDFWeekOfYearTimestamp(col 1:timestamp, field WEEK_OF_YEAR) -> 5:int, VectorUDFWeekOfYearDate(col 10, field WEEK_OF_YEAR)(children: CastStringToDate(col 2:string) -> 10:date) -> 12:int) -> 10:boolean, LongColEqualLongColumn(col 5:int, col 12:int)(children: VectorUDFHourTimestamp(col 1:timestamp, field HOUR_OF_DAY) -> 5:int, VectorUDFHourTimestamp(col 13:timestamp, field HOUR_OF_DAY)(children: VectorUDFAdaptor(CAST( stimestamp1 AS TIMESTAMP)) -> 13:timestamp) -> 12:int) -> 14:boolean, LongColEqualLongColumn(col 5:int, col 12:int)(children: VectorUDFMinuteTimestamp(col 1:timestamp, field MINUTE) -> 5:int, VectorUDFMinuteTimestamp(col 13:timestamp, field MINUTE)(children: VectorUDFAdaptor(CAST( stimestamp1 AS TIMESTAMP)) -> 13:timestamp) -> 12:int) -> 15:boolean, LongColEqualLongColumn(col 5:int, col 12:int)(children: VectorUDFSecondTimestamp(col 1:timestamp, field SECOND) -> 5:int, VectorUDFSecondTimestamp(col 13:timestamp, field SECOND)(children: VectorUDFAdaptor(CAST( stimestamp1 AS TIMESTAMP)) -> 13:timestamp) -> 12:int) -> 16:boolean - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: boolean) sort order: + @@ -677,7 +677,7 @@ STAGE PLANS: className: VectorReduceSinkObjectHashOperator native: true 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 - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE 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) Execution mode: vectorized Map Vectorization: @@ -705,13 +705,13 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [0, 1, 2, 3, 4, 5, 6, 7, 8] - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false File Sink Vectorization: className: VectorFileSinkOperator native: false - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -761,50 +761,50 @@ NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false false +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true +false true true true true true true true true PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT to_unix_timestamp(stimestamp1) AS c1, year(stimestamp1), @@ -981,7 +981,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true Select Operator @@ -991,7 +991,7 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [1] - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: min(ctimestamp1), max(ctimestamp1), count(ctimestamp1), count() Group By Vectorization: @@ -1078,7 +1078,7 @@ FROM alltypesorc_string POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### -0528-10-27 08:15:18.941718273 7160-12-02 06:00:24.81200852 8 52 +0528-10-27 08:15:18.941718273 7160-12-02 06:00:24.81200852 48 52 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT round(sum(ctimestamp1), 3) FROM alltypesorc_string @@ -1106,7 +1106,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true Select Operator @@ -1116,7 +1116,7 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [1] - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(ctimestamp1) Group By Vectorization: @@ -1206,7 +1206,7 @@ FROM alltypesorc_string POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### -2.89160478029166E11 +2.891604773267E11 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT round(avg(ctimestamp1), 0), variance(ctimestamp1) between 8.97077295279421E19 and 8.97077295279422E19, @@ -1248,7 +1248,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true Select Operator @@ -1259,7 +1259,7 @@ STAGE PLANS: native: true projectedOutputColumnNums: [1, 5, 8] selectExpressions: CastTimestampToDouble(col 1:timestamp) -> 5:double, DoubleColMultiplyDoubleColumn(col 6:double, col 7:double)(children: CastTimestampToDouble(col 1:timestamp) -> 6:double, CastTimestampToDouble(col 1:timestamp) -> 7:double) -> 8:double - Statistics: Num rows: 52 Data size: 3219 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(_col0), count(_col0), sum(_col2), sum(_col1) Group By Vectorization: @@ -1363,4 +1363,4 @@ FROM alltypesorc_string POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc_string #### A masked pattern was here #### -3.6145059754E10 false false false 7.5245178084814E10 7.5245178084814E10 7.5245178084814E10 8.0440478971476E10 +6.024176611E9 false false false 3.3542405863247E10 3.3542405863247E10 3.3542405863247E10 3.3897361841912E10
http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/spark/windowing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/windowing.q.out b/ql/src/test/results/clientpositive/spark/windowing.q.out index 7967d05..e2295c1 100644 --- a/ql/src/test/results/clientpositive/spark/windowing.q.out +++ b/ql/src/test/results/clientpositive/spark/windowing.q.out @@ -1856,7 +1856,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col2 raw input shape: window functions: http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out b/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out index e744d0f..6f58dc9 100644 --- a/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out +++ b/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out @@ -317,7 +317,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col5 ASC NULLS FIRST + order by: _col5 ASC NULLS LAST partition by: _col2 raw input shape: window functions: @@ -485,7 +485,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col5 ASC NULLS FIRST + order by: _col5 ASC NULLS LAST partition by: _col2 raw input shape: window functions: http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/tez/acid_vectorization_original_tez.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_vectorization_original_tez.q.out b/ql/src/test/results/clientpositive/tez/acid_vectorization_original_tez.q.out index 634b4ea..192f577 100644 --- a/ql/src/test/results/clientpositive/tez/acid_vectorization_original_tez.q.out +++ b/ql/src/test/results/clientpositive/tez/acid_vectorization_original_tez.q.out @@ -97,7 +97,6 @@ POSTHOOK: query: select distinct si, si%4 from over10k_n9 order by si POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k_n9 POSTHOOK: Output: hdfs://### HDFS PATH ### -NULL NULL 256 0 257 1 258 2 @@ -350,6 +349,7 @@ NULL NULL 509 1 510 2 511 3 +NULL NULL PREHOOK: query: insert into over10k_orc_bucketed_n0 select * from over10k_n9 PREHOOK: type: QUERY PREHOOK: Input: default@over10k_n9 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/udtf_json_tuple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udtf_json_tuple.q.out b/ql/src/test/results/clientpositive/udtf_json_tuple.q.out index d500c14..45a8f46 100644 --- a/ql/src/test/results/clientpositive/udtf_json_tuple.q.out +++ b/ql/src/test/results/clientpositive/udtf_json_tuple.q.out @@ -189,12 +189,12 @@ POSTHOOK: query: select json_tuple(a.jstring, 'f1', 'f2', 'f3', 'f4', 'f5') as ( POSTHOOK: type: QUERY POSTHOOK: Input: default@json_t #### A masked pattern was here #### -NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL value1 value2 3 NULL 5.23 value12 2 value3 4.01 NULL value13 2 value33 value44 5.01 +NULL NULL NULL NULL NULL +NULL NULL NULL NULL NULL PREHOOK: query: explain select a.key, b.f2, b.f5 from json_t a lateral view json_tuple(a.jstring, 'f1', 'f2', 'f3', 'f4', 'f5') b as f1, f2, f3, f4, f5 order by a.key PREHOOK: type: QUERY @@ -403,9 +403,9 @@ POSTHOOK: query: select f2, count(*) from json_t a lateral view json_tuple(a.jst POSTHOOK: type: QUERY POSTHOOK: Input: default@json_t #### A masked pattern was here #### -NULL 1 2 2 value2 1 +NULL 1 PREHOOK: query: CREATE TABLE dest1_n65(c1 STRING) STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out b/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out index 51e23e5..c122bf6 100644 --- a/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out +++ b/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out @@ -208,12 +208,12 @@ POSTHOOK: query: select parse_url_tuple(a.fullurl, 'HOST', 'PATH', 'QUERY', 'REF POSTHOOK: type: QUERY POSTHOOK: Input: default@url_t #### A masked pattern was here #### -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL NULL NULL NULL NULL NULL NULL NULL NULL facebook.com /path1/p.php k1=v1&k2=v2 Ref1 http /path1/p.php?k1=v1&k2=v2 facebook.com NULL v1 sites.google.com /a/example.com/site/page NULL NULL ftp /a/example.com/site/page sites.google.com NULL NULL www.socs.uts.edu.au /MosaicDocs-old/url-primer.html k1=tps chapter1 https /MosaicDocs-old/url-primer.html?k1=tps www.socs.uts.edu.au:80 NULL tps +NULL NULL NULL NULL NULL NULL NULL NULL NULL +NULL NULL NULL NULL NULL NULL NULL NULL NULL +NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain select a.key, b.ho, b.qu, b.qk1, b.err1, b.err2, b.err3 from url_t a lateral view parse_url_tuple(a.fullurl, 'HOST', 'PATH', 'QUERY', 'REF', 'PROTOCOL', 'FILE', 'AUTHORITY', 'USERINFO', 'QUERY:k1', 'host', 'query', 'QUERY:nonExistCol') b as ho, pa, qu, re, pr, fi, au, us, qk1, err1, err2, err3 order by a.key PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/union_ppr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/union_ppr.q.out b/ql/src/test/results/clientpositive/union_ppr.q.out index a42d619..f441112 100644 --- a/ql/src/test/results/clientpositive/union_ppr.q.out +++ b/ql/src/test/results/clientpositive/union_ppr.q.out @@ -44,7 +44,7 @@ STAGE PLANS: Statistics: Num rows: 666 Data size: 7074 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), '2008-04-08' (type: string), _col3 (type: string) - null sort order: aaaa + null sort order: zzzz sort order: ++++ Statistics: Num rows: 666 Data size: 7074 Basic stats: COMPLETE Column stats: NONE tag: -1 @@ -69,7 +69,7 @@ STAGE PLANS: Statistics: Num rows: 666 Data size: 7074 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), '2008-04-08' (type: string), _col3 (type: string) - null sort order: aaaa + null sort order: zzzz sort order: ++++ Statistics: Num rows: 666 Data size: 7074 Basic stats: COMPLETE Column stats: NONE tag: -1 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/union_remove_6_subq.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/union_remove_6_subq.q.out b/ql/src/test/results/clientpositive/union_remove_6_subq.q.out index daf05f2..80b8bbf 100644 --- a/ql/src/test/results/clientpositive/union_remove_6_subq.q.out +++ b/ql/src/test/results/clientpositive/union_remove_6_subq.q.out @@ -525,7 +525,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col1 ASC NULLS FIRST + order by: _col1 ASC NULLS LAST partition by: _col0 raw input shape: window functions: http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/update_all_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/update_all_partitioned.q.out b/ql/src/test/results/clientpositive/update_all_partitioned.q.out index 4ee1e2e..78c02ce 100644 --- a/ql/src/test/results/clientpositive/update_all_partitioned.q.out +++ b/ql/src/test/results/clientpositive/update_all_partitioned.q.out @@ -53,11 +53,11 @@ POSTHOOK: Input: default@acid_uap@ds=tomorrow 762 BLoMwUJ51ns6pd tomorrow 762 a10E76jX35YwquKCTA tomorrow 762 q5y2Vy1 tomorrow -6981 NULL tomorrow 6981 1FNNhmiFLGw425NA13g tomorrow 6981 4KhrrQ0nJ7bMNTvhSCA tomorrow 6981 K630vaVf tomorrow 6981 Y5x3JuI3M8jngv5N tomorrow +6981 YdG61y00526u5 tomorrow PREHOOK: query: update acid_uap set b = 'fred' PREHOOK: type: QUERY PREHOOK: Input: default@acid_uap http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/update_tmp_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/update_tmp_table.q.out b/ql/src/test/results/clientpositive/update_tmp_table.q.out index 446a379..746fb9f 100644 --- a/ql/src/test/results/clientpositive/update_tmp_table.q.out +++ b/ql/src/test/results/clientpositive/update_tmp_table.q.out @@ -50,7 +50,6 @@ POSTHOOK: query: select * from acid_utt order by a POSTHOOK: type: QUERY POSTHOOK: Input: default@acid_utt #### A masked pattern was here #### -NULL 0ruyd6Y50JpdGRf6HqD -1073279343 oj1YrV5Wa -1073051226 A34p7oRr2WvUJNf -1072910839 0iqrc5 @@ -60,3 +59,4 @@ NULL 0ruyd6Y50JpdGRf6HqD -1071363017 Anj0oF -1070551679 iUR3Q -1069736047 k17Am8uPHWk02cEf1jet +NULL 0ruyd6Y50JpdGRf6HqD http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/update_where_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/update_where_partitioned.q.out b/ql/src/test/results/clientpositive/update_where_partitioned.q.out index 1834e83..ac603b8 100644 --- a/ql/src/test/results/clientpositive/update_where_partitioned.q.out +++ b/ql/src/test/results/clientpositive/update_where_partitioned.q.out @@ -53,11 +53,11 @@ POSTHOOK: Input: default@acid_uwp@ds=tomorrow 762 BLoMwUJ51ns6pd tomorrow 762 a10E76jX35YwquKCTA tomorrow 762 q5y2Vy1 tomorrow -6981 NULL tomorrow 6981 1FNNhmiFLGw425NA13g tomorrow 6981 4KhrrQ0nJ7bMNTvhSCA tomorrow 6981 K630vaVf tomorrow 6981 Y5x3JuI3M8jngv5N tomorrow +6981 YdG61y00526u5 tomorrow PREHOOK: query: update acid_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet' PREHOOK: type: QUERY PREHOOK: Input: default@acid_uwp @@ -99,8 +99,8 @@ POSTHOOK: Input: default@acid_uwp@ds=tomorrow 762 BLoMwUJ51ns6pd tomorrow 762 a10E76jX35YwquKCTA tomorrow 762 q5y2Vy1 tomorrow -6981 NULL tomorrow 6981 1FNNhmiFLGw425NA13g tomorrow 6981 4KhrrQ0nJ7bMNTvhSCA tomorrow 6981 K630vaVf tomorrow 6981 Y5x3JuI3M8jngv5N tomorrow +6981 YdG61y00526u5 tomorrow http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_case_when_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_case_when_2.q.out b/ql/src/test/results/clientpositive/vector_case_when_2.q.out index 9ff8750..b54d3ae 100644 --- a/ql/src/test/results/clientpositive/vector_case_when_2.q.out +++ b/ql/src/test/results/clientpositive/vector_case_when_2.q.out @@ -235,7 +235,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamps #### A masked pattern was here #### ctimestamp1 ctimestamp2 ctimestamp2_description ctimestamp2_description_2 ctimestamp2_description_3 field1 field_2 field_3 field_4 field_5 -NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL 0004-09-22 18:26:29.519542222 0004-09-21 16:23:25.519542222 1800s or Earlier Old Old 4 0004-09-22 18:26:29.519542222 26 NULL 0005-09-22 0528-10-27 08:15:18.941718273 0528-10-26 06:12:14.941718273 1800s or Earlier Old Old 528 2018-03-08 23:04:59 15 NULL 0529-10-27 1319-02-02 16:31:57.778 1319-02-01 14:28:53.778 1800s or Earlier Old Old 1319 1319-02-02 16:31:57.778 31 NULL 1320-02-02 @@ -286,6 +285,7 @@ NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL 9075-06-13 16:20:09.218517797 9075-06-12 14:17:05.218517797 Unknown NULL NULL 9075 2018-03-08 23:04:59 20 NULL 9075-06-14 9209-11-11 04:08:58.223768453 9209-11-10 02:05:54.223768453 Unknown NULL NULL 9209 2018-03-08 23:04:59 8 NULL 9209-11-12 9403-01-09 18:12:33.547 9403-01-08 16:09:29.547 Unknown NULL NULL 9403 2018-03-08 23:04:59 12 NULL 9404-01-09 +NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ctimestamp1, @@ -494,7 +494,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamps #### A masked pattern was here #### ctimestamp1 ctimestamp2 ctimestamp2_description ctimestamp2_description_2 ctimestamp2_description_3 field1 field_2 field_3 field_4 field_5 -NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL 0004-09-22 18:26:29.519542222 0004-09-21 16:23:25.519542222 1800s or Earlier Old Old 4 0004-09-22 18:26:29.519542222 26 NULL 0005-09-22 0528-10-27 08:15:18.941718273 0528-10-26 06:12:14.941718273 1800s or Earlier Old Old 528 2018-03-08 23:04:59 15 NULL 0529-10-27 1319-02-02 16:31:57.778 1319-02-01 14:28:53.778 1800s or Earlier Old Old 1319 1319-02-02 16:31:57.778 31 NULL 1320-02-02 @@ -545,6 +544,7 @@ NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL 9075-06-13 16:20:09.218517797 9075-06-12 14:17:05.218517797 Unknown NULL NULL 9075 2018-03-08 23:04:59 20 NULL 9075-06-14 9209-11-11 04:08:58.223768453 9209-11-10 02:05:54.223768453 Unknown NULL NULL 9209 2018-03-08 23:04:59 8 NULL 9209-11-12 9403-01-09 18:12:33.547 9403-01-08 16:09:29.547 Unknown NULL NULL 9403 2018-03-08 23:04:59 12 NULL 9404-01-09 +NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT ctimestamp1, @@ -753,7 +753,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@timestamps #### A masked pattern was here #### ctimestamp1 ctimestamp2 ctimestamp2_description ctimestamp2_description_2 ctimestamp2_description_3 field1 field_2 field_3 field_4 field_5 -NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL 0004-09-22 18:26:29.519542222 0004-09-21 16:23:25.519542222 1800s or Earlier Old Old 4 0004-09-22 18:26:29.519542222 26 NULL 0005-09-22 0528-10-27 08:15:18.941718273 0528-10-26 06:12:14.941718273 1800s or Earlier Old Old 528 2018-03-08 23:04:59 15 NULL 0529-10-27 1319-02-02 16:31:57.778 1319-02-01 14:28:53.778 1800s or Earlier Old Old 1319 1319-02-02 16:31:57.778 31 NULL 1320-02-02 @@ -804,3 +803,4 @@ NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL 9075-06-13 16:20:09.218517797 9075-06-12 14:17:05.218517797 Unknown NULL NULL 9075 2018-03-08 23:04:59 20 NULL 9075-06-14 9209-11-11 04:08:58.223768453 9209-11-10 02:05:54.223768453 Unknown NULL NULL 9209 2018-03-08 23:04:59 8 NULL 9209-11-12 9403-01-09 18:12:33.547 9403-01-08 16:09:29.547 Unknown NULL NULL 9403 2018-03-08 23:04:59 12 NULL 9404-01-09 +NULL NULL Unknown NULL NULL NULL 2018-03-08 23:04:59 NULL NULL NULL http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_coalesce.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_coalesce.q.out b/ql/src/test/results/clientpositive/vector_coalesce.q.out index 0d20a0e..891839b 100644 --- a/ql/src/test/results/clientpositive/vector_coalesce.q.out +++ b/ql/src/test/results/clientpositive/vector_coalesce.q.out @@ -73,16 +73,16 @@ LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL NULL -413196097 -51.0 NULL -413196097 -NULL NULL -413553449 11.0 NULL -413553449 -NULL NULL -457224565 11.0 NULL -457224565 -NULL NULL -591488718 -51.0 NULL -591488718 -NULL NULL -656987896 8.0 NULL -656987896 -NULL NULL -670908417 8.0 NULL -670908417 -NULL NULL -738306196 -51.0 NULL -738306196 -NULL NULL -819152895 8.0 NULL -819152895 -NULL NULL -827212561 8.0 NULL -827212561 -NULL NULL -949587513 11.0 NULL -949587513 +NULL 00MmJs1fiJp37y60mj4Ej8 -698191930 -51.0 NULL 00MmJs1fiJp37y60mj4Ej8 +NULL 00PafC7v 349566607 -51.0 NULL 00PafC7v +NULL 00iT08 284688862 -51.0 NULL 00iT08 +NULL 00k3yt70n476d6UQA -391432229 8.0 NULL 00k3yt70n476d6UQA +NULL 014ILGhXxNY7g02hl0Xw 633097881 11.0 NULL 014ILGhXxNY7g02hl0Xw +NULL 02VRbSC5I 551634127 8.0 NULL 02VRbSC5I +NULL 02k5poW73QsWM 891702124 11.0 NULL 02k5poW73QsWM +NULL 02v8WnLuYDos3Cq -648704945 8.0 NULL 02v8WnLuYDos3Cq +NULL 02vDyIVT752 388584379 11.0 NULL 02vDyIVT752 +NULL 0333uXvwB3ADRa4aP1h 336245146 8.0 NULL 0333uXvwB3ADRa4aP1h PREHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT ctinyint, cdouble, cint, coalesce(ctinyint+10, (cdouble+log2(cint)), 0) as c FROM alltypesorc WHERE (ctinyint IS NULL) @@ -158,16 +158,16 @@ LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL NULL -1015272448 0.0 -NULL NULL -609074876 0.0 -NULL NULL -700300206 0.0 -NULL NULL -726473298 0.0 -NULL NULL -738747840 0.0 -NULL NULL -838810013 0.0 -NULL NULL -850295959 0.0 -NULL NULL -886426182 0.0 -NULL NULL -899422227 0.0 -NULL NULL -971543377 0.0 +NULL -16269.0 -378213344 0.0 +NULL -16274.0 -671342269 0.0 +NULL -16296.0 -146635689 0.0 +NULL -16296.0 593429004 -16266.855499800256 +NULL -16300.0 -860437234 0.0 +NULL -16306.0 384405526 -16277.481946165259 +NULL -16307.0 559926362 -16277.939338135451 +NULL -16309.0 -826497289 0.0 +NULL -16310.0 206154150 -16282.380851737113 +NULL -16379.0 -894716315 0.0 PREHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT cfloat, cbigint, coalesce(cfloat, cbigint, 0) as c FROM alltypesorc WHERE (cfloat IS NULL AND cbigint IS NULL) @@ -324,16 +324,16 @@ LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### -NULL 1969-12-31 15:59:30.929 1969-12-31 15:59:30.929 -NULL 1969-12-31 15:59:30.929 1969-12-31 15:59:30.929 -NULL 1969-12-31 15:59:30.929 1969-12-31 15:59:30.929 -NULL 1969-12-31 15:59:43.63 1969-12-31 15:59:43.63 -NULL 1969-12-31 15:59:43.658 1969-12-31 15:59:43.658 -NULL 1969-12-31 15:59:43.672 1969-12-31 15:59:43.672 -NULL 1969-12-31 15:59:43.684 1969-12-31 15:59:43.684 -NULL 1969-12-31 15:59:43.703 1969-12-31 15:59:43.703 -NULL 1969-12-31 15:59:43.704 1969-12-31 15:59:43.704 -NULL 1969-12-31 15:59:43.709 1969-12-31 15:59:43.709 +1969-12-31 15:59:30.929 1969-12-31 15:59:55.451 1969-12-31 15:59:30.929 +1969-12-31 15:59:30.929 1969-12-31 15:59:55.451 1969-12-31 15:59:30.929 +1969-12-31 15:59:30.929 1969-12-31 15:59:58.174 1969-12-31 15:59:30.929 +1969-12-31 15:59:30.929 1969-12-31 15:59:58.456 1969-12-31 15:59:30.929 +1969-12-31 15:59:43.619 1969-12-31 16:00:14.793 1969-12-31 15:59:43.619 +1969-12-31 15:59:43.627 1969-12-31 16:00:03.679 1969-12-31 15:59:43.627 +1969-12-31 15:59:43.628 1969-12-31 15:59:55.451 1969-12-31 15:59:43.628 +1969-12-31 15:59:43.631 1969-12-31 16:00:06.612 1969-12-31 15:59:43.631 +1969-12-31 15:59:43.637 1969-12-31 15:59:58.174 1969-12-31 15:59:43.637 +1969-12-31 15:59:43.64 1969-12-31 15:59:58.174 1969-12-31 15:59:43.64 PREHOOK: query: EXPLAIN VECTORIZATION ONLY EXPRESSION SELECT cfloat, cbigint, coalesce(cfloat, cbigint) as c FROM alltypesorc WHERE (cfloat IS NULL AND cbigint IS NULL) http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_coalesce_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_coalesce_4.q.out b/ql/src/test/results/clientpositive/vector_coalesce_4.q.out index c7c0da6..8cb5ffa 100644 --- a/ql/src/test/results/clientpositive/vector_coalesce_4.q.out +++ b/ql/src/test/results/clientpositive/vector_coalesce_4.q.out @@ -116,5 +116,5 @@ POSTHOOK: query: select coalesce(a, b) from coalesce_test order by a, b POSTHOOK: type: QUERY POSTHOOK: Input: default@coalesce_test #### A masked pattern was here #### -NULL 1 +NULL http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_data_types.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_data_types.q.out b/ql/src/test/results/clientpositive/vector_data_types.q.out index b9d8ac8..a971eed 100644 --- a/ql/src/test/results/clientpositive/vector_data_types.q.out +++ b/ql/src/test/results/clientpositive/vector_data_types.q.out @@ -169,10 +169,6 @@ POSTHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_ POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc_n1 #### A masked pattern was here #### -NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics -NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history -NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.80 mathematics -3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided -3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing -3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education @@ -189,6 +185,10 @@ NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703 -2 461 65648 4294967425 58.52 24.85 false rachel thompson 2013-03-01 09:11:58.703318 85.62 zync studies -1 268 65778 4294967418 56.33 44.73 true calvin falkner 2013-03-01 09:11:58.70322 7.37 history -1 281 65643 4294967323 15.1 45.0 false irene nixon 2013-03-01 09:11:58.703223 80.96 undecided +-1 300 65663 4294967343 71.26 34.62 true calvin ovid 2013-03-01 09:11:58.703262 78.56 study skills +-1 348 65556 4294967413 35.17 9.51 false bob young 2013-03-01 09:11:58.70328 45.81 quiet hour +-1 372 65680 4294967490 15.45 18.09 false ethan laertes 2013-03-01 09:11:58.70311 65.88 opthamology +-1 417 65685 4294967492 28.89 5.19 true mike white 2013-03-01 09:11:58.703275 90.69 forestry PREHOOK: query: SELECT SUM(HASH(*)) FROM (SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i) as q PREHOOK: type: QUERY @@ -284,10 +284,6 @@ POSTHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_ POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc_n1 #### A masked pattern was here #### -NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics -NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history -NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.80 mathematics -3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided -3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing -3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education @@ -304,6 +300,10 @@ NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703 -2 461 65648 4294967425 58.52 24.85 false rachel thompson 2013-03-01 09:11:58.703318 85.62 zync studies -1 268 65778 4294967418 56.33 44.73 true calvin falkner 2013-03-01 09:11:58.70322 7.37 history -1 281 65643 4294967323 15.1 45.0 false irene nixon 2013-03-01 09:11:58.703223 80.96 undecided +-1 300 65663 4294967343 71.26 34.62 true calvin ovid 2013-03-01 09:11:58.703262 78.56 study skills +-1 348 65556 4294967413 35.17 9.51 false bob young 2013-03-01 09:11:58.70328 45.81 quiet hour +-1 372 65680 4294967490 15.45 18.09 false ethan laertes 2013-03-01 09:11:58.70311 65.88 opthamology +-1 417 65685 4294967492 28.89 5.19 true mike white 2013-03-01 09:11:58.703275 90.69 forestry PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT SUM(HASH(*)) FROM (SELECT t, si, i, b, f, d, bo, s, ts, `dec`, bin FROM over1korc_n1 ORDER BY t, si, i) as q http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_date_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_date_1.q.out b/ql/src/test/results/clientpositive/vector_date_1.q.out index c2e9e5d..06b0540 100644 --- a/ql/src/test/results/clientpositive/vector_date_1.q.out +++ b/ql/src/test/results/clientpositive/vector_date_1.q.out @@ -58,9 +58,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_date_1 #### A masked pattern was here #### vector_date_1.dt1 vector_date_1.dt2 -NULL NULL 1999-12-31 2000-01-01 2001-01-01 2001-06-01 +NULL NULL PREHOOK: query: explain vectorization detail select dt1, dt2, @@ -197,9 +197,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_date_1 #### A masked pattern was here #### dt1 dt2 _c2 _c3 _c4 _c5 _c6 _c7 _c8 _c9 -NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1999-12-31 2000-01-01 true true true true true true true true 2001-01-01 2001-06-01 true true true true true true true true +NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain vectorization detail select dt1, dt2, @@ -336,9 +336,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_date_1 #### A masked pattern was here #### dt1 dt2 _c2 _c3 _c4 _c5 _c6 _c7 _c8 _c9 -NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1999-12-31 2000-01-01 false false false false false false false false 2001-01-01 2001-06-01 false false false false false false false false +NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain vectorization detail select dt1, @@ -475,9 +475,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_date_1 #### A masked pattern was here #### dt1 _c1 _c2 _c3 _c4 _c5 _c6 _c7 _c8 -NULL NULL NULL NULL NULL NULL NULL NULL NULL 1999-12-31 true true true true true true true true 2001-01-01 true true true true true true true true +NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain vectorization detail select dt1, @@ -614,9 +614,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_date_1 #### A masked pattern was here #### dt1 _c1 _c2 _c3 _c4 _c5 _c6 _c7 _c8 -NULL NULL NULL NULL NULL NULL NULL NULL NULL 1999-12-31 false false false false false false false false 2001-01-01 false false false false false false false false +NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain vectorization detail select dt1, dt2 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_decimal_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_1.q.out b/ql/src/test/results/clientpositive/vector_decimal_1.q.out index e616912..726ff91 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_1.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_1.q.out @@ -132,8 +132,8 @@ POSTHOOK: query: select cast(t as boolean) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL true +NULL PREHOOK: query: explain vectorization detail select cast(t as tinyint) from decimal_1 order by t PREHOOK: type: QUERY @@ -223,8 +223,8 @@ POSTHOOK: query: select cast(t as tinyint) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17 +NULL PREHOOK: query: explain vectorization detail select cast(t as smallint) from decimal_1 order by t PREHOOK: type: QUERY @@ -314,8 +314,8 @@ POSTHOOK: query: select cast(t as smallint) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17 +NULL PREHOOK: query: explain vectorization detail select cast(t as int) from decimal_1 order by t PREHOOK: type: QUERY @@ -405,8 +405,8 @@ POSTHOOK: query: select cast(t as int) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17 +NULL PREHOOK: query: explain vectorization detail select cast(t as bigint) from decimal_1 order by t PREHOOK: type: QUERY @@ -496,8 +496,8 @@ POSTHOOK: query: select cast(t as bigint) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17 +NULL PREHOOK: query: explain vectorization detail select cast(t as float) from decimal_1 order by t PREHOOK: type: QUERY @@ -587,8 +587,8 @@ POSTHOOK: query: select cast(t as float) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17.29 +NULL PREHOOK: query: explain vectorization detail select cast(t as double) from decimal_1 order by t PREHOOK: type: QUERY @@ -678,8 +678,8 @@ POSTHOOK: query: select cast(t as double) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17.29 +NULL PREHOOK: query: explain vectorization detail select cast(t as string) from decimal_1 order by t PREHOOK: type: QUERY @@ -769,8 +769,8 @@ POSTHOOK: query: select cast(t as string) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 17.29 +NULL PREHOOK: query: explain vectorization detail select cast(t as timestamp) from decimal_1 order by t PREHOOK: type: QUERY @@ -860,8 +860,8 @@ POSTHOOK: query: select cast(t as timestamp) from decimal_1 order by t POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_1 #### A masked pattern was here #### -NULL 1970-01-01 00:00:17.29 +NULL PREHOOK: query: drop table decimal_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_1 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_decimal_10_0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_10_0.q.out b/ql/src/test/results/clientpositive/vector_decimal_10_0.q.out index 6526abe..c53c0b1 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_10_0.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_10_0.q.out @@ -121,8 +121,8 @@ POSTHOOK: query: SELECT `dec` FROM `DECIMAL` order by `dec` POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal #### A masked pattern was here #### -NULL 1000000000 +NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT `dec` FROM `decimal_txt` order by `dec` PREHOOK: type: QUERY @@ -211,8 +211,8 @@ POSTHOOK: query: SELECT `dec` FROM `decimal_txt` order by `dec` POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_txt #### A masked pattern was here #### -NULL 1000000000 +NULL PREHOOK: query: DROP TABLE DECIMAL_txt PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_txt http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_decimal_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_3.q.out b/ql/src/test/results/clientpositive/vector_decimal_3.q.out index 3e9a1ee..b292c9a 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_3.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_3.q.out @@ -48,7 +48,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3_n1 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3_n1 #### A masked pattern was here #### -NULL 0 -1234567890.123456789000000000 -1234567890 -4400.000000000000000000 4400 -1255.490000000000000000 -1255 @@ -86,6 +85,7 @@ NULL 0 125.200000000000000000 125 200.000000000000000000 200 1234567890.123456780000000000 1234567890 +NULL 0 PREHOOK: query: SELECT * FROM DECIMAL_3_n1 ORDER BY key DESC, value DESC PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3_n1 @@ -140,7 +140,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3_n1 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3_n1 #### A masked pattern was here #### -NULL 0 -1234567890.123456789000000000 -1234567890 -4400.000000000000000000 4400 -1255.490000000000000000 -1255 @@ -178,6 +177,7 @@ NULL 0 125.200000000000000000 125 200.000000000000000000 200 1234567890.123456780000000000 1234567890 +NULL 0 PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3_n1 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3_n1 @@ -186,7 +186,6 @@ POSTHOOK: query: SELECT DISTINCT key FROM DECIMAL_3_n1 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3_n1 #### A masked pattern was here #### -NULL -1234567890.123456789000000000 -4400.000000000000000000 -1255.490000000000000000 @@ -215,6 +214,7 @@ NULL 125.200000000000000000 200.000000000000000000 1234567890.123456780000000000 +NULL PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3_n1 GROUP BY key ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3_n1 @@ -223,7 +223,6 @@ POSTHOOK: query: SELECT key, sum(value) FROM DECIMAL_3_n1 GROUP BY key ORDER BY POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3_n1 #### A masked pattern was here #### -NULL 0 -1234567890.123456789000000000 -1234567890 -4400.000000000000000000 4400 -1255.490000000000000000 -1255 @@ -252,6 +251,7 @@ NULL 0 125.200000000000000000 125 200.000000000000000000 200 1234567890.123456780000000000 1234567890 +NULL 0 PREHOOK: query: SELECT value, sum(key) FROM DECIMAL_3_n1 GROUP BY value ORDER BY value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3_n1 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_decimal_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_4.q.out b/ql/src/test/results/clientpositive/vector_decimal_4.q.out index d365fb9..fc18645 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_4.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_4.q.out @@ -56,7 +56,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_4_1_n0 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_1_n0 #### A masked pattern was here #### -NULL 0 -1234567890.1234567890000000000000000 -1234567890 -4400.0000000000000000000000000 4400 -1255.4900000000000000000000000 -1255 @@ -94,6 +93,7 @@ NULL 0 125.2000000000000000000000000 125 200.0000000000000000000000000 200 1234567890.1234567800000000000000000 1234567890 +NULL 0 PREHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2_n0 @@ -102,7 +102,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2_n0 #### A masked pattern was here #### -NULL NULL -1234567890.1234567890000000000000000 -3703703670.3703703670000000000000000 -4400.0000000000000000000000000 -13200.0000000000000000000000000 -1255.4900000000000000000000000 -3766.4700000000000000000000000 @@ -140,6 +139,7 @@ NULL NULL 125.2000000000000000000000000 375.6000000000000000000000000 200.0000000000000000000000000 600.0000000000000000000000000 1234567890.1234567800000000000000000 3703703670.3703703400000000000000000 +NULL NULL PREHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2_n0 @@ -148,7 +148,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2_n0 #### A masked pattern was here #### -NULL NULL -1234567890.1234567890000000000000000 -3703703670.3703703670000000000000000 -4400.0000000000000000000000000 -13200.0000000000000000000000000 -1255.4900000000000000000000000 -3766.4700000000000000000000000 @@ -186,6 +185,7 @@ NULL NULL 125.2000000000000000000000000 375.6000000000000000000000000 200.0000000000000000000000000 600.0000000000000000000000000 1234567890.1234567800000000000000000 3703703670.3703703400000000000000000 +NULL NULL PREHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2_n0 @@ -194,7 +194,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2_n0 #### A masked pattern was here #### -NULL NULL -1234567890.1234567890000000000000000 -3703703670.3703703670000000000000000 -4400.0000000000000000000000000 -13200.0000000000000000000000000 -1255.4900000000000000000000000 -3766.4700000000000000000000000 @@ -232,6 +231,7 @@ NULL NULL 125.2000000000000000000000000 375.6000000000000000000000000 200.0000000000000000000000000 600.0000000000000000000000000 1234567890.1234567800000000000000000 3703703670.3703703400000000000000000 +NULL NULL PREHOOK: query: DROP TABLE DECIMAL_4_1_n0 PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_4_1_n0 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_decimal_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_5.q.out b/ql/src/test/results/clientpositive/vector_decimal_5.q.out index a2e114b..25a16cf 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_5.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_5.q.out @@ -56,9 +56,6 @@ POSTHOOK: query: SELECT key FROM DECIMAL_5 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_5 #### A masked pattern was here #### -NULL -NULL -NULL -4400.00000 -1255.49000 -1.12200 @@ -94,6 +91,9 @@ NULL 124.00000 125.20000 200.00000 +NULL +NULL +NULL PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_5 @@ -102,7 +102,6 @@ POSTHOOK: query: SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_5 #### A masked pattern was here #### -NULL -4400.00000 -1255.49000 -1.12200 @@ -129,6 +128,7 @@ NULL 124.00000 125.20000 200.00000 +NULL PREHOOK: query: explain SELECT cast(key as decimal) FROM DECIMAL_5 PREHOOK: type: QUERY POSTHOOK: query: explain SELECT cast(key as decimal) FROM DECIMAL_5 http://git-wip-us.apache.org/repos/asf/hive/blob/0427ffa5/ql/src/test/results/clientpositive/vector_decimal_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_6.q.out b/ql/src/test/results/clientpositive/vector_decimal_6.q.out index 445896b..ab92ba1 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_6.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_6.q.out @@ -194,11 +194,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_6_1 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_6_1 #### A masked pattern was here #### -NULL -1234567890 -NULL 0 -NULL 3 -NULL 4 -NULL 1234567890 -4400.00000 4400 -1255.49000 -1255 -1.12200 -11 @@ -221,6 +216,11 @@ NULL 1234567890 124.00000 124 125.20000 125 23232.23435 2 +NULL -1234567890 +NULL 0 +NULL 3 +NULL 4 +NULL 1234567890 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT * FROM DECIMAL_6_2 ORDER BY key, value PREHOOK: type: QUERY @@ -309,7 +309,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_6_2 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_6_2 #### A masked pattern was here #### -NULL 0 -1234567890.1235 -1234567890 -4400.0000 4400 -1255.4900 -1255 @@ -336,6 +335,7 @@ NULL 0 2389432.2375 3 2389432.2375 4 1234567890.1235 1234567890 +NULL 0 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT T.key from ( SELECT key, value from DECIMAL_6_1 @@ -432,12 +432,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_6_1 POSTHOOK: Input: default@decimal_6_2 #### A masked pattern was here #### -NULL -NULL -NULL -NULL -NULL -NULL -1234567890.12350 -4400.00000 -4400.00000 @@ -486,6 +480,12 @@ NULL 2389432.23750 2389432.23750 1234567890.12350 +NULL +NULL +NULL +NULL +NULL +NULL PREHOOK: query: EXPLAIN VECTORIZATION DETAIL CREATE TABLE DECIMAL_6_3 STORED AS ORC AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v PREHOOK: type: CREATETABLE_AS_SELECT @@ -612,11 +612,6 @@ POSTHOOK: query: SELECT * FROM DECIMAL_6_3 ORDER BY k, v POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_6_3 #### A masked pattern was here #### -NULL -695344902 -NULL 0 -NULL 33 -NULL 44 -NULL 695344902 -4394.50000 48400 -1249.99000 -13805 4.37800 -121 @@ -639,3 +634,8 @@ NULL 695344902 129.50000 1364 130.70000 1375 23237.73435 22 +NULL -695344902 +NULL 0 +NULL 33 +NULL 44 +NULL 695344902
