Repository: hive Updated Branches: refs/heads/master 35f86c749 -> 499d01a38
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out b/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out index 4da63b1..fc7ad07 100644 --- a/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out +++ b/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out @@ -253,7 +253,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3179 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 @@ -264,7 +264,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:timestam p, IfExprNullColumn(col 0:boolean, null, col 3)(children: col 0:boolean, col 3:timestamp) -> 17:timestamp - Statistics: Num rows: 52 Data size: 3179 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: + @@ -273,7 +273,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 52 Data size: 3179 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: @@ -293,10 +293,10 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: boolean), VALUE._col8 (type: timestamp), VALUE._col9 (type: timestamp), VALUE._col10 (type: timestamp), VALUE._col11 (type: timestamp), VALUE._col12 (type: timestamp), VALUE._col13 (type: timestamp), VALUE._col14 (type: timestamp) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16 - Statistics: Num rows: 52 Data size: 3179 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 52 Data size: 3179 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 @@ -354,6 +354,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 @@ -363,47 +403,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:44.028 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:44.028 NULL 1969-12-31 15:59:44.028 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:44.809 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:44.809 NULL 1969-12-31 15:59:44.809 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:45.949 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:45.949 NULL 1969-12-31 15:59:45.949 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:50.531 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:50.531 NULL 1969-12-31 15:59:50.531 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:51.009 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:51.009 NULL 1969-12-31 15:59:51.009 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 15:59:53.761 1319-02-02 16:31:57.778 NULL 1969-12-31 15:59:53.761 NULL 1969-12-31 15:59:53.761 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:00.905 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:00.905 NULL 1969-12-31 16:00:00.905 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:03.586 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:03.586 NULL 1969-12-31 16:00:03.586 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:05.227 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:05.227 NULL 1969-12-31 16:00:05.227 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:05.535 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:05.535 NULL 1969-12-31 16:00:05.535 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:07.02 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:07.02 NULL 1969-12-31 16:00:07.02 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:07.365 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:07.365 NULL 1969-12-31 16:00:07.365 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:07.517 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:07.517 NULL 1969-12-31 16:00:07.517 -NULL NULL NULL NULL NULL NULL NULL NULL NULL false NULL 1969-12-31 16:00:07.767 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:07.767 NULL 1969-12-31 16:00:07.767 -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:09.938 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:09.938 NULL 1969-12-31 16:00:09.938 -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:14.783 1319-02-02 16:31:57.778 NULL 1969-12-31 16:00:14.783 NULL 1969-12-31 16:00:14.783 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 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:43.773 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:44.262 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:44.568 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:45.697 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:47.351 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:47.446 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:48.023 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:48.629 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.177 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.208 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:50.789 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.245 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.372 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.249 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.661 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.784 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:09.313 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:09.538 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:09.986 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.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 16:00:11.465 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 @@ -446,7 +446,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3179 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 @@ -457,7 +457,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: CastStringToTimestamp(col 2:string) -> 12:timestamp) -> 10:int, VectorUDFMinuteTimestamp(col 12:timestamp, field MINUTE)(children: CastStringToTimestamp(col 2:string) -> 12:timestamp) -> 13:int, VectorUDFSecondTimestamp(col 12:timestamp, field SECOND)(children: CastStringToTimestamp(col 2:string) -> 12:timestamp) -> 14:int - Statistics: Num rows: 52 Data size: 3179 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: + @@ -466,7 +466,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 52 Data size: 3179 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: @@ -486,10 +486,10 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 - Statistics: Num rows: 52 Data size: 3179 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 52 Data size: 3179 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 @@ -531,7 +531,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 @@ -543,46 +583,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), @@ -623,7 +623,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3179 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 @@ -634,7 +634,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:in t)(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: CastStringToTimestamp(col 2:string) -> 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: CastStringToTimestamp(col 2:string) -> 13:timestamp) -> 12:int) -> 15:boolean, LongColE qualLongColumn(col 5:int, col 12:int)(children: VectorUDFSecondTimestamp(col 1:timestamp, field SECOND) -> 5:int, VectorUDFSecondTimestamp(col 13:timestamp, field SECOND)(children: CastStringToTimestamp(col 2:string) -> 13:timestamp) -> 12:int) -> 16:boolean - Statistics: Num rows: 52 Data size: 3179 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: + @@ -643,7 +643,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 52 Data size: 3179 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: @@ -663,10 +663,10 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: boolean), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 - Statistics: Num rows: 52 Data size: 3179 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 52 Data size: 8979 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 52 Data size: 3179 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 @@ -716,50 +716,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), @@ -916,7 +916,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3179 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 @@ -926,7 +926,7 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [1] - Statistics: Num rows: 52 Data size: 3179 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: @@ -1000,7 +1000,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 @@ -1023,7 +1023,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3179 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 @@ -1033,7 +1033,7 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [1] - Statistics: Num rows: 52 Data size: 3179 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: @@ -1105,7 +1105,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, @@ -1142,7 +1142,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: alltypesorc_string - Statistics: Num rows: 52 Data size: 3179 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 @@ -1153,7 +1153,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: 3179 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: @@ -1239,4 +1239,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/499d01a3/ql/src/test/results/clientpositive/windowing_gby2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_gby2.q.out b/ql/src/test/results/clientpositive/windowing_gby2.q.out index 670c701..f5018d9 100644 --- a/ql/src/test/results/clientpositive/windowing_gby2.q.out +++ b/ql/src/test/results/clientpositive/windowing_gby2.q.out @@ -79,7 +79,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: 0 raw input shape: window functions: @@ -122,11 +122,11 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@cbo_t3 #### A masked pattern was here #### 1 -2 -2 -2 -5 -5 +1 +1 +4 +4 +6 7 PREHOOK: query: explain select avg(cast(ws.key as int)) over (partition by min(ws.value) order by sum(ws.c_int)) as return_rank @@ -206,7 +206,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col2 ASC NULLS FIRST + order by: _col2 ASC NULLS LAST partition by: _col1 raw input shape: window functions: @@ -614,7 +614,7 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: (UDFToDouble(_col1) / UDFToDouble(_col2)) ASC NULLS FIRST + order by: (UDFToDouble(_col1) / UDFToDouble(_col2)) ASC NULLS LAST partition by: 0 raw input shape: window functions: http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/windowing_navfn.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_navfn.q.out b/ql/src/test/results/clientpositive/windowing_navfn.q.out index 8c73534..ff97483 100644 --- a/ql/src/test/results/clientpositive/windowing_navfn.q.out +++ b/ql/src/test/results/clientpositive/windowing_navfn.q.out @@ -731,11 +731,11 @@ POSTHOOK: Input: default@wtest_n0 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL -2 NULL NULL NULL NULL NULL -2 NULL NULL 1 NULL 1 -2 1 NULL 1 NULL 1 -2 2 1 1 NULL 1 -2 3 2 2 NULL 1 +2 1 1 1 1 1 +2 2 1 1 1 1 +2 3 2 2 1 1 +2 NULL 3 3 1 1 +2 NULL NULL NULL 1 1 3 1 1 1 1 1 3 2 1 1 1 1 3 3 2 2 1 1 @@ -797,11 +797,11 @@ POSTHOOK: Input: default@wtest_n0 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL -2 NULL NULL NULL NULL NULL -2 NULL 1 1 1 1 2 1 2 2 2 2 2 2 3 3 3 3 -2 3 3 3 3 3 +2 3 NULL 3 NULL 3 +2 NULL NULL 3 NULL 3 +2 NULL NULL NULL NULL 3 3 1 2 2 2 2 3 2 3 3 3 3 3 3 4 4 4 4 http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/windowing_order_null.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_order_null.q.out b/ql/src/test/results/clientpositive/windowing_order_null.q.out index 2bda769..c34330b 100644 --- a/ql/src/test/results/clientpositive/windowing_order_null.q.out +++ b/ql/src/test/results/clientpositive/windowing_order_null.q.out @@ -80,13 +80,13 @@ POSTHOOK: Input: default@over10k #### A masked pattern was here #### NULL alice ichabod NULL NULL NULL calvin miller NULL NULL -0.01 NULL NULL NULL -0.01 NULL NULL NULL 0.01 calvin miller 8.39 8.390000343322754 -0.02 NULL NULL NULL +0.01 NULL NULL 8.390000343322754 +0.01 NULL NULL 8.390000343322754 0.02 holly polk 5.29 5.289999961853027 0.02 wendy quirinius 25.5 30.789999961853027 0.02 yuri laertes 37.59 68.38000011444092 +0.02 NULL NULL 68.38000011444092 0.03 nick steinbeck 79.24 79.23999786376953 PREHOOK: query: select ts, s, f, sum(f) over (partition by ts order by f asc nulls first range between current row and unbounded following) from over10k limit 10 PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/windowing_streaming.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_streaming.q.out b/ql/src/test/results/clientpositive/windowing_streaming.q.out index 4260948..0f2ac4a 100644 --- a/ql/src/test/results/clientpositive/windowing_streaming.q.out +++ b/ql/src/test/results/clientpositive/windowing_streaming.q.out @@ -83,7 +83,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: @@ -155,7 +155,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: @@ -355,7 +355,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: _col0 raw input shape: window functions: @@ -417,48 +417,10 @@ where ctinyint is null POSTHOOK: type: QUERY POSTHOOK: Input: default@sb_n0 #### A masked pattern was here #### -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 +NULL -16379.0 1 +NULL -16310.0 2 +NULL -16309.0 3 +NULL -16307.0 4 PREHOOK: query: drop table if exists sD_n0 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table if exists sD_n0 @@ -488,45 +450,7 @@ where ctinyint is null POSTHOOK: type: QUERY POSTHOOK: Input: default@sd_n0 #### A masked pattern was here #### -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 -NULL NULL 1 +NULL -16379.0 1 +NULL -16310.0 2 +NULL -16309.0 3 +NULL -16307.0 4 http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/windowing_windowspec3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/windowing_windowspec3.q.out b/ql/src/test/results/clientpositive/windowing_windowspec3.q.out index 7dbb275..440c1e5 100644 --- a/ql/src/test/results/clientpositive/windowing_windowspec3.q.out +++ b/ql/src/test/results/clientpositive/windowing_windowspec3.q.out @@ -86,11 +86,11 @@ from emp_n0 POSTHOOK: type: QUERY POSTHOOK: Input: default@emp_n0 #### A masked pattern was here #### -10 7988 NULL 1500.0 3000.0 3000.0 NULL NULL 8750.0 3000.0 -10 7987 NULL 1500.0 3000.0 3000.0 NULL NULL 8750.0 3000.0 -10 7782 1981-06-09 2450.0 2450.0 2450.0 NULL NULL 6300.0 5450.0 -10 7839 1981-11-17 5000.0 5000.0 6300.0 NULL 1300.0 1300.0 10450.0 -10 7934 1982-01-23 1300.0 6300.0 6300.0 5000.0 NULL NULL 11750.0 +10 7782 1981-06-09 2450.0 2450.0 2450.0 NULL NULL 9300.0 2450.0 +10 7839 1981-11-17 5000.0 5000.0 6300.0 NULL 1300.0 4300.0 7450.0 +10 7934 1982-01-23 1300.0 6300.0 6300.0 5000.0 NULL 3000.0 8750.0 +10 7988 NULL 1500.0 3000.0 3000.0 3000.0 NULL NULL 11750.0 +10 7987 NULL 1500.0 3000.0 3000.0 3000.0 NULL NULL 11750.0 20 7369 1980-12-17 800.0 800.0 800.0 NULL NULL 10075.0 800.0 20 7566 1981-04-02 2975.0 2975.0 2975.0 NULL NULL 7100.0 3775.0 20 7902 1981-12-03 3000.0 3000.0 3000.0 NULL NULL 4100.0 6775.0 @@ -124,11 +124,11 @@ from emp_n0 POSTHOOK: type: QUERY POSTHOOK: Input: default@emp_n0 #### A masked pattern was here #### -10 7988 NULL 1500.0 3000.0 3000.0 NULL NULL 8750.0 3000.0 -10 7987 NULL 1500.0 3000.0 3000.0 NULL NULL 8750.0 3000.0 -10 7782 1981-06-09 00:00:00 2450.0 2450.0 2450.0 NULL NULL 6300.0 5450.0 -10 7839 1981-11-17 00:00:00 5000.0 5000.0 6300.0 NULL 1300.0 1300.0 10450.0 -10 7934 1982-01-23 00:00:00 1300.0 6300.0 6300.0 5000.0 NULL NULL 11750.0 +10 7782 1981-06-09 00:00:00 2450.0 2450.0 2450.0 NULL NULL 9300.0 2450.0 +10 7839 1981-11-17 00:00:00 5000.0 5000.0 6300.0 NULL 1300.0 4300.0 7450.0 +10 7934 1982-01-23 00:00:00 1300.0 6300.0 6300.0 5000.0 NULL 3000.0 8750.0 +10 7988 NULL 1500.0 3000.0 3000.0 3000.0 NULL NULL 11750.0 +10 7987 NULL 1500.0 3000.0 3000.0 3000.0 NULL NULL 11750.0 20 7369 1980-12-17 00:00:00 800.0 800.0 800.0 NULL NULL 10075.0 800.0 20 7566 1981-04-02 00:00:00 2975.0 2975.0 2975.0 NULL NULL 7100.0 3775.0 20 7902 1981-12-03 00:00:00 3000.0 3000.0 3000.0 NULL NULL 4100.0 6775.0 @@ -172,12 +172,12 @@ POSTHOOK: Input: default@emp_n0 20 7876 NULL NULL NULL NULL NULL NULL NULL 20 7566 NULL NULL NULL NULL NULL NULL NULL 20 7369 NULL NULL NULL NULL NULL NULL NULL -30 7698 NULL NULL NULL NULL NULL 550.0 NULL -30 7900 NULL NULL NULL NULL NULL 550.0 NULL 30 7844 0.0 0.0 0.0 NULL NULL 733.3333333333334 0.0 30 7499 300.0 300.0 400.0 NULL 500.0 1400.0 266.6666666666667 30 7521 500.0 400.0 400.0 300.0 NULL 1400.0 266.6666666666667 30 7654 1400.0 1400.0 1400.0 NULL NULL NULL 550.0 +30 7698 NULL NULL NULL NULL NULL NULL 550.0 +30 7900 NULL NULL NULL NULL NULL NULL 550.0 PREHOOK: query: select deptno, empno, stock, salary, avg(salary) over (partition by deptno order by stock range 200 preceding), avg(salary) over (partition by deptno order by stock range between 200 preceding and 200 following), @@ -200,19 +200,19 @@ from emp_n0 POSTHOOK: type: QUERY POSTHOOK: Input: default@emp_n0 #### A masked pattern was here #### -10 7839 NULL 5000.0 5000.0 5000.0 NULL NULL 1687.5 5000.0 -10 7782 50.00 2450.0 2450.0 1687.5 NULL 1500.0 NULL 2350.0 -10 7934 100.00 1300.0 1875.0 1687.5 NULL NULL NULL 2350.0 -10 7987 150.50 1500.0 1750.0 1687.5 NULL NULL NULL 2350.0 -10 7988 200.00 1500.0 1687.5 1687.5 2450.0 NULL NULL 2350.0 -20 7788 NULL 3000.0 1975.0 1975.0 NULL NULL 2975.0 1975.0 -20 7902 NULL 3000.0 1975.0 1975.0 NULL NULL 2975.0 1975.0 -20 7876 NULL 1100.0 1975.0 1975.0 NULL NULL 2975.0 1975.0 -20 7369 NULL 800.0 1975.0 1975.0 NULL NULL 2975.0 1975.0 -20 7566 100.00 2975.0 2975.0 2975.0 NULL NULL NULL 2175.0 -30 7900 NULL 950.0 1900.0 1900.0 NULL NULL 1400.0 1900.0 -30 7698 NULL 2850.0 1900.0 1900.0 NULL NULL 1400.0 1900.0 -30 7499 200.50 1600.0 1600.0 1450.0 NULL NULL 1250.0 1630.0 -30 7844 300.00 1500.0 1550.0 1400.0 NULL 1250.0 NULL 1566.6666666666667 -30 7521 300.50 1250.0 1450.0 1400.0 NULL 1250.0 NULL 1566.6666666666667 -30 7654 500.00 1250.0 1333.3333333333333 1333.3333333333333 1375.0 NULL NULL 1566.6666666666667 +10 7782 50.00 2450.0 2450.0 1687.5 NULL 1500.0 5000.0 1687.5 +10 7934 100.00 1300.0 1875.0 1687.5 NULL NULL 5000.0 1687.5 +10 7987 150.50 1500.0 1750.0 1687.5 NULL NULL 5000.0 1687.5 +10 7988 200.00 1500.0 1687.5 1687.5 2450.0 NULL 5000.0 1687.5 +10 7839 NULL 5000.0 5000.0 5000.0 5000.0 NULL NULL 2350.0 +20 7566 100.00 2975.0 2975.0 2975.0 NULL NULL 1975.0 2975.0 +20 7788 NULL 3000.0 1975.0 1975.0 1975.0 NULL NULL 2175.0 +20 7902 NULL 3000.0 1975.0 1975.0 1975.0 NULL NULL 2175.0 +20 7876 NULL 1100.0 1975.0 1975.0 1975.0 NULL NULL 2175.0 +20 7369 NULL 800.0 1975.0 1975.0 1975.0 NULL NULL 2175.0 +30 7499 200.50 1600.0 1600.0 1450.0 NULL NULL 1683.3333333333333 1450.0 +30 7844 300.00 1500.0 1550.0 1400.0 NULL 1250.0 1900.0 1400.0 +30 7521 300.50 1250.0 1450.0 1400.0 NULL 1250.0 1900.0 1400.0 +30 7654 500.00 1250.0 1333.3333333333333 1333.3333333333333 1375.0 NULL 1900.0 1400.0 +30 7698 NULL 2850.0 1900.0 1900.0 1900.0 NULL NULL 1566.6666666666667 +30 7900 NULL 950.0 1900.0 1900.0 1900.0 NULL NULL 1566.6666666666667