PREHOOK: query: create table interval_arithmetic_1 (dateval date, tsval timestamp) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@interval_arithmetic_1 POSTHOOK: query: create table interval_arithmetic_1 (dateval date, tsval timestamp) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@interval_arithmetic_1 PREHOOK: query: insert overwrite table interval_arithmetic_1 select cast(ctimestamp1 as date), ctimestamp1 from alltypesorc PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@interval_arithmetic_1 POSTHOOK: query: insert overwrite table interval_arithmetic_1 select cast(ctimestamp1 as date), ctimestamp1 from alltypesorc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@interval_arithmetic_1 POSTHOOK: Lineage: interval_arithmetic_1.dateval EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] POSTHOOK: Lineage: interval_arithmetic_1.tsval SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] 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 limit 2 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 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 2 Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: 2 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 limit 2 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 1969-12-31 1967-10-31 1972-02-29 1972-02-29 1967-10-31 1967-10-31 1972-02-29 NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain select dateval, dateval - date '1999-06-07', date '1999-06-07' - dateval, dateval - dateval from interval_arithmetic_1 limit 2 PREHOOK: type: QUERY POSTHOOK: query: explain select dateval, dateval - date '1999-06-07', date '1999-06-07' - dateval, dateval - dateval from interval_arithmetic_1 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 2 Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: 2 Processor Tree: ListSink PREHOOK: query: select dateval, dateval - date '1999-06-07', date '1999-06-07' - dateval, dateval - dateval from interval_arithmetic_1 limit 2 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 1969-12-31 -10749 23:00:00.000000000 10749 23:00:00.000000000 0 00:00:00.000000000 NULL NULL NULL NULL 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 limit 2 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 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 2 Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: 2 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 limit 2 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 1969-12-31 15:59:46.674 1967-10-31 15:59:46.674 1972-02-29 15:59:46.674 1972-02-29 15:59:46.674 1967-10-31 15:59:46.674 1967-10-31 15:59:46.674 1972-02-29 15:59:46.674 NULL NULL NULL NULL NULL NULL NULL 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 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 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: 2 Processor Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 5-5 (type: interval_year_month), -1-1 (type: interval_year_month) outputColumnNames: _col0, _col1 Statistics: Num rows: 12288 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 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 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 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 limit 2 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 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 2 Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: 2 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 limit 2 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 1969-12-31 1969-09-22 13:37:26.876543211 1970-04-09 11:22:33.123456789 1970-04-09 11:22:33.123456789 1969-09-22 13:37:26.876543211 1969-09-22 13:37:26.876543211 1970-04-09 11:22:33.123456789 NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: explain select dateval, tsval, dateval - tsval, tsval - dateval, tsval - tsval from interval_arithmetic_1 limit 2 PREHOOK: type: QUERY POSTHOOK: query: explain select dateval, tsval, dateval - tsval, tsval - dateval, tsval - tsval from interval_arithmetic_1 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 2 Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: 2 Processor Tree: ListSink PREHOOK: query: select dateval, tsval, dateval - tsval, tsval - dateval, tsval - tsval from interval_arithmetic_1 limit 2 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 1969-12-31 1969-12-31 15:59:46.674 -0 15:59:47.674000000 0 15:59:47.674000000 0 00:00:00.000000000 NULL NULL NULL NULL NULL 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 limit 2 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 limit 2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 2 Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: 2 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 limit 2 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 limit 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### 1969-12-31 15:59:46.674 1969-09-23 05:37:13.550543211 1970-04-10 03:22:19.797456789 1970-04-10 03:22:19.797456789 1969-09-23 05:37:13.550543211 1969-09-23 05:37:13.550543211 1970-04-10 03:22:19.797456789 NULL NULL NULL NULL NULL NULL NULL 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 STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: 2 Processor Tree: TableScan alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 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: 12288 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 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 #### 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