http://git-wip-us.apache.org/repos/asf/hive/blob/ae008b79/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out b/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out index af5815f..2fadf29 100644 --- a/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_interval_arithmetic.q.out @@ -175,7 +175,7 @@ POSTHOOK: Input: default@interval_arithmetic_1 dateval _c1 _c2 _c3 _c4 _c5 _c6 0004-09-22 0002-07-22 0006-11-22 0006-11-22 0002-07-22 0002-07-22 0006-11-22 0528-10-27 0526-08-27 0530-12-27 0530-12-27 0526-08-27 0526-08-27 0530-12-27 -1319-02-02 1316-12-02 1321-04-02 1321-04-02 1316-12-02 1316-12-02 1321-04-02 +1319-02-02 1316-12-03 1321-04-02 1321-04-02 1316-12-03 1316-12-03 1321-04-02 1404-07-23 1402-05-23 1406-09-23 1406-09-23 1402-05-23 1402-05-23 1406-09-23 1815-05-06 1813-03-06 1817-07-06 1817-07-06 1813-03-06 1813-03-06 1817-07-06 1883-04-17 1881-02-17 1885-06-17 1885-06-17 1881-02-17 1881-02-17 1885-06-17 @@ -272,7 +272,7 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [0, 3, 4, 5] - selectExpressions: DateColSubtractDateScalar(col 0:date, val 1999-06-07 00:00:00.0) -> 3:interval_day_time, DateScalarSubtractDateColumn(val 1999-06-07 00:00:00.0, col 0:date) -> 4:interval_day_time, DateColSubtractDateColumn(col 0:date, col 0:date) -> 5:interval_day_time + selectExpressions: DateColSubtractDateScalar(col 0:date, val 1999-06-07) -> 3:interval_day_time, DateScalarSubtractDateColumn(val 1999-06-07, col 0:date) -> 4:interval_day_time, DateColSubtractDateColumn(col 0:date, col 0:date) -> 5:interval_day_time Statistics: Num rows: 50 Data size: 2744 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: date) @@ -349,56 +349,56 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### dateval _c1 _c2 _c3 -0004-09-22 -728552 23:00:00.000000000 728552 23:00:00.000000000 0 00:00:00.000000000 -0528-10-27 -537126 23:00:00.000000000 537126 23:00:00.000000000 0 00:00:00.000000000 -1319-02-02 -248481 23:00:00.000000000 248481 23:00:00.000000000 0 00:00:00.000000000 -1404-07-23 -217263 23:00:00.000000000 217263 23:00:00.000000000 0 00:00:00.000000000 -1815-05-06 -67236 23:00:00.000000000 67236 23:00:00.000000000 0 00:00:00.000000000 -1883-04-17 -42418 23:00:00.000000000 42418 23:00:00.000000000 0 00:00:00.000000000 +0004-09-22 -728551 00:00:00.000000000 728551 00:00:00.000000000 0 00:00:00.000000000 +0528-10-27 -537129 00:00:00.000000000 537129 00:00:00.000000000 0 00:00:00.000000000 +1319-02-02 -248490 00:00:00.000000000 248490 00:00:00.000000000 0 00:00:00.000000000 +1404-07-23 -217273 00:00:00.000000000 217273 00:00:00.000000000 0 00:00:00.000000000 +1815-05-06 -67237 00:00:00.000000000 67237 00:00:00.000000000 0 00:00:00.000000000 +1883-04-17 -42419 00:00:00.000000000 42419 00:00:00.000000000 0 00:00:00.000000000 1966-08-16 -11983 00:00:00.000000000 11983 00:00:00.000000000 0 00:00:00.000000000 -1973-04-17 -9546 23:00:00.000000000 9546 23:00:00.000000000 0 00:00:00.000000000 +1973-04-17 -9547 00:00:00.000000000 9547 00:00:00.000000000 0 00:00:00.000000000 1974-10-04 -9012 00:00:00.000000000 9012 00:00:00.000000000 0 00:00:00.000000000 -1976-03-03 -8495 23:00:00.000000000 8495 23:00:00.000000000 0 00:00:00.000000000 +1976-03-03 -8496 00:00:00.000000000 8496 00:00:00.000000000 0 00:00:00.000000000 1976-05-06 -8432 00:00:00.000000000 8432 00:00:00.000000000 0 00:00:00.000000000 1978-08-05 -7611 00:00:00.000000000 7611 00:00:00.000000000 0 00:00:00.000000000 -1981-04-25 -6616 23:00:00.000000000 6616 23:00:00.000000000 0 00:00:00.000000000 -1981-11-15 -6412 23:00:00.000000000 6412 23:00:00.000000000 0 00:00:00.000000000 +1981-04-25 -6617 00:00:00.000000000 6617 00:00:00.000000000 0 00:00:00.000000000 +1981-11-15 -6413 00:00:00.000000000 6413 00:00:00.000000000 0 00:00:00.000000000 1985-07-20 -5070 00:00:00.000000000 5070 00:00:00.000000000 0 00:00:00.000000000 -1985-11-18 -4948 23:00:00.000000000 4948 23:00:00.000000000 0 00:00:00.000000000 -1987-02-21 -4488 23:00:00.000000000 4488 23:00:00.000000000 0 00:00:00.000000000 +1985-11-18 -4949 00:00:00.000000000 4949 00:00:00.000000000 0 00:00:00.000000000 +1987-02-21 -4489 00:00:00.000000000 4489 00:00:00.000000000 0 00:00:00.000000000 1987-05-28 -4393 00:00:00.000000000 4393 00:00:00.000000000 0 00:00:00.000000000 1998-10-16 -234 00:00:00.000000000 234 00:00:00.000000000 0 00:00:00.000000000 1999-10-03 118 00:00:00.000000000 -118 00:00:00.000000000 0 00:00:00.000000000 -2000-12-18 560 01:00:00.000000000 -560 01:00:00.000000000 0 00:00:00.000000000 +2000-12-18 560 00:00:00.000000000 -560 00:00:00.000000000 0 00:00:00.000000000 2002-05-10 1068 00:00:00.000000000 -1068 00:00:00.000000000 0 00:00:00.000000000 2003-09-23 1569 00:00:00.000000000 -1569 00:00:00.000000000 0 00:00:00.000000000 -2004-03-07 1735 01:00:00.000000000 -1735 01:00:00.000000000 0 00:00:00.000000000 -2007-02-09 2804 01:00:00.000000000 -2804 01:00:00.000000000 0 00:00:00.000000000 -2009-01-21 3516 01:00:00.000000000 -3516 01:00:00.000000000 0 00:00:00.000000000 +2004-03-07 1735 00:00:00.000000000 -1735 00:00:00.000000000 0 00:00:00.000000000 +2007-02-09 2804 00:00:00.000000000 -2804 00:00:00.000000000 0 00:00:00.000000000 +2009-01-21 3516 00:00:00.000000000 -3516 00:00:00.000000000 0 00:00:00.000000000 2010-04-08 3958 00:00:00.000000000 -3958 00:00:00.000000000 0 00:00:00.000000000 2013-04-07 5053 00:00:00.000000000 -5053 00:00:00.000000000 0 00:00:00.000000000 2013-04-10 5056 00:00:00.000000000 -5056 00:00:00.000000000 0 00:00:00.000000000 2021-09-24 8145 00:00:00.000000000 -8145 00:00:00.000000000 0 00:00:00.000000000 -2024-11-11 9289 01:00:00.000000000 -9289 01:00:00.000000000 0 00:00:00.000000000 +2024-11-11 9289 00:00:00.000000000 -9289 00:00:00.000000000 0 00:00:00.000000000 4143-07-08 783111 00:00:00.000000000 -783111 00:00:00.000000000 0 00:00:00.000000000 -4966-12-04 1083855 01:00:00.000000000 -1083855 01:00:00.000000000 0 00:00:00.000000000 -5339-02-01 1219784 01:00:00.000000000 -1219784 01:00:00.000000000 0 00:00:00.000000000 +4966-12-04 1083855 00:00:00.000000000 -1083855 00:00:00.000000000 0 00:00:00.000000000 +5339-02-01 1219784 00:00:00.000000000 -1219784 00:00:00.000000000 0 00:00:00.000000000 5344-10-04 1221856 00:00:00.000000000 -1221856 00:00:00.000000000 0 00:00:00.000000000 5397-07-13 1241131 00:00:00.000000000 -1241131 00:00:00.000000000 0 00:00:00.000000000 5966-07-09 1448949 00:00:00.000000000 -1448949 00:00:00.000000000 0 00:00:00.000000000 6229-06-28 1544997 00:00:00.000000000 -1544997 00:00:00.000000000 0 00:00:00.000000000 6482-04-27 1637342 00:00:00.000000000 -1637342 00:00:00.000000000 0 00:00:00.000000000 -6631-11-13 1691962 01:00:00.000000000 -1691962 01:00:00.000000000 0 00:00:00.000000000 +6631-11-13 1691962 00:00:00.000000000 -1691962 00:00:00.000000000 0 00:00:00.000000000 6705-09-28 1718944 00:00:00.000000000 -1718944 00:00:00.000000000 0 00:00:00.000000000 -6731-02-12 1728212 01:00:00.000000000 -1728212 01:00:00.000000000 0 00:00:00.000000000 -7160-12-02 1885195 01:00:00.000000000 -1885195 01:00:00.000000000 0 00:00:00.000000000 +6731-02-12 1728212 00:00:00.000000000 -1728212 00:00:00.000000000 0 00:00:00.000000000 +7160-12-02 1885195 00:00:00.000000000 -1885195 00:00:00.000000000 0 00:00:00.000000000 7409-09-07 1976054 00:00:00.000000000 -1976054 00:00:00.000000000 0 00:00:00.000000000 7503-06-23 2010310 00:00:00.000000000 -2010310 00:00:00.000000000 0 00:00:00.000000000 8422-07-22 2345998 00:00:00.000000000 -2345998 00:00:00.000000000 0 00:00:00.000000000 -8521-01-16 2381970 01:00:00.000000000 -2381970 01:00:00.000000000 0 00:00:00.000000000 +8521-01-16 2381970 00:00:00.000000000 -2381970 00:00:00.000000000 0 00:00:00.000000000 9075-06-13 2584462 00:00:00.000000000 -2584462 00:00:00.000000000 0 00:00:00.000000000 -9209-11-11 2633556 01:00:00.000000000 -2633556 01:00:00.000000000 0 00:00:00.000000000 -9403-01-09 2704106 01:00:00.000000000 -2704106 01:00:00.000000000 0 00:00:00.000000000 +9209-11-11 2633556 00:00:00.000000000 -2633556 00:00:00.000000000 0 00:00:00.000000000 +9403-01-09 2704106 00:00:00.000000000 -2704106 00:00:00.000000000 0 00:00:00.000000000 PREHOOK: query: explain vectorization expression select tsval, @@ -539,53 +539,53 @@ POSTHOOK: Input: default@interval_arithmetic_1 tsval _c1 _c2 _c3 _c4 _c5 _c6 0004-09-22 18:26:29.519542222 0002-07-22 18:26:29.519542222 0006-11-22 18:26:29.519542222 0006-11-22 18:26:29.519542222 0002-07-22 18:26:29.519542222 0002-07-22 18:26:29.519542222 0006-11-22 18:26:29.519542222 0528-10-27 08:15:18.941718273 0526-08-27 08:15:18.941718273 0530-12-27 08:15:18.941718273 0530-12-27 08:15:18.941718273 0526-08-27 08:15:18.941718273 0526-08-27 08:15:18.941718273 0530-12-27 08:15:18.941718273 -1319-02-02 16:31:57.778 1316-12-02 16:31:57.778 1321-04-02 16:31:57.778 1321-04-02 16:31:57.778 1316-12-02 16:31:57.778 1316-12-02 16:31:57.778 1321-04-02 16:31:57.778 +1319-02-02 16:31:57.778 1316-12-03 16:31:57.778 1321-04-02 16:31:57.778 1321-04-02 16:31:57.778 1316-12-03 16:31:57.778 1316-12-03 16:31:57.778 1321-04-02 16:31:57.778 1404-07-23 15:32:16.059185026 1402-05-23 15:32:16.059185026 1406-09-23 15:32:16.059185026 1406-09-23 15:32:16.059185026 1402-05-23 15:32:16.059185026 1402-05-23 15:32:16.059185026 1406-09-23 15:32:16.059185026 1815-05-06 00:12:37.543584705 1813-03-06 00:12:37.543584705 1817-07-06 00:12:37.543584705 1817-07-06 00:12:37.543584705 1813-03-06 00:12:37.543584705 1813-03-06 00:12:37.543584705 1817-07-06 00:12:37.543584705 1883-04-17 04:14:34.647766229 1881-02-17 04:14:34.647766229 1885-06-17 04:14:34.647766229 1885-06-17 04:14:34.647766229 1881-02-17 04:14:34.647766229 1881-02-17 04:14:34.647766229 1885-06-17 04:14:34.647766229 1966-08-16 13:36:50.183618031 1964-06-16 13:36:50.183618031 1968-10-16 13:36:50.183618031 1968-10-16 13:36:50.183618031 1964-06-16 13:36:50.183618031 1964-06-16 13:36:50.183618031 1968-10-16 13:36:50.183618031 -1973-04-17 06:30:38.596784156 1971-02-17 06:30:38.596784156 1975-06-17 07:30:38.596784156 1975-06-17 07:30:38.596784156 1971-02-17 06:30:38.596784156 1971-02-17 06:30:38.596784156 1975-06-17 07:30:38.596784156 -1974-10-04 17:21:03.989 1972-08-04 17:21:03.989 1976-12-04 16:21:03.989 1976-12-04 16:21:03.989 1972-08-04 17:21:03.989 1972-08-04 17:21:03.989 1976-12-04 16:21:03.989 -1976-03-03 04:54:33.000895162 1974-01-03 04:54:33.000895162 1978-05-03 05:54:33.000895162 1978-05-03 05:54:33.000895162 1974-01-03 04:54:33.000895162 1974-01-03 04:54:33.000895162 1978-05-03 05:54:33.000895162 +1973-04-17 06:30:38.596784156 1971-02-17 06:30:38.596784156 1975-06-17 06:30:38.596784156 1975-06-17 06:30:38.596784156 1971-02-17 06:30:38.596784156 1971-02-17 06:30:38.596784156 1975-06-17 06:30:38.596784156 +1974-10-04 17:21:03.989 1972-08-04 17:21:03.989 1976-12-04 17:21:03.989 1976-12-04 17:21:03.989 1972-08-04 17:21:03.989 1972-08-04 17:21:03.989 1976-12-04 17:21:03.989 +1976-03-03 04:54:33.000895162 1974-01-03 04:54:33.000895162 1978-05-03 04:54:33.000895162 1978-05-03 04:54:33.000895162 1974-01-03 04:54:33.000895162 1974-01-03 04:54:33.000895162 1978-05-03 04:54:33.000895162 1976-05-06 00:42:30.910786948 1974-03-06 00:42:30.910786948 1978-07-06 00:42:30.910786948 1978-07-06 00:42:30.910786948 1974-03-06 00:42:30.910786948 1974-03-06 00:42:30.910786948 1978-07-06 00:42:30.910786948 1978-08-05 14:41:05.501 1976-06-05 14:41:05.501 1980-10-05 14:41:05.501 1980-10-05 14:41:05.501 1976-06-05 14:41:05.501 1976-06-05 14:41:05.501 1980-10-05 14:41:05.501 -1981-04-25 09:01:12.077192689 1979-02-25 09:01:12.077192689 1983-06-25 10:01:12.077192689 1983-06-25 10:01:12.077192689 1979-02-25 09:01:12.077192689 1979-02-25 09:01:12.077192689 1983-06-25 10:01:12.077192689 -1981-11-15 23:03:10.999338387 1979-09-16 00:03:10.999338387 1984-01-15 23:03:10.999338387 1984-01-15 23:03:10.999338387 1979-09-16 00:03:10.999338387 1979-09-16 00:03:10.999338387 1984-01-15 23:03:10.999338387 +1981-04-25 09:01:12.077192689 1979-02-25 09:01:12.077192689 1983-06-25 09:01:12.077192689 1983-06-25 09:01:12.077192689 1979-02-25 09:01:12.077192689 1979-02-25 09:01:12.077192689 1983-06-25 09:01:12.077192689 +1981-11-15 23:03:10.999338387 1979-09-15 23:03:10.999338387 1984-01-15 23:03:10.999338387 1984-01-15 23:03:10.999338387 1979-09-15 23:03:10.999338387 1979-09-15 23:03:10.999338387 1984-01-15 23:03:10.999338387 1985-07-20 09:30:11 1983-05-20 09:30:11 1987-09-20 09:30:11 1987-09-20 09:30:11 1983-05-20 09:30:11 1983-05-20 09:30:11 1987-09-20 09:30:11 -1985-11-18 16:37:54 1983-09-18 17:37:54 1988-01-18 16:37:54 1988-01-18 16:37:54 1983-09-18 17:37:54 1983-09-18 17:37:54 1988-01-18 16:37:54 -1987-02-21 19:48:29 1984-12-21 19:48:29 1989-04-21 20:48:29 1989-04-21 20:48:29 1984-12-21 19:48:29 1984-12-21 19:48:29 1989-04-21 20:48:29 -1987-05-28 13:52:07.900916635 1985-03-28 12:52:07.900916635 1989-07-28 13:52:07.900916635 1989-07-28 13:52:07.900916635 1985-03-28 12:52:07.900916635 1985-03-28 12:52:07.900916635 1989-07-28 13:52:07.900916635 -1998-10-16 20:05:29.397591987 1996-08-16 20:05:29.397591987 2000-12-16 19:05:29.397591987 2000-12-16 19:05:29.397591987 1996-08-16 20:05:29.397591987 1996-08-16 20:05:29.397591987 2000-12-16 19:05:29.397591987 -1999-10-03 16:59:10.396903939 1997-08-03 16:59:10.396903939 2001-12-03 15:59:10.396903939 2001-12-03 15:59:10.396903939 1997-08-03 16:59:10.396903939 1997-08-03 16:59:10.396903939 2001-12-03 15:59:10.396903939 -2000-12-18 08:42:30.000595596 1998-10-18 09:42:30.000595596 2003-02-18 08:42:30.000595596 2003-02-18 08:42:30.000595596 1998-10-18 09:42:30.000595596 1998-10-18 09:42:30.000595596 2003-02-18 08:42:30.000595596 -2002-05-10 05:29:48.990818073 2000-03-10 04:29:48.990818073 2004-07-10 05:29:48.990818073 2004-07-10 05:29:48.990818073 2000-03-10 04:29:48.990818073 2000-03-10 04:29:48.990818073 2004-07-10 05:29:48.990818073 -2003-09-23 22:33:17.00003252 2001-07-23 22:33:17.00003252 2005-11-23 21:33:17.00003252 2005-11-23 21:33:17.00003252 2001-07-23 22:33:17.00003252 2001-07-23 22:33:17.00003252 2005-11-23 21:33:17.00003252 -2004-03-07 20:14:13 2002-01-07 20:14:13 2006-05-07 21:14:13 2006-05-07 21:14:13 2002-01-07 20:14:13 2002-01-07 20:14:13 2006-05-07 21:14:13 -2007-02-09 05:17:29.368756876 2004-12-09 05:17:29.368756876 2009-04-09 06:17:29.368756876 2009-04-09 06:17:29.368756876 2004-12-09 05:17:29.368756876 2004-12-09 05:17:29.368756876 2009-04-09 06:17:29.368756876 -2009-01-21 10:49:07.108 2006-11-21 10:49:07.108 2011-03-21 11:49:07.108 2011-03-21 11:49:07.108 2006-11-21 10:49:07.108 2006-11-21 10:49:07.108 2011-03-21 11:49:07.108 -2010-04-08 02:43:35.861742727 2008-02-08 01:43:35.861742727 2012-06-08 02:43:35.861742727 2012-06-08 02:43:35.861742727 2008-02-08 01:43:35.861742727 2008-02-08 01:43:35.861742727 2012-06-08 02:43:35.861742727 -2013-04-07 02:44:43.00086821 2011-02-07 01:44:43.00086821 2015-06-07 02:44:43.00086821 2015-06-07 02:44:43.00086821 2011-02-07 01:44:43.00086821 2011-02-07 01:44:43.00086821 2015-06-07 02:44:43.00086821 -2013-04-10 00:43:46.854731546 2011-02-09 23:43:46.854731546 2015-06-10 00:43:46.854731546 2015-06-10 00:43:46.854731546 2011-02-09 23:43:46.854731546 2011-02-09 23:43:46.854731546 2015-06-10 00:43:46.854731546 -2021-09-24 03:18:32.413655165 2019-07-24 03:18:32.413655165 2023-11-24 02:18:32.413655165 2023-11-24 02:18:32.413655165 2019-07-24 03:18:32.413655165 2019-07-24 03:18:32.413655165 2023-11-24 02:18:32.413655165 -2024-11-11 16:42:41.101 2022-09-11 17:42:41.101 2027-01-11 16:42:41.101 2027-01-11 16:42:41.101 2022-09-11 17:42:41.101 2022-09-11 17:42:41.101 2027-01-11 16:42:41.101 +1985-11-18 16:37:54 1983-09-18 16:37:54 1988-01-18 16:37:54 1988-01-18 16:37:54 1983-09-18 16:37:54 1983-09-18 16:37:54 1988-01-18 16:37:54 +1987-02-21 19:48:29 1984-12-21 19:48:29 1989-04-21 19:48:29 1989-04-21 19:48:29 1984-12-21 19:48:29 1984-12-21 19:48:29 1989-04-21 19:48:29 +1987-05-28 13:52:07.900916635 1985-03-28 13:52:07.900916635 1989-07-28 13:52:07.900916635 1989-07-28 13:52:07.900916635 1985-03-28 13:52:07.900916635 1985-03-28 13:52:07.900916635 1989-07-28 13:52:07.900916635 +1998-10-16 20:05:29.397591987 1996-08-16 20:05:29.397591987 2000-12-16 20:05:29.397591987 2000-12-16 20:05:29.397591987 1996-08-16 20:05:29.397591987 1996-08-16 20:05:29.397591987 2000-12-16 20:05:29.397591987 +1999-10-03 16:59:10.396903939 1997-08-03 16:59:10.396903939 2001-12-03 16:59:10.396903939 2001-12-03 16:59:10.396903939 1997-08-03 16:59:10.396903939 1997-08-03 16:59:10.396903939 2001-12-03 16:59:10.396903939 +2000-12-18 08:42:30.000595596 1998-10-18 08:42:30.000595596 2003-02-18 08:42:30.000595596 2003-02-18 08:42:30.000595596 1998-10-18 08:42:30.000595596 1998-10-18 08:42:30.000595596 2003-02-18 08:42:30.000595596 +2002-05-10 05:29:48.990818073 2000-03-10 05:29:48.990818073 2004-07-10 05:29:48.990818073 2004-07-10 05:29:48.990818073 2000-03-10 05:29:48.990818073 2000-03-10 05:29:48.990818073 2004-07-10 05:29:48.990818073 +2003-09-23 22:33:17.00003252 2001-07-23 22:33:17.00003252 2005-11-23 22:33:17.00003252 2005-11-23 22:33:17.00003252 2001-07-23 22:33:17.00003252 2001-07-23 22:33:17.00003252 2005-11-23 22:33:17.00003252 +2004-03-07 20:14:13 2002-01-07 20:14:13 2006-05-07 20:14:13 2006-05-07 20:14:13 2002-01-07 20:14:13 2002-01-07 20:14:13 2006-05-07 20:14:13 +2007-02-09 05:17:29.368756876 2004-12-09 05:17:29.368756876 2009-04-09 05:17:29.368756876 2009-04-09 05:17:29.368756876 2004-12-09 05:17:29.368756876 2004-12-09 05:17:29.368756876 2009-04-09 05:17:29.368756876 +2009-01-21 10:49:07.108 2006-11-21 10:49:07.108 2011-03-21 10:49:07.108 2011-03-21 10:49:07.108 2006-11-21 10:49:07.108 2006-11-21 10:49:07.108 2011-03-21 10:49:07.108 +2010-04-08 02:43:35.861742727 2008-02-08 02:43:35.861742727 2012-06-08 02:43:35.861742727 2012-06-08 02:43:35.861742727 2008-02-08 02:43:35.861742727 2008-02-08 02:43:35.861742727 2012-06-08 02:43:35.861742727 +2013-04-07 02:44:43.00086821 2011-02-07 02:44:43.00086821 2015-06-07 02:44:43.00086821 2015-06-07 02:44:43.00086821 2011-02-07 02:44:43.00086821 2011-02-07 02:44:43.00086821 2015-06-07 02:44:43.00086821 +2013-04-10 00:43:46.854731546 2011-02-10 00:43:46.854731546 2015-06-10 00:43:46.854731546 2015-06-10 00:43:46.854731546 2011-02-10 00:43:46.854731546 2011-02-10 00:43:46.854731546 2015-06-10 00:43:46.854731546 +2021-09-24 03:18:32.413655165 2019-07-24 03:18:32.413655165 2023-11-24 03:18:32.413655165 2023-11-24 03:18:32.413655165 2019-07-24 03:18:32.413655165 2019-07-24 03:18:32.413655165 2023-11-24 03:18:32.413655165 +2024-11-11 16:42:41.101 2022-09-11 16:42:41.101 2027-01-11 16:42:41.101 2027-01-11 16:42:41.101 2022-09-11 16:42:41.101 2022-09-11 16:42:41.101 2027-01-11 16:42:41.101 4143-07-08 10:53:27.252802259 4141-05-08 10:53:27.252802259 4145-09-08 10:53:27.252802259 4145-09-08 10:53:27.252802259 4141-05-08 10:53:27.252802259 4141-05-08 10:53:27.252802259 4145-09-08 10:53:27.252802259 -4966-12-04 09:30:55.202 4964-10-04 10:30:55.202 4969-02-04 09:30:55.202 4969-02-04 09:30:55.202 4964-10-04 10:30:55.202 4964-10-04 10:30:55.202 4969-02-04 09:30:55.202 -5339-02-01 14:10:01.085678691 5336-12-01 14:10:01.085678691 5341-04-01 15:10:01.085678691 5341-04-01 15:10:01.085678691 5336-12-01 14:10:01.085678691 5336-12-01 14:10:01.085678691 5341-04-01 15:10:01.085678691 -5344-10-04 18:40:08.165 5342-08-04 18:40:08.165 5346-12-04 17:40:08.165 5346-12-04 17:40:08.165 5342-08-04 18:40:08.165 5342-08-04 18:40:08.165 5346-12-04 17:40:08.165 +4966-12-04 09:30:55.202 4964-10-04 09:30:55.202 4969-02-04 09:30:55.202 4969-02-04 09:30:55.202 4964-10-04 09:30:55.202 4964-10-04 09:30:55.202 4969-02-04 09:30:55.202 +5339-02-01 14:10:01.085678691 5336-12-01 14:10:01.085678691 5341-04-01 14:10:01.085678691 5341-04-01 14:10:01.085678691 5336-12-01 14:10:01.085678691 5336-12-01 14:10:01.085678691 5341-04-01 14:10:01.085678691 +5344-10-04 18:40:08.165 5342-08-04 18:40:08.165 5346-12-04 18:40:08.165 5346-12-04 18:40:08.165 5342-08-04 18:40:08.165 5342-08-04 18:40:08.165 5346-12-04 18:40:08.165 5397-07-13 07:12:32.000896438 5395-05-13 07:12:32.000896438 5399-09-13 07:12:32.000896438 5399-09-13 07:12:32.000896438 5395-05-13 07:12:32.000896438 5395-05-13 07:12:32.000896438 5399-09-13 07:12:32.000896438 5966-07-09 03:30:50.597 5964-05-09 03:30:50.597 5968-09-09 03:30:50.597 5968-09-09 03:30:50.597 5964-05-09 03:30:50.597 5964-05-09 03:30:50.597 5968-09-09 03:30:50.597 6229-06-28 02:54:28.970117179 6227-04-28 02:54:28.970117179 6231-08-28 02:54:28.970117179 6231-08-28 02:54:28.970117179 6227-04-28 02:54:28.970117179 6227-04-28 02:54:28.970117179 6231-08-28 02:54:28.970117179 -6482-04-27 12:07:38.073915413 6480-02-27 11:07:38.073915413 6484-06-27 12:07:38.073915413 6484-06-27 12:07:38.073915413 6480-02-27 11:07:38.073915413 6480-02-27 11:07:38.073915413 6484-06-27 12:07:38.073915413 -6631-11-13 16:31:29.702202248 6629-09-13 17:31:29.702202248 6634-01-13 16:31:29.702202248 6634-01-13 16:31:29.702202248 6629-09-13 17:31:29.702202248 6629-09-13 17:31:29.702202248 6634-01-13 16:31:29.702202248 -6705-09-28 18:27:28.000845672 6703-07-28 18:27:28.000845672 6707-11-28 17:27:28.000845672 6707-11-28 17:27:28.000845672 6703-07-28 18:27:28.000845672 6703-07-28 18:27:28.000845672 6707-11-28 17:27:28.000845672 -6731-02-12 08:12:48.287783702 6728-12-12 08:12:48.287783702 6733-04-12 09:12:48.287783702 6733-04-12 09:12:48.287783702 6728-12-12 08:12:48.287783702 6728-12-12 08:12:48.287783702 6733-04-12 09:12:48.287783702 -7160-12-02 06:00:24.81200852 7158-10-02 07:00:24.81200852 7163-02-02 06:00:24.81200852 7163-02-02 06:00:24.81200852 7158-10-02 07:00:24.81200852 7158-10-02 07:00:24.81200852 7163-02-02 06:00:24.81200852 -7409-09-07 23:33:32.459349602 7407-07-07 23:33:32.459349602 7411-11-07 22:33:32.459349602 7411-11-07 22:33:32.459349602 7407-07-07 23:33:32.459349602 7407-07-07 23:33:32.459349602 7411-11-07 22:33:32.459349602 +6482-04-27 12:07:38.073915413 6480-02-27 12:07:38.073915413 6484-06-27 12:07:38.073915413 6484-06-27 12:07:38.073915413 6480-02-27 12:07:38.073915413 6480-02-27 12:07:38.073915413 6484-06-27 12:07:38.073915413 +6631-11-13 16:31:29.702202248 6629-09-13 16:31:29.702202248 6634-01-13 16:31:29.702202248 6634-01-13 16:31:29.702202248 6629-09-13 16:31:29.702202248 6629-09-13 16:31:29.702202248 6634-01-13 16:31:29.702202248 +6705-09-28 18:27:28.000845672 6703-07-28 18:27:28.000845672 6707-11-28 18:27:28.000845672 6707-11-28 18:27:28.000845672 6703-07-28 18:27:28.000845672 6703-07-28 18:27:28.000845672 6707-11-28 18:27:28.000845672 +6731-02-12 08:12:48.287783702 6728-12-12 08:12:48.287783702 6733-04-12 08:12:48.287783702 6733-04-12 08:12:48.287783702 6728-12-12 08:12:48.287783702 6728-12-12 08:12:48.287783702 6733-04-12 08:12:48.287783702 +7160-12-02 06:00:24.81200852 7158-10-02 06:00:24.81200852 7163-02-02 06:00:24.81200852 7163-02-02 06:00:24.81200852 7158-10-02 06:00:24.81200852 7158-10-02 06:00:24.81200852 7163-02-02 06:00:24.81200852 +7409-09-07 23:33:32.459349602 7407-07-07 23:33:32.459349602 7411-11-07 23:33:32.459349602 7411-11-07 23:33:32.459349602 7407-07-07 23:33:32.459349602 7407-07-07 23:33:32.459349602 7411-11-07 23:33:32.459349602 7503-06-23 23:14:17.486 7501-04-23 23:14:17.486 7505-08-23 23:14:17.486 7505-08-23 23:14:17.486 7501-04-23 23:14:17.486 7501-04-23 23:14:17.486 7505-08-23 23:14:17.486 8422-07-22 03:21:45.745036084 8420-05-22 03:21:45.745036084 8424-09-22 03:21:45.745036084 8424-09-22 03:21:45.745036084 8420-05-22 03:21:45.745036084 8420-05-22 03:21:45.745036084 8424-09-22 03:21:45.745036084 -8521-01-16 20:42:05.668832388 8518-11-16 20:42:05.668832388 8523-03-16 21:42:05.668832388 8523-03-16 21:42:05.668832388 8518-11-16 20:42:05.668832388 8518-11-16 20:42:05.668832388 8523-03-16 21:42:05.668832388 +8521-01-16 20:42:05.668832388 8518-11-16 20:42:05.668832388 8523-03-16 20:42:05.668832388 8523-03-16 20:42:05.668832388 8518-11-16 20:42:05.668832388 8518-11-16 20:42:05.668832388 8523-03-16 20:42:05.668832388 9075-06-13 16:20:09.218517797 9073-04-13 16:20:09.218517797 9077-08-13 16:20:09.218517797 9077-08-13 16:20:09.218517797 9073-04-13 16:20:09.218517797 9073-04-13 16:20:09.218517797 9077-08-13 16:20:09.218517797 -9209-11-11 04:08:58.223768453 9207-09-11 05:08:58.223768453 9212-01-11 04:08:58.223768453 9212-01-11 04:08:58.223768453 9207-09-11 05:08:58.223768453 9207-09-11 05:08:58.223768453 9212-01-11 04:08:58.223768453 +9209-11-11 04:08:58.223768453 9207-09-11 04:08:58.223768453 9212-01-11 04:08:58.223768453 9212-01-11 04:08:58.223768453 9207-09-11 04:08:58.223768453 9207-09-11 04:08:58.223768453 9212-01-11 04:08:58.223768453 9403-01-09 18:12:33.547 9400-11-09 18:12:33.547 9405-03-09 18:12:33.547 9405-03-09 18:12:33.547 9400-11-09 18:12:33.547 9400-11-09 18:12:33.547 9405-03-09 18:12:33.547 PREHOOK: query: explain vectorization expression select @@ -832,50 +832,50 @@ dateval _c1 _c2 _c3 _c4 _c5 _c6 1404-07-23 1404-04-14 12:37:26.876543211 1404-10-30 11:22:33.123456789 1404-10-30 11:22:33.123456789 1404-04-14 12:37:26.876543211 1404-04-14 12:37:26.876543211 1404-10-30 11:22:33.123456789 1815-05-06 1815-01-26 12:37:26.876543211 1815-08-13 11:22:33.123456789 1815-08-13 11:22:33.123456789 1815-01-26 12:37:26.876543211 1815-01-26 12:37:26.876543211 1815-08-13 11:22:33.123456789 1883-04-17 1883-01-07 12:37:26.876543211 1883-07-25 11:22:33.123456789 1883-07-25 11:22:33.123456789 1883-01-07 12:37:26.876543211 1883-01-07 12:37:26.876543211 1883-07-25 11:22:33.123456789 -1966-08-16 1966-05-08 12:37:26.876543211 1966-11-23 10:22:33.123456789 1966-11-23 10:22:33.123456789 1966-05-08 12:37:26.876543211 1966-05-08 12:37:26.876543211 1966-11-23 10:22:33.123456789 -1973-04-17 1973-01-07 12:37:26.876543211 1973-07-25 12:22:33.123456789 1973-07-25 12:22:33.123456789 1973-01-07 12:37:26.876543211 1973-01-07 12:37:26.876543211 1973-07-25 12:22:33.123456789 -1974-10-04 1974-06-26 12:37:26.876543211 1975-01-11 10:22:33.123456789 1975-01-11 10:22:33.123456789 1974-06-26 12:37:26.876543211 1974-06-26 12:37:26.876543211 1975-01-11 10:22:33.123456789 -1976-03-03 1975-11-24 12:37:26.876543211 1976-06-10 12:22:33.123456789 1976-06-10 12:22:33.123456789 1975-11-24 12:37:26.876543211 1975-11-24 12:37:26.876543211 1976-06-10 12:22:33.123456789 -1976-05-06 1976-01-27 11:37:26.876543211 1976-08-13 11:22:33.123456789 1976-08-13 11:22:33.123456789 1976-01-27 11:37:26.876543211 1976-01-27 11:37:26.876543211 1976-08-13 11:22:33.123456789 -1978-08-05 1978-04-27 11:37:26.876543211 1978-11-12 10:22:33.123456789 1978-11-12 10:22:33.123456789 1978-04-27 11:37:26.876543211 1978-04-27 11:37:26.876543211 1978-11-12 10:22:33.123456789 -1981-04-25 1981-01-15 12:37:26.876543211 1981-08-02 12:22:33.123456789 1981-08-02 12:22:33.123456789 1981-01-15 12:37:26.876543211 1981-01-15 12:37:26.876543211 1981-08-02 12:22:33.123456789 -1981-11-15 1981-08-07 13:37:26.876543211 1982-02-22 11:22:33.123456789 1982-02-22 11:22:33.123456789 1981-08-07 13:37:26.876543211 1981-08-07 13:37:26.876543211 1982-02-22 11:22:33.123456789 -1985-07-20 1985-04-11 11:37:26.876543211 1985-10-27 10:22:33.123456789 1985-10-27 10:22:33.123456789 1985-04-11 11:37:26.876543211 1985-04-11 11:37:26.876543211 1985-10-27 10:22:33.123456789 -1985-11-18 1985-08-10 13:37:26.876543211 1986-02-25 11:22:33.123456789 1986-02-25 11:22:33.123456789 1985-08-10 13:37:26.876543211 1985-08-10 13:37:26.876543211 1986-02-25 11:22:33.123456789 -1987-02-21 1986-11-13 12:37:26.876543211 1987-05-31 12:22:33.123456789 1987-05-31 12:22:33.123456789 1986-11-13 12:37:26.876543211 1986-11-13 12:37:26.876543211 1987-05-31 12:22:33.123456789 -1987-05-28 1987-02-17 11:37:26.876543211 1987-09-04 11:22:33.123456789 1987-09-04 11:22:33.123456789 1987-02-17 11:37:26.876543211 1987-02-17 11:37:26.876543211 1987-09-04 11:22:33.123456789 -1998-10-16 1998-07-08 12:37:26.876543211 1999-01-23 10:22:33.123456789 1999-01-23 10:22:33.123456789 1998-07-08 12:37:26.876543211 1998-07-08 12:37:26.876543211 1999-01-23 10:22:33.123456789 -1999-10-03 1999-06-25 12:37:26.876543211 2000-01-10 10:22:33.123456789 2000-01-10 10:22:33.123456789 1999-06-25 12:37:26.876543211 1999-06-25 12:37:26.876543211 2000-01-10 10:22:33.123456789 -2000-12-18 2000-09-09 13:37:26.876543211 2001-03-27 11:22:33.123456789 2001-03-27 11:22:33.123456789 2000-09-09 13:37:26.876543211 2000-09-09 13:37:26.876543211 2001-03-27 11:22:33.123456789 -2002-05-10 2002-01-30 11:37:26.876543211 2002-08-17 11:22:33.123456789 2002-08-17 11:22:33.123456789 2002-01-30 11:37:26.876543211 2002-01-30 11:37:26.876543211 2002-08-17 11:22:33.123456789 -2003-09-23 2003-06-15 12:37:26.876543211 2003-12-31 10:22:33.123456789 2003-12-31 10:22:33.123456789 2003-06-15 12:37:26.876543211 2003-06-15 12:37:26.876543211 2003-12-31 10:22:33.123456789 -2004-03-07 2003-11-28 12:37:26.876543211 2004-06-14 12:22:33.123456789 2004-06-14 12:22:33.123456789 2003-11-28 12:37:26.876543211 2003-11-28 12:37:26.876543211 2004-06-14 12:22:33.123456789 -2007-02-09 2006-11-01 12:37:26.876543211 2007-05-19 12:22:33.123456789 2007-05-19 12:22:33.123456789 2006-11-01 12:37:26.876543211 2006-11-01 12:37:26.876543211 2007-05-19 12:22:33.123456789 -2009-01-21 2008-10-13 13:37:26.876543211 2009-04-30 12:22:33.123456789 2009-04-30 12:22:33.123456789 2008-10-13 13:37:26.876543211 2008-10-13 13:37:26.876543211 2009-04-30 12:22:33.123456789 -2010-04-08 2009-12-29 11:37:26.876543211 2010-07-16 11:22:33.123456789 2010-07-16 11:22:33.123456789 2009-12-29 11:37:26.876543211 2009-12-29 11:37:26.876543211 2010-07-16 11:22:33.123456789 -2013-04-07 2012-12-28 11:37:26.876543211 2013-07-15 11:22:33.123456789 2013-07-15 11:22:33.123456789 2012-12-28 11:37:26.876543211 2012-12-28 11:37:26.876543211 2013-07-15 11:22:33.123456789 -2013-04-10 2012-12-31 11:37:26.876543211 2013-07-18 11:22:33.123456789 2013-07-18 11:22:33.123456789 2012-12-31 11:37:26.876543211 2012-12-31 11:37:26.876543211 2013-07-18 11:22:33.123456789 -2021-09-24 2021-06-16 12:37:26.876543211 2022-01-01 10:22:33.123456789 2022-01-01 10:22:33.123456789 2021-06-16 12:37:26.876543211 2021-06-16 12:37:26.876543211 2022-01-01 10:22:33.123456789 -2024-11-11 2024-08-03 13:37:26.876543211 2025-02-18 11:22:33.123456789 2025-02-18 11:22:33.123456789 2024-08-03 13:37:26.876543211 2024-08-03 13:37:26.876543211 2025-02-18 11:22:33.123456789 +1966-08-16 1966-05-08 12:37:26.876543211 1966-11-23 11:22:33.123456789 1966-11-23 11:22:33.123456789 1966-05-08 12:37:26.876543211 1966-05-08 12:37:26.876543211 1966-11-23 11:22:33.123456789 +1973-04-17 1973-01-07 12:37:26.876543211 1973-07-25 11:22:33.123456789 1973-07-25 11:22:33.123456789 1973-01-07 12:37:26.876543211 1973-01-07 12:37:26.876543211 1973-07-25 11:22:33.123456789 +1974-10-04 1974-06-26 12:37:26.876543211 1975-01-11 11:22:33.123456789 1975-01-11 11:22:33.123456789 1974-06-26 12:37:26.876543211 1974-06-26 12:37:26.876543211 1975-01-11 11:22:33.123456789 +1976-03-03 1975-11-24 12:37:26.876543211 1976-06-10 11:22:33.123456789 1976-06-10 11:22:33.123456789 1975-11-24 12:37:26.876543211 1975-11-24 12:37:26.876543211 1976-06-10 11:22:33.123456789 +1976-05-06 1976-01-27 12:37:26.876543211 1976-08-13 11:22:33.123456789 1976-08-13 11:22:33.123456789 1976-01-27 12:37:26.876543211 1976-01-27 12:37:26.876543211 1976-08-13 11:22:33.123456789 +1978-08-05 1978-04-27 12:37:26.876543211 1978-11-12 11:22:33.123456789 1978-11-12 11:22:33.123456789 1978-04-27 12:37:26.876543211 1978-04-27 12:37:26.876543211 1978-11-12 11:22:33.123456789 +1981-04-25 1981-01-15 12:37:26.876543211 1981-08-02 11:22:33.123456789 1981-08-02 11:22:33.123456789 1981-01-15 12:37:26.876543211 1981-01-15 12:37:26.876543211 1981-08-02 11:22:33.123456789 +1981-11-15 1981-08-07 12:37:26.876543211 1982-02-22 11:22:33.123456789 1982-02-22 11:22:33.123456789 1981-08-07 12:37:26.876543211 1981-08-07 12:37:26.876543211 1982-02-22 11:22:33.123456789 +1985-07-20 1985-04-11 12:37:26.876543211 1985-10-27 11:22:33.123456789 1985-10-27 11:22:33.123456789 1985-04-11 12:37:26.876543211 1985-04-11 12:37:26.876543211 1985-10-27 11:22:33.123456789 +1985-11-18 1985-08-10 12:37:26.876543211 1986-02-25 11:22:33.123456789 1986-02-25 11:22:33.123456789 1985-08-10 12:37:26.876543211 1985-08-10 12:37:26.876543211 1986-02-25 11:22:33.123456789 +1987-02-21 1986-11-13 12:37:26.876543211 1987-05-31 11:22:33.123456789 1987-05-31 11:22:33.123456789 1986-11-13 12:37:26.876543211 1986-11-13 12:37:26.876543211 1987-05-31 11:22:33.123456789 +1987-05-28 1987-02-17 12:37:26.876543211 1987-09-04 11:22:33.123456789 1987-09-04 11:22:33.123456789 1987-02-17 12:37:26.876543211 1987-02-17 12:37:26.876543211 1987-09-04 11:22:33.123456789 +1998-10-16 1998-07-08 12:37:26.876543211 1999-01-23 11:22:33.123456789 1999-01-23 11:22:33.123456789 1998-07-08 12:37:26.876543211 1998-07-08 12:37:26.876543211 1999-01-23 11:22:33.123456789 +1999-10-03 1999-06-25 12:37:26.876543211 2000-01-10 11:22:33.123456789 2000-01-10 11:22:33.123456789 1999-06-25 12:37:26.876543211 1999-06-25 12:37:26.876543211 2000-01-10 11:22:33.123456789 +2000-12-18 2000-09-09 12:37:26.876543211 2001-03-27 11:22:33.123456789 2001-03-27 11:22:33.123456789 2000-09-09 12:37:26.876543211 2000-09-09 12:37:26.876543211 2001-03-27 11:22:33.123456789 +2002-05-10 2002-01-30 12:37:26.876543211 2002-08-17 11:22:33.123456789 2002-08-17 11:22:33.123456789 2002-01-30 12:37:26.876543211 2002-01-30 12:37:26.876543211 2002-08-17 11:22:33.123456789 +2003-09-23 2003-06-15 12:37:26.876543211 2003-12-31 11:22:33.123456789 2003-12-31 11:22:33.123456789 2003-06-15 12:37:26.876543211 2003-06-15 12:37:26.876543211 2003-12-31 11:22:33.123456789 +2004-03-07 2003-11-28 12:37:26.876543211 2004-06-14 11:22:33.123456789 2004-06-14 11:22:33.123456789 2003-11-28 12:37:26.876543211 2003-11-28 12:37:26.876543211 2004-06-14 11:22:33.123456789 +2007-02-09 2006-11-01 12:37:26.876543211 2007-05-19 11:22:33.123456789 2007-05-19 11:22:33.123456789 2006-11-01 12:37:26.876543211 2006-11-01 12:37:26.876543211 2007-05-19 11:22:33.123456789 +2009-01-21 2008-10-13 12:37:26.876543211 2009-04-30 11:22:33.123456789 2009-04-30 11:22:33.123456789 2008-10-13 12:37:26.876543211 2008-10-13 12:37:26.876543211 2009-04-30 11:22:33.123456789 +2010-04-08 2009-12-29 12:37:26.876543211 2010-07-16 11:22:33.123456789 2010-07-16 11:22:33.123456789 2009-12-29 12:37:26.876543211 2009-12-29 12:37:26.876543211 2010-07-16 11:22:33.123456789 +2013-04-07 2012-12-28 12:37:26.876543211 2013-07-15 11:22:33.123456789 2013-07-15 11:22:33.123456789 2012-12-28 12:37:26.876543211 2012-12-28 12:37:26.876543211 2013-07-15 11:22:33.123456789 +2013-04-10 2012-12-31 12:37:26.876543211 2013-07-18 11:22:33.123456789 2013-07-18 11:22:33.123456789 2012-12-31 12:37:26.876543211 2012-12-31 12:37:26.876543211 2013-07-18 11:22:33.123456789 +2021-09-24 2021-06-16 12:37:26.876543211 2022-01-01 11:22:33.123456789 2022-01-01 11:22:33.123456789 2021-06-16 12:37:26.876543211 2021-06-16 12:37:26.876543211 2022-01-01 11:22:33.123456789 +2024-11-11 2024-08-03 12:37:26.876543211 2025-02-18 11:22:33.123456789 2025-02-18 11:22:33.123456789 2024-08-03 12:37:26.876543211 2024-08-03 12:37:26.876543211 2025-02-18 11:22:33.123456789 4143-07-08 4143-03-30 12:37:26.876543211 4143-10-15 11:22:33.123456789 4143-10-15 11:22:33.123456789 4143-03-30 12:37:26.876543211 4143-03-30 12:37:26.876543211 4143-10-15 11:22:33.123456789 -4966-12-04 4966-08-26 13:37:26.876543211 4967-03-13 12:22:33.123456789 4967-03-13 12:22:33.123456789 4966-08-26 13:37:26.876543211 4966-08-26 13:37:26.876543211 4967-03-13 12:22:33.123456789 -5339-02-01 5338-10-24 13:37:26.876543211 5339-05-11 12:22:33.123456789 5339-05-11 12:22:33.123456789 5338-10-24 13:37:26.876543211 5338-10-24 13:37:26.876543211 5339-05-11 12:22:33.123456789 -5344-10-04 5344-06-26 12:37:26.876543211 5345-01-11 10:22:33.123456789 5345-01-11 10:22:33.123456789 5344-06-26 12:37:26.876543211 5344-06-26 12:37:26.876543211 5345-01-11 10:22:33.123456789 +4966-12-04 4966-08-26 12:37:26.876543211 4967-03-13 11:22:33.123456789 4967-03-13 11:22:33.123456789 4966-08-26 12:37:26.876543211 4966-08-26 12:37:26.876543211 4967-03-13 11:22:33.123456789 +5339-02-01 5338-10-24 12:37:26.876543211 5339-05-11 11:22:33.123456789 5339-05-11 11:22:33.123456789 5338-10-24 12:37:26.876543211 5338-10-24 12:37:26.876543211 5339-05-11 11:22:33.123456789 +5344-10-04 5344-06-26 12:37:26.876543211 5345-01-11 11:22:33.123456789 5345-01-11 11:22:33.123456789 5344-06-26 12:37:26.876543211 5344-06-26 12:37:26.876543211 5345-01-11 11:22:33.123456789 5397-07-13 5397-04-04 12:37:26.876543211 5397-10-20 11:22:33.123456789 5397-10-20 11:22:33.123456789 5397-04-04 12:37:26.876543211 5397-04-04 12:37:26.876543211 5397-10-20 11:22:33.123456789 5966-07-09 5966-03-31 12:37:26.876543211 5966-10-16 11:22:33.123456789 5966-10-16 11:22:33.123456789 5966-03-31 12:37:26.876543211 5966-03-31 12:37:26.876543211 5966-10-16 11:22:33.123456789 6229-06-28 6229-03-20 12:37:26.876543211 6229-10-05 11:22:33.123456789 6229-10-05 11:22:33.123456789 6229-03-20 12:37:26.876543211 6229-03-20 12:37:26.876543211 6229-10-05 11:22:33.123456789 -6482-04-27 6482-01-17 11:37:26.876543211 6482-08-04 11:22:33.123456789 6482-08-04 11:22:33.123456789 6482-01-17 11:37:26.876543211 6482-01-17 11:37:26.876543211 6482-08-04 11:22:33.123456789 -6631-11-13 6631-08-05 13:37:26.876543211 6632-02-20 11:22:33.123456789 6632-02-20 11:22:33.123456789 6631-08-05 13:37:26.876543211 6631-08-05 13:37:26.876543211 6632-02-20 11:22:33.123456789 -6705-09-28 6705-06-20 12:37:26.876543211 6706-01-05 10:22:33.123456789 6706-01-05 10:22:33.123456789 6705-06-20 12:37:26.876543211 6705-06-20 12:37:26.876543211 6706-01-05 10:22:33.123456789 -6731-02-12 6730-11-04 12:37:26.876543211 6731-05-22 12:22:33.123456789 6731-05-22 12:22:33.123456789 6730-11-04 12:37:26.876543211 6730-11-04 12:37:26.876543211 6731-05-22 12:22:33.123456789 -7160-12-02 7160-08-24 13:37:26.876543211 7161-03-11 11:22:33.123456789 7161-03-11 11:22:33.123456789 7160-08-24 13:37:26.876543211 7160-08-24 13:37:26.876543211 7161-03-11 11:22:33.123456789 -7409-09-07 7409-05-30 12:37:26.876543211 7409-12-15 10:22:33.123456789 7409-12-15 10:22:33.123456789 7409-05-30 12:37:26.876543211 7409-05-30 12:37:26.876543211 7409-12-15 10:22:33.123456789 +6482-04-27 6482-01-17 12:37:26.876543211 6482-08-04 11:22:33.123456789 6482-08-04 11:22:33.123456789 6482-01-17 12:37:26.876543211 6482-01-17 12:37:26.876543211 6482-08-04 11:22:33.123456789 +6631-11-13 6631-08-05 12:37:26.876543211 6632-02-20 11:22:33.123456789 6632-02-20 11:22:33.123456789 6631-08-05 12:37:26.876543211 6631-08-05 12:37:26.876543211 6632-02-20 11:22:33.123456789 +6705-09-28 6705-06-20 12:37:26.876543211 6706-01-05 11:22:33.123456789 6706-01-05 11:22:33.123456789 6705-06-20 12:37:26.876543211 6705-06-20 12:37:26.876543211 6706-01-05 11:22:33.123456789 +6731-02-12 6730-11-04 12:37:26.876543211 6731-05-22 11:22:33.123456789 6731-05-22 11:22:33.123456789 6730-11-04 12:37:26.876543211 6730-11-04 12:37:26.876543211 6731-05-22 11:22:33.123456789 +7160-12-02 7160-08-24 12:37:26.876543211 7161-03-11 11:22:33.123456789 7161-03-11 11:22:33.123456789 7160-08-24 12:37:26.876543211 7160-08-24 12:37:26.876543211 7161-03-11 11:22:33.123456789 +7409-09-07 7409-05-30 12:37:26.876543211 7409-12-15 11:22:33.123456789 7409-12-15 11:22:33.123456789 7409-05-30 12:37:26.876543211 7409-05-30 12:37:26.876543211 7409-12-15 11:22:33.123456789 7503-06-23 7503-03-15 12:37:26.876543211 7503-09-30 11:22:33.123456789 7503-09-30 11:22:33.123456789 7503-03-15 12:37:26.876543211 7503-03-15 12:37:26.876543211 7503-09-30 11:22:33.123456789 8422-07-22 8422-04-13 12:37:26.876543211 8422-10-29 11:22:33.123456789 8422-10-29 11:22:33.123456789 8422-04-13 12:37:26.876543211 8422-04-13 12:37:26.876543211 8422-10-29 11:22:33.123456789 -8521-01-16 8520-10-08 13:37:26.876543211 8521-04-25 12:22:33.123456789 8521-04-25 12:22:33.123456789 8520-10-08 13:37:26.876543211 8520-10-08 13:37:26.876543211 8521-04-25 12:22:33.123456789 -9075-06-13 9075-03-05 11:37:26.876543211 9075-09-20 11:22:33.123456789 9075-09-20 11:22:33.123456789 9075-03-05 11:37:26.876543211 9075-03-05 11:37:26.876543211 9075-09-20 11:22:33.123456789 -9209-11-11 9209-08-03 13:37:26.876543211 9210-02-18 11:22:33.123456789 9210-02-18 11:22:33.123456789 9209-08-03 13:37:26.876543211 9209-08-03 13:37:26.876543211 9210-02-18 11:22:33.123456789 -9403-01-09 9402-10-01 13:37:26.876543211 9403-04-18 12:22:33.123456789 9403-04-18 12:22:33.123456789 9402-10-01 13:37:26.876543211 9402-10-01 13:37:26.876543211 9403-04-18 12:22:33.123456789 +8521-01-16 8520-10-08 12:37:26.876543211 8521-04-25 11:22:33.123456789 8521-04-25 11:22:33.123456789 8520-10-08 12:37:26.876543211 8520-10-08 12:37:26.876543211 8521-04-25 11:22:33.123456789 +9075-06-13 9075-03-05 12:37:26.876543211 9075-09-20 11:22:33.123456789 9075-09-20 11:22:33.123456789 9075-03-05 12:37:26.876543211 9075-03-05 12:37:26.876543211 9075-09-20 11:22:33.123456789 +9209-11-11 9209-08-03 12:37:26.876543211 9210-02-18 11:22:33.123456789 9210-02-18 11:22:33.123456789 9209-08-03 12:37:26.876543211 9209-08-03 12:37:26.876543211 9210-02-18 11:22:33.123456789 +9403-01-09 9402-10-01 12:37:26.876543211 9403-04-18 11:22:33.123456789 9403-04-18 11:22:33.123456789 9402-10-01 12:37:26.876543211 9402-10-01 12:37:26.876543211 9403-04-18 11:22:33.123456789 PREHOOK: query: explain vectorization expression select dateval, @@ -1200,50 +1200,50 @@ tsval _c1 _c2 _c3 _c4 _c5 _c6 1404-07-23 15:32:16.059185026 1404-04-15 04:09:42.935728237 1404-10-31 02:54:49.182641815 1404-10-31 02:54:49.182641815 1404-04-15 04:09:42.935728237 1404-04-15 04:09:42.935728237 1404-10-31 02:54:49.182641815 1815-05-06 00:12:37.543584705 1815-01-26 12:50:04.420127916 1815-08-13 11:35:10.667041494 1815-08-13 11:35:10.667041494 1815-01-26 12:50:04.420127916 1815-01-26 12:50:04.420127916 1815-08-13 11:35:10.667041494 1883-04-17 04:14:34.647766229 1883-01-07 16:52:01.52430944 1883-07-25 15:37:07.771223018 1883-07-25 15:37:07.771223018 1883-01-07 16:52:01.52430944 1883-01-07 16:52:01.52430944 1883-07-25 15:37:07.771223018 -1966-08-16 13:36:50.183618031 1966-05-09 02:14:17.060161242 1966-11-23 23:59:23.30707482 1966-11-23 23:59:23.30707482 1966-05-09 02:14:17.060161242 1966-05-09 02:14:17.060161242 1966-11-23 23:59:23.30707482 -1973-04-17 06:30:38.596784156 1973-01-07 19:08:05.473327367 1973-07-25 18:53:11.720240945 1973-07-25 18:53:11.720240945 1973-01-07 19:08:05.473327367 1973-01-07 19:08:05.473327367 1973-07-25 18:53:11.720240945 -1974-10-04 17:21:03.989 1974-06-27 05:58:30.865543211 1975-01-12 03:43:37.112456789 1975-01-12 03:43:37.112456789 1974-06-27 05:58:30.865543211 1974-06-27 05:58:30.865543211 1975-01-12 03:43:37.112456789 -1976-03-03 04:54:33.000895162 1975-11-24 17:31:59.877438373 1976-06-10 17:17:06.124351951 1976-06-10 17:17:06.124351951 1975-11-24 17:31:59.877438373 1975-11-24 17:31:59.877438373 1976-06-10 17:17:06.124351951 -1976-05-06 00:42:30.910786948 1976-01-27 12:19:57.787330159 1976-08-13 12:05:04.034243737 1976-08-13 12:05:04.034243737 1976-01-27 12:19:57.787330159 1976-01-27 12:19:57.787330159 1976-08-13 12:05:04.034243737 -1978-08-05 14:41:05.501 1978-04-28 02:18:32.377543211 1978-11-13 01:03:38.624456789 1978-11-13 01:03:38.624456789 1978-04-28 02:18:32.377543211 1978-04-28 02:18:32.377543211 1978-11-13 01:03:38.624456789 -1981-04-25 09:01:12.077192689 1981-01-15 21:38:38.9537359 1981-08-02 21:23:45.200649478 1981-08-02 21:23:45.200649478 1981-01-15 21:38:38.9537359 1981-01-15 21:38:38.9537359 1981-08-02 21:23:45.200649478 -1981-11-15 23:03:10.999338387 1981-08-08 12:40:37.875881598 1982-02-23 10:25:44.122795176 1982-02-23 10:25:44.122795176 1981-08-08 12:40:37.875881598 1981-08-08 12:40:37.875881598 1982-02-23 10:25:44.122795176 -1985-07-20 09:30:11 1985-04-11 21:07:37.876543211 1985-10-27 19:52:44.123456789 1985-10-27 19:52:44.123456789 1985-04-11 21:07:37.876543211 1985-04-11 21:07:37.876543211 1985-10-27 19:52:44.123456789 -1985-11-18 16:37:54 1985-08-11 06:15:20.876543211 1986-02-26 04:00:27.123456789 1986-02-26 04:00:27.123456789 1985-08-11 06:15:20.876543211 1985-08-11 06:15:20.876543211 1986-02-26 04:00:27.123456789 -1987-02-21 19:48:29 1986-11-14 08:25:55.876543211 1987-06-01 08:11:02.123456789 1987-06-01 08:11:02.123456789 1986-11-14 08:25:55.876543211 1986-11-14 08:25:55.876543211 1987-06-01 08:11:02.123456789 -1987-05-28 13:52:07.900916635 1987-02-18 01:29:34.777459846 1987-09-05 01:14:41.024373424 1987-09-05 01:14:41.024373424 1987-02-18 01:29:34.777459846 1987-02-18 01:29:34.777459846 1987-09-05 01:14:41.024373424 -1998-10-16 20:05:29.397591987 1998-07-09 08:42:56.274135198 1999-01-24 06:28:02.521048776 1999-01-24 06:28:02.521048776 1998-07-09 08:42:56.274135198 1998-07-09 08:42:56.274135198 1999-01-24 06:28:02.521048776 -1999-10-03 16:59:10.396903939 1999-06-26 05:36:37.27344715 2000-01-11 03:21:43.520360728 2000-01-11 03:21:43.520360728 1999-06-26 05:36:37.27344715 1999-06-26 05:36:37.27344715 2000-01-11 03:21:43.520360728 -2000-12-18 08:42:30.000595596 2000-09-09 22:19:56.877138807 2001-03-27 20:05:03.124052385 2001-03-27 20:05:03.124052385 2000-09-09 22:19:56.877138807 2000-09-09 22:19:56.877138807 2001-03-27 20:05:03.124052385 -2002-05-10 05:29:48.990818073 2002-01-30 17:07:15.867361284 2002-08-17 16:52:22.114274862 2002-08-17 16:52:22.114274862 2002-01-30 17:07:15.867361284 2002-01-30 17:07:15.867361284 2002-08-17 16:52:22.114274862 -2003-09-23 22:33:17.00003252 2003-06-16 11:10:43.876575731 2004-01-01 08:55:50.123489309 2004-01-01 08:55:50.123489309 2003-06-16 11:10:43.876575731 2003-06-16 11:10:43.876575731 2004-01-01 08:55:50.123489309 -2004-03-07 20:14:13 2003-11-29 08:51:39.876543211 2004-06-15 08:36:46.123456789 2004-06-15 08:36:46.123456789 2003-11-29 08:51:39.876543211 2003-11-29 08:51:39.876543211 2004-06-15 08:36:46.123456789 -2007-02-09 05:17:29.368756876 2006-11-01 17:54:56.245300087 2007-05-19 17:40:02.492213665 2007-05-19 17:40:02.492213665 2006-11-01 17:54:56.245300087 2006-11-01 17:54:56.245300087 2007-05-19 17:40:02.492213665 -2009-01-21 10:49:07.108 2008-10-14 00:26:33.984543211 2009-04-30 23:11:40.231456789 2009-04-30 23:11:40.231456789 2008-10-14 00:26:33.984543211 2008-10-14 00:26:33.984543211 2009-04-30 23:11:40.231456789 -2010-04-08 02:43:35.861742727 2009-12-29 14:21:02.738285938 2010-07-16 14:06:08.985199516 2010-07-16 14:06:08.985199516 2009-12-29 14:21:02.738285938 2009-12-29 14:21:02.738285938 2010-07-16 14:06:08.985199516 -2013-04-07 02:44:43.00086821 2012-12-28 14:22:09.877411421 2013-07-15 14:07:16.124324999 2013-07-15 14:07:16.124324999 2012-12-28 14:22:09.877411421 2012-12-28 14:22:09.877411421 2013-07-15 14:07:16.124324999 -2013-04-10 00:43:46.854731546 2012-12-31 12:21:13.731274757 2013-07-18 12:06:19.978188335 2013-07-18 12:06:19.978188335 2012-12-31 12:21:13.731274757 2012-12-31 12:21:13.731274757 2013-07-18 12:06:19.978188335 -2021-09-24 03:18:32.413655165 2021-06-16 15:55:59.290198376 2022-01-01 13:41:05.537111954 2022-01-01 13:41:05.537111954 2021-06-16 15:55:59.290198376 2021-06-16 15:55:59.290198376 2022-01-01 13:41:05.537111954 -2024-11-11 16:42:41.101 2024-08-04 06:20:07.977543211 2025-02-19 04:05:14.224456789 2025-02-19 04:05:14.224456789 2024-08-04 06:20:07.977543211 2024-08-04 06:20:07.977543211 2025-02-19 04:05:14.224456789 +1966-08-16 13:36:50.183618031 1966-05-09 02:14:17.060161242 1966-11-24 00:59:23.30707482 1966-11-24 00:59:23.30707482 1966-05-09 02:14:17.060161242 1966-05-09 02:14:17.060161242 1966-11-24 00:59:23.30707482 +1973-04-17 06:30:38.596784156 1973-01-07 19:08:05.473327367 1973-07-25 17:53:11.720240945 1973-07-25 17:53:11.720240945 1973-01-07 19:08:05.473327367 1973-01-07 19:08:05.473327367 1973-07-25 17:53:11.720240945 +1974-10-04 17:21:03.989 1974-06-27 05:58:30.865543211 1975-01-12 04:43:37.112456789 1975-01-12 04:43:37.112456789 1974-06-27 05:58:30.865543211 1974-06-27 05:58:30.865543211 1975-01-12 04:43:37.112456789 +1976-03-03 04:54:33.000895162 1975-11-24 17:31:59.877438373 1976-06-10 16:17:06.124351951 1976-06-10 16:17:06.124351951 1975-11-24 17:31:59.877438373 1975-11-24 17:31:59.877438373 1976-06-10 16:17:06.124351951 +1976-05-06 00:42:30.910786948 1976-01-27 13:19:57.787330159 1976-08-13 12:05:04.034243737 1976-08-13 12:05:04.034243737 1976-01-27 13:19:57.787330159 1976-01-27 13:19:57.787330159 1976-08-13 12:05:04.034243737 +1978-08-05 14:41:05.501 1978-04-28 03:18:32.377543211 1978-11-13 02:03:38.624456789 1978-11-13 02:03:38.624456789 1978-04-28 03:18:32.377543211 1978-04-28 03:18:32.377543211 1978-11-13 02:03:38.624456789 +1981-04-25 09:01:12.077192689 1981-01-15 21:38:38.9537359 1981-08-02 20:23:45.200649478 1981-08-02 20:23:45.200649478 1981-01-15 21:38:38.9537359 1981-01-15 21:38:38.9537359 1981-08-02 20:23:45.200649478 +1981-11-15 23:03:10.999338387 1981-08-08 11:40:37.875881598 1982-02-23 10:25:44.122795176 1982-02-23 10:25:44.122795176 1981-08-08 11:40:37.875881598 1981-08-08 11:40:37.875881598 1982-02-23 10:25:44.122795176 +1985-07-20 09:30:11 1985-04-11 22:07:37.876543211 1985-10-27 20:52:44.123456789 1985-10-27 20:52:44.123456789 1985-04-11 22:07:37.876543211 1985-04-11 22:07:37.876543211 1985-10-27 20:52:44.123456789 +1985-11-18 16:37:54 1985-08-11 05:15:20.876543211 1986-02-26 04:00:27.123456789 1986-02-26 04:00:27.123456789 1985-08-11 05:15:20.876543211 1985-08-11 05:15:20.876543211 1986-02-26 04:00:27.123456789 +1987-02-21 19:48:29 1986-11-14 08:25:55.876543211 1987-06-01 07:11:02.123456789 1987-06-01 07:11:02.123456789 1986-11-14 08:25:55.876543211 1986-11-14 08:25:55.876543211 1987-06-01 07:11:02.123456789 +1987-05-28 13:52:07.900916635 1987-02-18 02:29:34.777459846 1987-09-05 01:14:41.024373424 1987-09-05 01:14:41.024373424 1987-02-18 02:29:34.777459846 1987-02-18 02:29:34.777459846 1987-09-05 01:14:41.024373424 +1998-10-16 20:05:29.397591987 1998-07-09 08:42:56.274135198 1999-01-24 07:28:02.521048776 1999-01-24 07:28:02.521048776 1998-07-09 08:42:56.274135198 1998-07-09 08:42:56.274135198 1999-01-24 07:28:02.521048776 +1999-10-03 16:59:10.396903939 1999-06-26 05:36:37.27344715 2000-01-11 04:21:43.520360728 2000-01-11 04:21:43.520360728 1999-06-26 05:36:37.27344715 1999-06-26 05:36:37.27344715 2000-01-11 04:21:43.520360728 +2000-12-18 08:42:30.000595596 2000-09-09 21:19:56.877138807 2001-03-27 20:05:03.124052385 2001-03-27 20:05:03.124052385 2000-09-09 21:19:56.877138807 2000-09-09 21:19:56.877138807 2001-03-27 20:05:03.124052385 +2002-05-10 05:29:48.990818073 2002-01-30 18:07:15.867361284 2002-08-17 16:52:22.114274862 2002-08-17 16:52:22.114274862 2002-01-30 18:07:15.867361284 2002-01-30 18:07:15.867361284 2002-08-17 16:52:22.114274862 +2003-09-23 22:33:17.00003252 2003-06-16 11:10:43.876575731 2004-01-01 09:55:50.123489309 2004-01-01 09:55:50.123489309 2003-06-16 11:10:43.876575731 2003-06-16 11:10:43.876575731 2004-01-01 09:55:50.123489309 +2004-03-07 20:14:13 2003-11-29 08:51:39.876543211 2004-06-15 07:36:46.123456789 2004-06-15 07:36:46.123456789 2003-11-29 08:51:39.876543211 2003-11-29 08:51:39.876543211 2004-06-15 07:36:46.123456789 +2007-02-09 05:17:29.368756876 2006-11-01 17:54:56.245300087 2007-05-19 16:40:02.492213665 2007-05-19 16:40:02.492213665 2006-11-01 17:54:56.245300087 2006-11-01 17:54:56.245300087 2007-05-19 16:40:02.492213665 +2009-01-21 10:49:07.108 2008-10-13 23:26:33.984543211 2009-04-30 22:11:40.231456789 2009-04-30 22:11:40.231456789 2008-10-13 23:26:33.984543211 2008-10-13 23:26:33.984543211 2009-04-30 22:11:40.231456789 +2010-04-08 02:43:35.861742727 2009-12-29 15:21:02.738285938 2010-07-16 14:06:08.985199516 2010-07-16 14:06:08.985199516 2009-12-29 15:21:02.738285938 2009-12-29 15:21:02.738285938 2010-07-16 14:06:08.985199516 +2013-04-07 02:44:43.00086821 2012-12-28 15:22:09.877411421 2013-07-15 14:07:16.124324999 2013-07-15 14:07:16.124324999 2012-12-28 15:22:09.877411421 2012-12-28 15:22:09.877411421 2013-07-15 14:07:16.124324999 +2013-04-10 00:43:46.854731546 2012-12-31 13:21:13.731274757 2013-07-18 12:06:19.978188335 2013-07-18 12:06:19.978188335 2012-12-31 13:21:13.731274757 2012-12-31 13:21:13.731274757 2013-07-18 12:06:19.978188335 +2021-09-24 03:18:32.413655165 2021-06-16 15:55:59.290198376 2022-01-01 14:41:05.537111954 2022-01-01 14:41:05.537111954 2021-06-16 15:55:59.290198376 2021-06-16 15:55:59.290198376 2022-01-01 14:41:05.537111954 +2024-11-11 16:42:41.101 2024-08-04 05:20:07.977543211 2025-02-19 04:05:14.224456789 2025-02-19 04:05:14.224456789 2024-08-04 05:20:07.977543211 2024-08-04 05:20:07.977543211 2025-02-19 04:05:14.224456789 4143-07-08 10:53:27.252802259 4143-03-30 23:30:54.12934547 4143-10-15 22:16:00.376259048 4143-10-15 22:16:00.376259048 4143-03-30 23:30:54.12934547 4143-03-30 23:30:54.12934547 4143-10-15 22:16:00.376259048 -4966-12-04 09:30:55.202 4966-08-26 23:08:22.078543211 4967-03-13 21:53:28.325456789 4967-03-13 21:53:28.325456789 4966-08-26 23:08:22.078543211 4966-08-26 23:08:22.078543211 4967-03-13 21:53:28.325456789 -5339-02-01 14:10:01.085678691 5338-10-25 03:47:27.962221902 5339-05-12 02:32:34.20913548 5339-05-12 02:32:34.20913548 5338-10-25 03:47:27.962221902 5338-10-25 03:47:27.962221902 5339-05-12 02:32:34.20913548 -5344-10-04 18:40:08.165 5344-06-27 07:17:35.041543211 5345-01-12 05:02:41.288456789 5345-01-12 05:02:41.288456789 5344-06-27 07:17:35.041543211 5344-06-27 07:17:35.041543211 5345-01-12 05:02:41.288456789 +4966-12-04 09:30:55.202 4966-08-26 22:08:22.078543211 4967-03-13 20:53:28.325456789 4967-03-13 20:53:28.325456789 4966-08-26 22:08:22.078543211 4966-08-26 22:08:22.078543211 4967-03-13 20:53:28.325456789 +5339-02-01 14:10:01.085678691 5338-10-25 02:47:27.962221902 5339-05-12 01:32:34.20913548 5339-05-12 01:32:34.20913548 5338-10-25 02:47:27.962221902 5338-10-25 02:47:27.962221902 5339-05-12 01:32:34.20913548 +5344-10-04 18:40:08.165 5344-06-27 07:17:35.041543211 5345-01-12 06:02:41.288456789 5345-01-12 06:02:41.288456789 5344-06-27 07:17:35.041543211 5344-06-27 07:17:35.041543211 5345-01-12 06:02:41.288456789 5397-07-13 07:12:32.000896438 5397-04-04 19:49:58.877439649 5397-10-20 18:35:05.124353227 5397-10-20 18:35:05.124353227 5397-04-04 19:49:58.877439649 5397-04-04 19:49:58.877439649 5397-10-20 18:35:05.124353227 5966-07-09 03:30:50.597 5966-03-31 16:08:17.473543211 5966-10-16 14:53:23.720456789 5966-10-16 14:53:23.720456789 5966-03-31 16:08:17.473543211 5966-03-31 16:08:17.473543211 5966-10-16 14:53:23.720456789 6229-06-28 02:54:28.970117179 6229-03-20 15:31:55.84666039 6229-10-05 14:17:02.093573968 6229-10-05 14:17:02.093573968 6229-03-20 15:31:55.84666039 6229-03-20 15:31:55.84666039 6229-10-05 14:17:02.093573968 -6482-04-27 12:07:38.073915413 6482-01-17 23:45:04.950458624 6482-08-04 23:30:11.197372202 6482-08-04 23:30:11.197372202 6482-01-17 23:45:04.950458624 6482-01-17 23:45:04.950458624 6482-08-04 23:30:11.197372202 -6631-11-13 16:31:29.702202248 6631-08-06 06:08:56.578745459 6632-02-21 03:54:02.825659037 6632-02-21 03:54:02.825659037 6631-08-06 06:08:56.578745459 6631-08-06 06:08:56.578745459 6632-02-21 03:54:02.825659037 -6705-09-28 18:27:28.000845672 6705-06-21 07:04:54.877388883 6706-01-06 04:50:01.124302461 6706-01-06 04:50:01.124302461 6705-06-21 07:04:54.877388883 6705-06-21 07:04:54.877388883 6706-01-06 04:50:01.124302461 -6731-02-12 08:12:48.287783702 6730-11-04 20:50:15.164326913 6731-05-22 20:35:21.411240491 6731-05-22 20:35:21.411240491 6730-11-04 20:50:15.164326913 6730-11-04 20:50:15.164326913 6731-05-22 20:35:21.411240491 -7160-12-02 06:00:24.81200852 7160-08-24 19:37:51.688551731 7161-03-11 17:22:57.935465309 7161-03-11 17:22:57.935465309 7160-08-24 19:37:51.688551731 7160-08-24 19:37:51.688551731 7161-03-11 17:22:57.935465309 -7409-09-07 23:33:32.459349602 7409-05-31 12:10:59.335892813 7409-12-16 09:56:05.582806391 7409-12-16 09:56:05.582806391 7409-05-31 12:10:59.335892813 7409-05-31 12:10:59.335892813 7409-12-16 09:56:05.582806391 +6482-04-27 12:07:38.073915413 6482-01-18 00:45:04.950458624 6482-08-04 23:30:11.197372202 6482-08-04 23:30:11.197372202 6482-01-18 00:45:04.950458624 6482-01-18 00:45:04.950458624 6482-08-04 23:30:11.197372202 +6631-11-13 16:31:29.702202248 6631-08-06 05:08:56.578745459 6632-02-21 03:54:02.825659037 6632-02-21 03:54:02.825659037 6631-08-06 05:08:56.578745459 6631-08-06 05:08:56.578745459 6632-02-21 03:54:02.825659037 +6705-09-28 18:27:28.000845672 6705-06-21 07:04:54.877388883 6706-01-06 05:50:01.124302461 6706-01-06 05:50:01.124302461 6705-06-21 07:04:54.877388883 6705-06-21 07:04:54.877388883 6706-01-06 05:50:01.124302461 +6731-02-12 08:12:48.287783702 6730-11-04 20:50:15.164326913 6731-05-22 19:35:21.411240491 6731-05-22 19:35:21.411240491 6730-11-04 20:50:15.164326913 6730-11-04 20:50:15.164326913 6731-05-22 19:35:21.411240491 +7160-12-02 06:00:24.81200852 7160-08-24 18:37:51.688551731 7161-03-11 17:22:57.935465309 7161-03-11 17:22:57.935465309 7160-08-24 18:37:51.688551731 7160-08-24 18:37:51.688551731 7161-03-11 17:22:57.935465309 +7409-09-07 23:33:32.459349602 7409-05-31 12:10:59.335892813 7409-12-16 10:56:05.582806391 7409-12-16 10:56:05.582806391 7409-05-31 12:10:59.335892813 7409-05-31 12:10:59.335892813 7409-12-16 10:56:05.582806391 7503-06-23 23:14:17.486 7503-03-16 11:51:44.362543211 7503-10-01 10:36:50.609456789 7503-10-01 10:36:50.609456789 7503-03-16 11:51:44.362543211 7503-03-16 11:51:44.362543211 7503-10-01 10:36:50.609456789 8422-07-22 03:21:45.745036084 8422-04-13 15:59:12.621579295 8422-10-29 14:44:18.868492873 8422-10-29 14:44:18.868492873 8422-04-13 15:59:12.621579295 8422-04-13 15:59:12.621579295 8422-10-29 14:44:18.868492873 -8521-01-16 20:42:05.668832388 8520-10-09 10:19:32.545375599 8521-04-26 09:04:38.792289177 8521-04-26 09:04:38.792289177 8520-10-09 10:19:32.545375599 8520-10-09 10:19:32.545375599 8521-04-26 09:04:38.792289177 -9075-06-13 16:20:09.218517797 9075-03-06 03:57:36.095061008 9075-09-21 03:42:42.341974586 9075-09-21 03:42:42.341974586 9075-03-06 03:57:36.095061008 9075-03-06 03:57:36.095061008 9075-09-21 03:42:42.341974586 -9209-11-11 04:08:58.223768453 9209-08-03 17:46:25.100311664 9210-02-18 15:31:31.347225242 9210-02-18 15:31:31.347225242 9209-08-03 17:46:25.100311664 9209-08-03 17:46:25.100311664 9210-02-18 15:31:31.347225242 -9403-01-09 18:12:33.547 9402-10-02 07:50:00.423543211 9403-04-19 06:35:06.670456789 9403-04-19 06:35:06.670456789 9402-10-02 07:50:00.423543211 9402-10-02 07:50:00.423543211 9403-04-19 06:35:06.670456789 +8521-01-16 20:42:05.668832388 8520-10-09 09:19:32.545375599 8521-04-26 08:04:38.792289177 8521-04-26 08:04:38.792289177 8520-10-09 09:19:32.545375599 8520-10-09 09:19:32.545375599 8521-04-26 08:04:38.792289177 +9075-06-13 16:20:09.218517797 9075-03-06 04:57:36.095061008 9075-09-21 03:42:42.341974586 9075-09-21 03:42:42.341974586 9075-03-06 04:57:36.095061008 9075-03-06 04:57:36.095061008 9075-09-21 03:42:42.341974586 +9209-11-11 04:08:58.223768453 9209-08-03 16:46:25.100311664 9210-02-18 15:31:31.347225242 9210-02-18 15:31:31.347225242 9209-08-03 16:46:25.100311664 9209-08-03 16:46:25.100311664 9210-02-18 15:31:31.347225242 +9403-01-09 18:12:33.547 9402-10-02 06:50:00.423543211 9403-04-19 05:35:06.670456789 9403-04-19 05:35:06.670456789 9402-10-02 06:50:00.423543211 9402-10-02 06:50:00.423543211 9403-04-19 05:35:06.670456789 PREHOOK: query: explain vectorization expression select interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
http://git-wip-us.apache.org/repos/asf/hive/blob/ae008b79/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out index 1bbb9d0..57a1ea7 100644 --- a/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_partitioned_date_time.q.out @@ -1863,18 +1863,18 @@ POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10- POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 #### A masked pattern was here #### +2010-10-21 07:00:00 12 +2010-10-24 07:00:00 12 +2010-10-31 07:00:00 8 +2010-10-22 07:00:00 11 2010-10-23 07:00:00 12 +2010-10-30 07:00:00 11 +2010-10-20 07:00:00 11 2010-10-25 07:00:00 12 -2010-10-22 07:00:00 11 -2010-10-24 07:00:00 12 2010-10-26 07:00:00 13 -2010-10-20 07:00:00 11 +2010-10-27 07:00:00 11 2010-10-28 07:00:00 12 2010-10-29 07:00:00 12 -2010-10-30 07:00:00 11 -2010-10-31 07:00:00 8 -2010-10-21 07:00:00 12 -2010-10-27 07:00:00 11 PREHOOK: query: explain vectorization expression select * from flights_tiny_orc_partitioned_timestamp PREHOOK: type: QUERY @@ -2439,18 +2439,18 @@ POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10- POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 POSTHOOK: Input: default@flights_tiny_orc_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 #### A masked pattern was here #### +2010-10-21 07:00:00 12 +2010-10-24 07:00:00 12 +2010-10-31 07:00:00 8 +2010-10-22 07:00:00 11 2010-10-23 07:00:00 12 +2010-10-30 07:00:00 11 +2010-10-20 07:00:00 11 2010-10-25 07:00:00 12 -2010-10-22 07:00:00 11 -2010-10-24 07:00:00 12 2010-10-26 07:00:00 13 -2010-10-20 07:00:00 11 +2010-10-27 07:00:00 11 2010-10-28 07:00:00 12 2010-10-29 07:00:00 12 -2010-10-30 07:00:00 11 -2010-10-31 07:00:00 8 -2010-10-21 07:00:00 12 -2010-10-27 07:00:00 11 PREHOOK: query: CREATE TABLE flights_tiny_parquet STORED AS PARQUET AS SELECT origin_city_name, dest_city_name, fl_date, to_utc_timestamp(fl_date, 'America/Los_Angeles') as fl_time, arr_delay, fl_num FROM flights_tiny_n1 @@ -4288,18 +4288,18 @@ POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010 POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 #### A masked pattern was here #### +2010-10-21 07:00:00 12 +2010-10-24 07:00:00 12 +2010-10-31 07:00:00 8 +2010-10-22 07:00:00 11 2010-10-23 07:00:00 12 +2010-10-30 07:00:00 11 +2010-10-20 07:00:00 11 2010-10-25 07:00:00 12 -2010-10-22 07:00:00 11 -2010-10-24 07:00:00 12 2010-10-26 07:00:00 13 -2010-10-20 07:00:00 11 +2010-10-27 07:00:00 11 2010-10-28 07:00:00 12 2010-10-29 07:00:00 12 -2010-10-30 07:00:00 11 -2010-10-31 07:00:00 8 -2010-10-21 07:00:00 12 -2010-10-27 07:00:00 11 PREHOOK: query: explain vectorization expression select * from flights_tiny_parquet_partitioned_timestamp PREHOOK: type: QUERY @@ -4864,15 +4864,15 @@ POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010 POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-30 07%3A00%3A00 POSTHOOK: Input: default@flights_tiny_parquet_partitioned_timestamp@fl_time=2010-10-31 07%3A00%3A00 #### A masked pattern was here #### +2010-10-21 07:00:00 12 +2010-10-24 07:00:00 12 +2010-10-31 07:00:00 8 +2010-10-22 07:00:00 11 2010-10-23 07:00:00 12 +2010-10-30 07:00:00 11 +2010-10-20 07:00:00 11 2010-10-25 07:00:00 12 -2010-10-22 07:00:00 11 -2010-10-24 07:00:00 12 2010-10-26 07:00:00 13 -2010-10-20 07:00:00 11 +2010-10-27 07:00:00 11 2010-10-28 07:00:00 12 2010-10-29 07:00:00 12 -2010-10-30 07:00:00 11 -2010-10-31 07:00:00 8 -2010-10-21 07:00:00 12 -2010-10-27 07:00:00 11 http://git-wip-us.apache.org/repos/asf/hive/blob/ae008b79/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out index 2471c5d..e16f843 100644 --- a/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_ptf_part_simple.q.out @@ -5640,13 +5640,13 @@ STAGE PLANS: native: true vectorizationSchemaColumns: [0:p_mfgr:string, 1:p_name:string, 2:p_retailprice:double, 3:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] Reduce Output Operator - key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) + key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) sort order: ++ - Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) + Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) Reduce Sink Vectorization: className: VectorReduceSinkMultiKeyOperator keyColumnNums: [0, 6] - keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00.0) -> 5:timestamp) -> 6:timestamp + keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00) -> 5:timestamp) -> 6:timestamp native: true nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true valueColumnNums: [1, 2] @@ -5690,13 +5690,13 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col0 ASC NULLS FIRST, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END ASC NULLS FIRST - partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END + order by: _col0 ASC NULLS FIRST, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END ASC NULLS FIRST + partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END raw input shape: window functions: window function definition alias: rank_window_0 - arguments: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END + arguments: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END name: rank window function: GenericUDAFRankEvaluator window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX) @@ -5733,6 +5733,12 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice r +Manufacturer#5 almond antique blue firebrick mint 1789.69 1 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 +Manufacturer#5 almond antique sky peru orange 1788.73 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 @@ -5741,37 +5747,31 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 1 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 1 -Manufacturer#5 almond antique sky peru orange 1788.73 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 -Manufacturer#5 almond antique blue firebrick mint 1789.69 1 Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 -Manufacturer#4 almond antique gainsboro frosted violet NULL 1 -Manufacturer#4 almond antique violet mint lemon 1375.42 1 Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1 Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#4 almond antique gainsboro frosted violet NULL 1 +Manufacturer#4 almond antique violet mint lemon 1375.42 1 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 Manufacturer#1 almond antique burnished rose metallic 1173.15 1 Manufacturer#1 almond aquamarine burnished black steel 1414.42 1 Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 Manufacturer#1 almond antique burnished rose metallic 1173.15 1 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 -Manufacturer#3 almond antique metallic orange dim 55.39 1 Manufacturer#3 almond antique olive coral navajo 1337.29 1 -Manufacturer#3 almond antique chartreuse khaki white 99.68 1 Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 +Manufacturer#3 almond antique chartreuse khaki white 99.68 1 +Manufacturer#3 almond antique metallic orange dim 55.39 1 Manufacturer#3 almond antique misty red olive 1922.98 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 Manufacturer#3 almond antique forest lavender goldenrod NULL 1 PREHOOK: query: explain vectorization detail select p_mfgr, p_name, p_retailprice, @@ -5809,13 +5809,13 @@ STAGE PLANS: native: true vectorizationSchemaColumns: [0:p_mfgr:string, 1:p_name:string, 2:p_retailprice:double, 3:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] Reduce Output Operator - key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp), p_name (type: string) + key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp), p_name (type: string) sort order: +++ - Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) + Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) Reduce Sink Vectorization: className: VectorReduceSinkObjectHashOperator keyColumnNums: [0, 6, 1] - keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00.0) -> 5:timestamp) -> 6:timestamp + keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00) -> 5:timestamp) -> 6:timestamp native: true nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true partitionColumnNums: [0, 9] @@ -5873,7 +5873,7 @@ STAGE PLANS: input alias: ptf_1 name: windowingtablefunction order by: _col1 ASC NULLS FIRST - partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END + partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END raw input shape: window functions: window function definition @@ -5894,7 +5894,7 @@ STAGE PLANS: orderExpressions: [col 2:string] outputColumns: [4, 0, 2, 3] outputTypes: [int, string, string, double] - partitionExpressions: [col 0:string, IfExprColumnNull(col 5:boolean, col 6:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 5:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00.0) -> 6:timestamp) -> 7:timestamp] + partitionExpressions: [col 0:string, IfExprColumnNull(col 5:boolean, col 6:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 5:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00) -> 6:timestamp) -> 7:timestamp] streamingColumns: [4] Statistics: Num rows: 40 Data size: 19816 Basic stats: COMPLETE Column stats: COMPLETE Select Operator @@ -6541,13 +6541,13 @@ STAGE PLANS: native: true vectorizationSchemaColumns: [0:p_mfgr:string, 1:p_name:string, 2:p_retailprice:double, 3:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] Reduce Output Operator - key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp), p_name (type: string) + key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp), p_name (type: string) sort order: +++ - Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) + Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) Reduce Sink Vectorization: className: VectorReduceSinkObjectHashOperator keyColumnNums: [0, 6, 1] - keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00.0) -> 5:timestamp) -> 6:timestamp + keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00) -> 5:timestamp) -> 6:timestamp native: true nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true partitionColumnNums: [0, 9] @@ -6605,7 +6605,7 @@ STAGE PLANS: input alias: ptf_1 name: windowingtablefunction order by: _col1 ASC NULLS FIRST - partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END + partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END raw input shape: window functions: window function definition @@ -6626,7 +6626,7 @@ STAGE PLANS: orderExpressions: [col 2:string] outputColumns: [4, 0, 2, 3] outputTypes: [int, string, string, double] - partitionExpressions: [col 0:string, IfExprColumnNull(col 5:boolean, col 6:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 5:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00.0) -> 6:timestamp) -> 7:timestamp] + partitionExpressions: [col 0:string, IfExprColumnNull(col 5:boolean, col 6:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 5:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00) -> 6:timestamp) -> 7:timestamp] streamingColumns: [4] Statistics: Num rows: 40 Data size: 19816 Basic stats: COMPLETE Column stats: COMPLETE Select Operator @@ -6743,13 +6743,13 @@ STAGE PLANS: native: true vectorizationSchemaColumns: [0:p_mfgr:string, 1:p_name:string, 2:p_retailprice:double, 3:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] Reduce Output Operator - key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) + key expressions: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) sort order: ++ - Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) + Map-reduce partition columns: p_mfgr (type: string), CASE WHEN ((p_mfgr = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END (type: timestamp) Reduce Sink Vectorization: className: VectorReduceSinkMultiKeyOperator keyColumnNums: [0, 6] - keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00.0) -> 5:timestamp) -> 6:timestamp + keyExpressions: IfExprColumnNull(col 4:boolean, col 5:timestamp, null)(children: StringGroupColEqualStringScalar(col 0:string, val Manufacturer#2) -> 4:boolean, ConstantVectorExpression(val 2000-01-01 00:00:00) -> 5:timestamp) -> 6:timestamp native: true nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true valueColumnNums: [1, 2] @@ -6793,13 +6793,13 @@ STAGE PLANS: Windowing table definition input alias: ptf_1 name: windowingtablefunction - order by: _col0 ASC NULLS FIRST, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END ASC NULLS FIRST - partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END + order by: _col0 ASC NULLS FIRST, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END ASC NULLS FIRST + partition by: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END raw input shape: window functions: window function definition alias: rank_window_0 - arguments: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00.0') ELSE (CAST( null AS TIMESTAMP)) END + arguments: _col0, CASE WHEN ((_col0 = 'Manufacturer#2')) THEN (TIMESTAMP'2000-01-01 00:00:00') ELSE (CAST( null AS TIMESTAMP)) END name: rank window function: GenericUDAFRankEvaluator window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX) @@ -6836,6 +6836,12 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@vector_ptf_part_simple_orc #### A masked pattern was here #### p_mfgr p_name p_retailprice r +Manufacturer#5 almond antique blue firebrick mint 1789.69 1 +Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 +Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 +Manufacturer#5 almond antique sky peru orange 1788.73 1 +Manufacturer#5 almond antique medium spring khaki 1611.66 1 Manufacturer#2 almond aquamarine rose maroon antique 900.66 1 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 @@ -6844,35 +6850,29 @@ Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond antique violet turquoise frosted 1800.7 1 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1000.6 1 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 1 -Manufacturer#5 almond antique sky peru orange 1788.73 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond antique medium spring khaki 1611.66 1 -Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 1 -Manufacturer#5 almond azure blanched chiffon midnight 1464.48 1 -Manufacturer#5 almond antique blue firebrick mint 1789.69 1 Manufacturer#4 almond azure aquamarine papaya violet 1290.35 1 -Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 -Manufacturer#4 almond antique gainsboro frosted violet NULL 1 -Manufacturer#4 almond antique violet mint lemon 1375.42 1 Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 1 Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 1 -Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 +Manufacturer#4 almond antique gainsboro frosted violet NULL 1 +Manufacturer#4 almond antique violet mint lemon 1375.42 1 +Manufacturer#4 almond aquamarine floral ivory bisque NULL 1 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 1 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 -Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 Manufacturer#1 almond antique burnished rose metallic 1173.15 1 Manufacturer#1 almond aquamarine burnished black steel 1414.42 1 Manufacturer#1 almond aquamarine pink moccasin thistle NULL 1 -Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 1 +Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 1 Manufacturer#1 almond antique burnished rose metallic 1173.15 1 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 -Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 -Manufacturer#3 almond antique metallic orange dim 55.39 1 Manufacturer#3 almond antique olive coral navajo 1337.29 1 -Manufacturer#3 almond antique chartreuse khaki white 99.68 1 Manufacturer#3 almond antique forest lavender goldenrod 590.27 1 +Manufacturer#3 almond antique chartreuse khaki white 99.68 1 +Manufacturer#3 almond antique metallic orange dim 55.39 1 Manufacturer#3 almond antique misty red olive 1922.98 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 +Manufacturer#3 almond antique forest lavender goldenrod 1190.27 1 Manufacturer#3 almond antique forest lavender goldenrod NULL 1
