http://git-wip-us.apache.org/repos/asf/hive/blob/52016296/ql/src/test/results/clientpositive/tez/vector_interval_arithmetic.q.out
----------------------------------------------------------------------
diff --git
a/ql/src/test/results/clientpositive/tez/vector_interval_arithmetic.q.out
b/ql/src/test/results/clientpositive/tez/vector_interval_arithmetic.q.out
new file mode 100644
index 0000000..8409a01
--- /dev/null
+++ b/ql/src/test/results/clientpositive/tez/vector_interval_arithmetic.q.out
@@ -0,0 +1,1086 @@
+PREHOOK: query: create table unique_timestamps (tsval timestamp) STORED AS
TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@unique_timestamps
+POSTHOOK: query: create table unique_timestamps (tsval timestamp) STORED AS
TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@unique_timestamps
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/timestamps.txt'
OVERWRITE INTO TABLE unique_timestamps
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@unique_timestamps
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/timestamps.txt'
OVERWRITE INTO TABLE unique_timestamps
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@unique_timestamps
+PREHOOK: query: create table interval_arithmetic_1 (dateval date, tsval
timestamp) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: query: create table interval_arithmetic_1 (dateval date, tsval
timestamp) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@interval_arithmetic_1
+PREHOOK: query: insert overwrite table interval_arithmetic_1
+ select cast(tsval as date), tsval from unique_timestamps
+PREHOOK: type: QUERY
+PREHOOK: Input: default@unique_timestamps
+PREHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: query: insert overwrite table interval_arithmetic_1
+ select cast(tsval as date), tsval from unique_timestamps
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@unique_timestamps
+POSTHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: Lineage: interval_arithmetic_1.dateval EXPRESSION
[(unique_timestamps)unique_timestamps.FieldSchema(name:tsval, type:timestamp,
comment:null), ]
+POSTHOOK: Lineage: interval_arithmetic_1.tsval SIMPLE
[(unique_timestamps)unique_timestamps.FieldSchema(name:tsval, type:timestamp,
comment:null), ]
+_c0 tsval
+PREHOOK: query: -- interval year-month arithmetic
+explain
+select
+ dateval,
+ dateval - interval '2-2' year to month,
+ dateval - interval '-2-2' year to month,
+ dateval + interval '2-2' year to month,
+ dateval + interval '-2-2' year to month,
+ - interval '2-2' year to month + dateval,
+ interval '2-2' year to month + dateval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+POSTHOOK: query: -- interval year-month arithmetic
+explain
+select
+ dateval,
+ dateval - interval '2-2' year to month,
+ dateval - interval '-2-2' year to month,
+ dateval + interval '2-2' year to month,
+ dateval + interval '-2-2' year to month,
+ - interval '2-2' year to month + dateval,
+ interval '2-2' year to month + dateval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dateval (type: date), (dateval - 2-2) (type:
date), (dateval - -2-2) (type: date), (dateval + 2-2) (type: date), (dateval +
-2-2) (type: date), (-2-2 + dateval) (type: date), (2-2 + dateval) (type: date)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ value expressions: _col1 (type: date), _col2 (type:
date), _col3 (type: date), _col4 (type: date), _col5 (type: date), _col6 (type:
date)
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0
(type: date), VALUE._col1 (type: date), VALUE._col2 (type: date), VALUE._col3
(type: date), VALUE._col4 (type: date), VALUE._col5 (type: date)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats: COMPLETE
Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dateval,
+ dateval - interval '2-2' year to month,
+ dateval - interval '-2-2' year to month,
+ dateval + interval '2-2' year to month,
+ dateval + interval '-2-2' year to month,
+ - interval '2-2' year to month + dateval,
+ interval '2-2' year to month + dateval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dateval,
+ dateval - interval '2-2' year to month,
+ dateval - interval '-2-2' year to month,
+ dateval + interval '2-2' year to month,
+ dateval + interval '-2-2' year to month,
+ - interval '2-2' year to month + dateval,
+ interval '2-2' year to month + dateval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+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
+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
+1966-08-16 1964-06-16 1968-10-16 1968-10-16 1964-06-16
1964-06-16 1968-10-16
+1973-04-17 1971-02-17 1975-06-17 1975-06-17 1971-02-17
1971-02-17 1975-06-17
+1974-10-04 1972-08-04 1976-12-04 1976-12-04 1972-08-04
1972-08-04 1976-12-04
+1976-03-03 1974-01-03 1978-05-03 1978-05-03 1974-01-03
1974-01-03 1978-05-03
+1976-05-06 1974-03-06 1978-07-06 1978-07-06 1974-03-06
1974-03-06 1978-07-06
+1978-08-05 1976-06-05 1980-10-05 1980-10-05 1976-06-05
1976-06-05 1980-10-05
+1981-04-25 1979-02-25 1983-06-25 1983-06-25 1979-02-25
1979-02-25 1983-06-25
+1981-11-15 1979-09-15 1984-01-15 1984-01-15 1979-09-15
1979-09-15 1984-01-15
+1985-07-20 1983-05-20 1987-09-20 1987-09-20 1983-05-20
1983-05-20 1987-09-20
+1985-11-18 1983-09-18 1988-01-18 1988-01-18 1983-09-18
1983-09-18 1988-01-18
+1987-02-21 1984-12-21 1989-04-21 1989-04-21 1984-12-21
1984-12-21 1989-04-21
+1987-05-28 1985-03-28 1989-07-28 1989-07-28 1985-03-28
1985-03-28 1989-07-28
+1998-10-16 1996-08-16 2000-12-16 2000-12-16 1996-08-16
1996-08-16 2000-12-16
+1999-10-03 1997-08-03 2001-12-03 2001-12-03 1997-08-03
1997-08-03 2001-12-03
+2000-12-18 1998-10-18 2003-02-18 2003-02-18 1998-10-18
1998-10-18 2003-02-18
+2002-05-10 2000-03-10 2004-07-10 2004-07-10 2000-03-10
2000-03-10 2004-07-10
+2003-09-23 2001-07-23 2005-11-23 2005-11-23 2001-07-23
2001-07-23 2005-11-23
+2004-03-07 2002-01-07 2006-05-07 2006-05-07 2002-01-07
2002-01-07 2006-05-07
+2007-02-09 2004-12-09 2009-04-09 2009-04-09 2004-12-09
2004-12-09 2009-04-09
+2009-01-21 2006-11-21 2011-03-21 2011-03-21 2006-11-21
2006-11-21 2011-03-21
+2010-04-08 2008-02-08 2012-06-08 2012-06-08 2008-02-08
2008-02-08 2012-06-08
+2013-04-07 2011-02-07 2015-06-07 2015-06-07 2011-02-07
2011-02-07 2015-06-07
+2013-04-10 2011-02-10 2015-06-10 2015-06-10 2011-02-10
2011-02-10 2015-06-10
+2021-09-24 2019-07-24 2023-11-24 2023-11-24 2019-07-24
2019-07-24 2023-11-24
+2024-11-11 2022-09-11 2027-01-11 2027-01-11 2022-09-11
2022-09-11 2027-01-11
+4143-07-08 4141-05-08 4145-09-08 4145-09-08 4141-05-08
4141-05-08 4145-09-08
+4966-12-04 4964-10-04 4969-02-04 4969-02-04 4964-10-04
4964-10-04 4969-02-04
+5339-02-01 5336-12-01 5341-04-01 5341-04-01 5336-12-01
5336-12-01 5341-04-01
+5344-10-04 5342-08-04 5346-12-04 5346-12-04 5342-08-04
5342-08-04 5346-12-04
+5397-07-13 5395-05-13 5399-09-13 5399-09-13 5395-05-13
5395-05-13 5399-09-13
+5966-07-09 5964-05-09 5968-09-09 5968-09-09 5964-05-09
5964-05-09 5968-09-09
+6229-06-28 6227-04-28 6231-08-28 6231-08-28 6227-04-28
6227-04-28 6231-08-28
+6482-04-27 6480-02-27 6484-06-27 6484-06-27 6480-02-27
6480-02-27 6484-06-27
+6631-11-13 6629-09-13 6634-01-13 6634-01-13 6629-09-13
6629-09-13 6634-01-13
+6705-09-28 6703-07-28 6707-11-28 6707-11-28 6703-07-28
6703-07-28 6707-11-28
+6731-02-12 6728-12-12 6733-04-12 6733-04-12 6728-12-12
6728-12-12 6733-04-12
+7160-12-02 7158-10-02 7163-02-02 7163-02-02 7158-10-02
7158-10-02 7163-02-02
+7409-09-07 7407-07-07 7411-11-07 7411-11-07 7407-07-07
7407-07-07 7411-11-07
+7503-06-23 7501-04-23 7505-08-23 7505-08-23 7501-04-23
7501-04-23 7505-08-23
+8422-07-22 8420-05-22 8424-09-22 8424-09-22 8420-05-22
8420-05-22 8424-09-22
+8521-01-16 8518-11-16 8523-03-16 8523-03-16 8518-11-16
8518-11-16 8523-03-16
+9075-06-13 9073-04-13 9077-08-13 9077-08-13 9073-04-13
9073-04-13 9077-08-13
+9209-11-11 9207-09-11 9212-01-11 9212-01-11 9207-09-11
9207-09-11 9212-01-11
+9403-01-09 9400-11-09 9405-03-09 9405-03-09 9400-11-09
9400-11-09 9405-03-09
+PREHOOK: query: explain
+select
+ dateval,
+ dateval - date '1999-06-07',
+ date '1999-06-07' - dateval,
+ dateval - dateval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ dateval,
+ dateval - date '1999-06-07',
+ date '1999-06-07' - dateval,
+ dateval - dateval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dateval (type: date), (dateval - 1999-06-07)
(type: interval_day_time), (1999-06-07 - dateval) (type: interval_day_time),
(dateval - dateval) (type: interval_day_time)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ value expressions: _col1 (type: interval_day_time),
_col2 (type: interval_day_time), _col3 (type: interval_day_time)
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0
(type: interval_day_time), VALUE._col1 (type: interval_day_time), VALUE._col2
(type: interval_day_time)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 50 Data size: 4800 Basic stats: COMPLETE
Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dateval,
+ dateval - date '1999-06-07',
+ date '1999-06-07' - dateval,
+ dateval - dateval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dateval,
+ dateval - date '1999-06-07',
+ date '1999-06-07' - dateval,
+ dateval - dateval
+from interval_arithmetic_1
+order by dateval
+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
+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
+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-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
+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
+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
+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
+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
+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
+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
+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
+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
+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
+PREHOOK: query: explain
+select
+ tsval,
+ tsval - interval '2-2' year to month,
+ tsval - interval '-2-2' year to month,
+ tsval + interval '2-2' year to month,
+ tsval + interval '-2-2' year to month,
+ - interval '2-2' year to month + tsval,
+ interval '2-2' year to month + tsval
+from interval_arithmetic_1
+order by tsval
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ tsval,
+ tsval - interval '2-2' year to month,
+ tsval - interval '-2-2' year to month,
+ tsval + interval '2-2' year to month,
+ tsval + interval '-2-2' year to month,
+ - interval '2-2' year to month + tsval,
+ interval '2-2' year to month + tsval
+from interval_arithmetic_1
+order by tsval
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator
+ expressions: tsval (type: timestamp), (tsval - 2-2) (type:
timestamp), (tsval - -2-2) (type: timestamp), (tsval + 2-2) (type: timestamp),
(tsval + -2-2) (type: timestamp), (-2-2 + tsval) (type: timestamp), (2-2 +
tsval) (type: timestamp)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: timestamp)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ value expressions: _col1 (type: timestamp), _col2 (type:
timestamp), _col3 (type: timestamp), _col4 (type: timestamp), _col5 (type:
timestamp), _col6 (type: timestamp)
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: timestamp), VALUE._col0
(type: timestamp), VALUE._col1 (type: timestamp), VALUE._col2 (type:
timestamp), VALUE._col3 (type: timestamp), VALUE._col4 (type: timestamp),
VALUE._col5 (type: timestamp)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats: COMPLETE
Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ tsval,
+ tsval - interval '2-2' year to month,
+ tsval - interval '-2-2' year to month,
+ tsval + interval '2-2' year to month,
+ tsval + interval '-2-2' year to month,
+ - interval '2-2' year to month + tsval,
+ interval '2-2' year to month + tsval
+from interval_arithmetic_1
+order by tsval
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ tsval,
+ tsval - interval '2-2' year to month,
+ tsval - interval '-2-2' year to month,
+ tsval + interval '2-2' year to month,
+ tsval + interval '-2-2' year to month,
+ - interval '2-2' year to month + tsval,
+ interval '2-2' year to month + tsval
+from interval_arithmetic_1
+order by tsval
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+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
+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
+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
+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
+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
+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
+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
+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
+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
+select
+ interval '2-2' year to month + interval '3-3' year to month,
+ interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+order by interval '2-2' year to month + interval '3-3' year to month
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ interval '2-2' year to month + interval '3-3' year to month,
+ interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+order by interval '2-2' year to month + interval '3-3' year to month
+limit 2
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: COMPLETE
+ Select Operator
+ Statistics: Num rows: 50 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
+ Reduce Output Operator
+ key expressions: 5-5 (type: interval_year_month)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 0 Basic stats:
PARTIAL Column stats: COMPLETE
+ TopN Hash Memory Usage: 0.1
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: 5-5 (type: interval_year_month), -1-1 (type:
interval_year_month)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 50 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
+ Limit
+ Number of rows: 2
+ Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 2
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ interval '2-2' year to month + interval '3-3' year to month,
+ interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+order by interval '2-2' year to month + interval '3-3' year to month
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ interval '2-2' year to month + interval '3-3' year to month,
+ interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+order by interval '2-2' year to month + interval '3-3' year to month
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+c0 c1
+5-5 -1-1
+5-5 -1-1
+PREHOOK: query: -- interval day-time arithmetic
+explain
+select
+ dateval,
+ dateval - interval '99 11:22:33.123456789' day to second,
+ dateval - interval '-99 11:22:33.123456789' day to second,
+ dateval + interval '99 11:22:33.123456789' day to second,
+ dateval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + dateval,
+ interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+POSTHOOK: query: -- interval day-time arithmetic
+explain
+select
+ dateval,
+ dateval - interval '99 11:22:33.123456789' day to second,
+ dateval - interval '-99 11:22:33.123456789' day to second,
+ dateval + interval '99 11:22:33.123456789' day to second,
+ dateval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + dateval,
+ interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dateval (type: date), (dateval - 99
11:22:33.123456789) (type: timestamp), (dateval - -99 11:22:33.123456789)
(type: timestamp), (dateval + 99 11:22:33.123456789) (type: timestamp),
(dateval + -99 11:22:33.123456789) (type: timestamp), (-99 11:22:33.123456789 +
dateval) (type: timestamp), (99 11:22:33.123456789 + dateval) (type: timestamp)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ value expressions: _col1 (type: timestamp), _col2 (type:
timestamp), _col3 (type: timestamp), _col4 (type: timestamp), _col5 (type:
timestamp), _col6 (type: timestamp)
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0
(type: timestamp), VALUE._col1 (type: timestamp), VALUE._col2 (type:
timestamp), VALUE._col3 (type: timestamp), VALUE._col4 (type: timestamp),
VALUE._col5 (type: timestamp)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats: COMPLETE
Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dateval,
+ dateval - interval '99 11:22:33.123456789' day to second,
+ dateval - interval '-99 11:22:33.123456789' day to second,
+ dateval + interval '99 11:22:33.123456789' day to second,
+ dateval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + dateval,
+ interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dateval,
+ dateval - interval '99 11:22:33.123456789' day to second,
+ dateval - interval '-99 11:22:33.123456789' day to second,
+ dateval + interval '99 11:22:33.123456789' day to second,
+ dateval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + dateval,
+ interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+dateval _c1 _c2 _c3 _c4 _c5 _c6
+0004-09-22 0004-06-14 12:37:26.876543211 0004-12-30 11:22:33.123456789
0004-12-30 11:22:33.123456789 0004-06-14 12:37:26.876543211 0004-06-14
12:37:26.876543211 0004-12-30 11:22:33.123456789
+0528-10-27 0528-07-19 12:37:26.876543211 0529-02-03 11:22:33.123456789
0529-02-03 11:22:33.123456789 0528-07-19 12:37:26.876543211 0528-07-19
12:37:26.876543211 0529-02-03 11:22:33.123456789
+1319-02-02 1318-10-25 12:37:26.876543211 1319-05-12 11:22:33.123456789
1319-05-12 11:22:33.123456789 1318-10-25 12:37:26.876543211 1318-10-25
12:37:26.876543211 1319-05-12 11:22:33.123456789
+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
+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
+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
+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
+PREHOOK: query: explain
+select
+ dateval,
+ tsval,
+ dateval - tsval,
+ tsval - dateval,
+ tsval - tsval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ dateval,
+ tsval,
+ dateval - tsval,
+ tsval - dateval,
+ tsval - tsval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dateval (type: date), tsval (type:
timestamp), (dateval - tsval) (type: interval_day_time), (tsval - dateval)
(type: interval_day_time), (tsval - tsval) (type: interval_day_time)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ value expressions: _col1 (type: timestamp), _col2 (type:
interval_day_time), _col3 (type: interval_day_time), _col4 (type:
interval_day_time)
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0
(type: timestamp), VALUE._col1 (type: interval_day_time), VALUE._col2 (type:
interval_day_time), VALUE._col3 (type: interval_day_time)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Statistics: Num rows: 50 Data size: 4800 Basic stats: COMPLETE
Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dateval,
+ tsval,
+ dateval - tsval,
+ tsval - dateval,
+ tsval - tsval
+from interval_arithmetic_1
+order by dateval
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dateval,
+ tsval,
+ dateval - tsval,
+ tsval - dateval,
+ tsval - tsval
+from interval_arithmetic_1
+order by dateval
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+dateval tsval c2 c3 c4
+0004-09-22 0004-09-22 18:26:29.519542222 -0 18:26:30.519542222 0
18:26:30.519542222 0 00:00:00.000000000
+0528-10-27 0528-10-27 08:15:18.941718273 -0 08:15:19.941718273 0
08:15:19.941718273 0 00:00:00.000000000
+1319-02-02 1319-02-02 16:31:57.778 -0 16:31:58.778000000 0
16:31:58.778000000 0 00:00:00.000000000
+1404-07-23 1404-07-23 15:32:16.059185026 -0 15:32:17.059185026 0
15:32:17.059185026 0 00:00:00.000000000
+1815-05-06 1815-05-06 00:12:37.543584705 -0 00:12:38.543584705 0
00:12:38.543584705 0 00:00:00.000000000
+1883-04-17 1883-04-17 04:14:34.647766229 -0 04:14:35.647766229 0
04:14:35.647766229 0 00:00:00.000000000
+1966-08-16 1966-08-16 13:36:50.183618031 -0 13:36:51.183618031 0
13:36:51.183618031 0 00:00:00.000000000
+1973-04-17 1973-04-17 06:30:38.596784156 -0 06:30:38.596784156 0
06:30:38.596784156 0 00:00:00.000000000
+1974-10-04 1974-10-04 17:21:03.989 -0 17:21:03.989000000 0
17:21:03.989000000 0 00:00:00.000000000
+1976-03-03 1976-03-03 04:54:33.000895162 -0 04:54:33.000895162 0
04:54:33.000895162 0 00:00:00.000000000
+1976-05-06 1976-05-06 00:42:30.910786948 -0 00:42:30.910786948 0
00:42:30.910786948 0 00:00:00.000000000
+1978-08-05 1978-08-05 14:41:05.501 -0 14:41:05.501000000 0
14:41:05.501000000 0 00:00:00.000000000
+1981-04-25 1981-04-25 09:01:12.077192689 -0 09:01:12.077192689 0
09:01:12.077192689 0 00:00:00.000000000
+1981-11-15 1981-11-15 23:03:10.999338387 -0 23:03:10.999338387 0
23:03:10.999338387 0 00:00:00.000000000
+1985-07-20 1985-07-20 09:30:11 -0 09:30:11.000000000 0
09:30:11.000000000 0 00:00:00.000000000
+1985-11-18 1985-11-18 16:37:54 -0 16:37:54.000000000 0
16:37:54.000000000 0 00:00:00.000000000
+1987-02-21 1987-02-21 19:48:29 -0 19:48:29.000000000 0
19:48:29.000000000 0 00:00:00.000000000
+1987-05-28 1987-05-28 13:52:07.900916635 -0 13:52:07.900916635 0
13:52:07.900916635 0 00:00:00.000000000
+1998-10-16 1998-10-16 20:05:29.397591987 -0 20:05:29.397591987 0
20:05:29.397591987 0 00:00:00.000000000
+1999-10-03 1999-10-03 16:59:10.396903939 -0 16:59:10.396903939 0
16:59:10.396903939 0 00:00:00.000000000
+2000-12-18 2000-12-18 08:42:30.000595596 -0 08:42:30.000595596 0
08:42:30.000595596 0 00:00:00.000000000
+2002-05-10 2002-05-10 05:29:48.990818073 -0 05:29:48.990818073 0
05:29:48.990818073 0 00:00:00.000000000
+2003-09-23 2003-09-23 22:33:17.00003252 -0 22:33:17.000032520 0
22:33:17.000032520 0 00:00:00.000000000
+2004-03-07 2004-03-07 20:14:13 -0 20:14:13.000000000 0
20:14:13.000000000 0 00:00:00.000000000
+2007-02-09 2007-02-09 05:17:29.368756876 -0 05:17:29.368756876 0
05:17:29.368756876 0 00:00:00.000000000
+2009-01-21 2009-01-21 10:49:07.108 -0 10:49:07.108000000 0
10:49:07.108000000 0 00:00:00.000000000
+2010-04-08 2010-04-08 02:43:35.861742727 -0 02:43:35.861742727 0
02:43:35.861742727 0 00:00:00.000000000
+2013-04-07 2013-04-07 02:44:43.00086821 -0 02:44:43.000868210 0
02:44:43.000868210 0 00:00:00.000000000
+2013-04-10 2013-04-10 00:43:46.854731546 -0 00:43:46.854731546 0
00:43:46.854731546 0 00:00:00.000000000
+2021-09-24 2021-09-24 03:18:32.413655165 -0 03:18:32.413655165 0
03:18:32.413655165 0 00:00:00.000000000
+2024-11-11 2024-11-11 16:42:41.101 -0 16:42:41.101000000 0
16:42:41.101000000 0 00:00:00.000000000
+4143-07-08 4143-07-08 10:53:27.252802259 -0 10:53:27.252802259 0
10:53:27.252802259 0 00:00:00.000000000
+4966-12-04 4966-12-04 09:30:55.202 -0 09:30:55.202000000 0
09:30:55.202000000 0 00:00:00.000000000
+5339-02-01 5339-02-01 14:10:01.085678691 -0 14:10:01.085678691 0
14:10:01.085678691 0 00:00:00.000000000
+5344-10-04 5344-10-04 18:40:08.165 -0 18:40:08.165000000 0
18:40:08.165000000 0 00:00:00.000000000
+5397-07-13 5397-07-13 07:12:32.000896438 -0 07:12:32.000896438 0
07:12:32.000896438 0 00:00:00.000000000
+5966-07-09 5966-07-09 03:30:50.597 -0 03:30:50.597000000 0
03:30:50.597000000 0 00:00:00.000000000
+6229-06-28 6229-06-28 02:54:28.970117179 -0 02:54:28.970117179 0
02:54:28.970117179 0 00:00:00.000000000
+6482-04-27 6482-04-27 12:07:38.073915413 -0 12:07:38.073915413 0
12:07:38.073915413 0 00:00:00.000000000
+6631-11-13 6631-11-13 16:31:29.702202248 -0 16:31:29.702202248 0
16:31:29.702202248 0 00:00:00.000000000
+6705-09-28 6705-09-28 18:27:28.000845672 -0 18:27:28.000845672 0
18:27:28.000845672 0 00:00:00.000000000
+6731-02-12 6731-02-12 08:12:48.287783702 -0 08:12:48.287783702 0
08:12:48.287783702 0 00:00:00.000000000
+7160-12-02 7160-12-02 06:00:24.81200852 -0 06:00:24.812008520 0
06:00:24.812008520 0 00:00:00.000000000
+7409-09-07 7409-09-07 23:33:32.459349602 -0 23:33:32.459349602 0
23:33:32.459349602 0 00:00:00.000000000
+7503-06-23 7503-06-23 23:14:17.486 -0 23:14:17.486000000 0
23:14:17.486000000 0 00:00:00.000000000
+8422-07-22 8422-07-22 03:21:45.745036084 -0 03:21:45.745036084 0
03:21:45.745036084 0 00:00:00.000000000
+8521-01-16 8521-01-16 20:42:05.668832388 -0 20:42:05.668832388 0
20:42:05.668832388 0 00:00:00.000000000
+9075-06-13 9075-06-13 16:20:09.218517797 -0 16:20:09.218517797 0
16:20:09.218517797 0 00:00:00.000000000
+9209-11-11 9209-11-11 04:08:58.223768453 -0 04:08:58.223768453 0
04:08:58.223768453 0 00:00:00.000000000
+9403-01-09 9403-01-09 18:12:33.547 -0 18:12:33.547000000 0
18:12:33.547000000 0 00:00:00.000000000
+PREHOOK: query: explain
+select
+ tsval,
+ tsval - interval '99 11:22:33.123456789' day to second,
+ tsval - interval '-99 11:22:33.123456789' day to second,
+ tsval + interval '99 11:22:33.123456789' day to second,
+ tsval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + tsval,
+ interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+order by tsval
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ tsval,
+ tsval - interval '99 11:22:33.123456789' day to second,
+ tsval - interval '-99 11:22:33.123456789' day to second,
+ tsval + interval '99 11:22:33.123456789' day to second,
+ tsval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + tsval,
+ interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+order by tsval
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator
+ expressions: tsval (type: timestamp), (tsval - 99
11:22:33.123456789) (type: timestamp), (tsval - -99 11:22:33.123456789) (type:
timestamp), (tsval + 99 11:22:33.123456789) (type: timestamp), (tsval + -99
11:22:33.123456789) (type: timestamp), (-99 11:22:33.123456789 + tsval) (type:
timestamp), (99 11:22:33.123456789 + tsval) (type: timestamp)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4,
_col5, _col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: timestamp)
+ sort order: +
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ value expressions: _col1 (type: timestamp), _col2 (type:
timestamp), _col3 (type: timestamp), _col4 (type: timestamp), _col5 (type:
timestamp), _col6 (type: timestamp)
+ Execution mode: vectorized
+ Reducer 2
+ Execution mode: vectorized
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: timestamp), VALUE._col0
(type: timestamp), VALUE._col1 (type: timestamp), VALUE._col2 (type:
timestamp), VALUE._col3 (type: timestamp), VALUE._col4 (type: timestamp),
VALUE._col5 (type: timestamp)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5,
_col6
+ Statistics: Num rows: 50 Data size: 4800 Basic stats: COMPLETE
Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: NONE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ tsval,
+ tsval - interval '99 11:22:33.123456789' day to second,
+ tsval - interval '-99 11:22:33.123456789' day to second,
+ tsval + interval '99 11:22:33.123456789' day to second,
+ tsval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + tsval,
+ interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+order by tsval
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ tsval,
+ tsval - interval '99 11:22:33.123456789' day to second,
+ tsval - interval '-99 11:22:33.123456789' day to second,
+ tsval + interval '99 11:22:33.123456789' day to second,
+ tsval + interval '-99 11:22:33.123456789' day to second,
+ -interval '99 11:22:33.123456789' day to second + tsval,
+ interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+order by tsval
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+tsval _c1 _c2 _c3 _c4 _c5 _c6
+0004-09-22 18:26:29.519542222 0004-06-15 07:03:56.396085433 0004-12-31
05:49:02.642999011 0004-12-31 05:49:02.642999011 0004-06-15
07:03:56.396085433 0004-06-15 07:03:56.396085433 0004-12-31
05:49:02.642999011
+0528-10-27 08:15:18.941718273 0528-07-19 20:52:45.818261484 0529-02-03
19:37:52.065175062 0529-02-03 19:37:52.065175062 0528-07-19
20:52:45.818261484 0528-07-19 20:52:45.818261484 0529-02-03
19:37:52.065175062
+1319-02-02 16:31:57.778 1318-10-26 05:09:24.654543211 1319-05-13
03:54:30.901456789 1319-05-13 03:54:30.901456789 1318-10-26
05:09:24.654543211 1318-10-26 05:09:24.654543211 1319-05-13
03:54:30.901456789
+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
+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
+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
+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
+PREHOOK: query: explain
+select
+ interval '99 11:22:33.123456789' day to second + interval '10
9:8:7.123456789' day to second,
+ interval '99 11:22:33.123456789' day to second - interval '10
9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ interval '99 11:22:33.123456789' day to second + interval '10
9:8:7.123456789' day to second,
+ interval '99 11:22:33.123456789' day to second - interval '10
9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+Explain
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: interval_arithmetic_1
+ Statistics: Num rows: 50 Data size: 4800 Basic stats:
COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: 109 20:30:40.246913578 (type:
interval_day_time), 89 02:14:26.000000000 (type: interval_day_time)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 50 Data size: 0 Basic stats: PARTIAL
Column stats: COMPLETE
+ Limit
+ Number of rows: 2
+ Statistics: Num rows: 2 Data size: 0 Basic stats:
PARTIAL Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 2 Data size: 0 Basic stats:
PARTIAL Column stats: COMPLETE
+ table:
+ input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 2
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ interval '99 11:22:33.123456789' day to second + interval '10
9:8:7.123456789' day to second,
+ interval '99 11:22:33.123456789' day to second - interval '10
9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ interval '99 11:22:33.123456789' day to second + interval '10
9:8:7.123456789' day to second,
+ interval '99 11:22:33.123456789' day to second - interval '10
9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+_c0 _c1
+109 20:30:40.246913578 89 02:14:26.000000000
+109 20:30:40.246913578 89 02:14:26.000000000
+PREHOOK: query: drop table interval_arithmetic_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@interval_arithmetic_1
+PREHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: query: drop table interval_arithmetic_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@interval_arithmetic_1
+POSTHOOK: Output: default@interval_arithmetic_1
