Repository: hive Updated Branches: refs/heads/master 54977d2f0 -> 1e00fb357
HIVE-15973 : Make interval_arithmetic.q test robust Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/1e00fb35 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/1e00fb35 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/1e00fb35 Branch: refs/heads/master Commit: 1e00fb357c305b29cada4819793eb9ad5e63cb55 Parents: 54977d2 Author: Ashutosh Chauhan <[email protected]> Authored: Sun Feb 19 17:47:58 2017 -0800 Committer: Ashutosh Chauhan <[email protected]> Committed: Sun Feb 19 17:47:58 2017 -0800 ---------------------------------------------------------------------- .../test/queries/clientpositive/interval_arithmetic.q | 4 ++-- .../results/clientpositive/interval_arithmetic.q.out | 12 ++++++------ 2 files changed, 8 insertions(+), 8 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/1e00fb35/ql/src/test/queries/clientpositive/interval_arithmetic.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/interval_arithmetic.q b/ql/src/test/queries/clientpositive/interval_arithmetic.q index 445cdfe..ae14579 100644 --- a/ql/src/test/queries/clientpositive/interval_arithmetic.q +++ b/ql/src/test/queries/clientpositive/interval_arithmetic.q @@ -160,6 +160,6 @@ from interval_arithmetic_1 limit 2; explain -select current_date + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1; -select current_date + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1; +select date '2016-11-08' + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1; +select date '2016-11-08' + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1; drop table interval_arithmetic_1; http://git-wip-us.apache.org/repos/asf/hive/blob/1e00fb35/ql/src/test/results/clientpositive/interval_arithmetic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/interval_arithmetic.q.out b/ql/src/test/results/clientpositive/interval_arithmetic.q.out index 039d3e1..eba97fa 100644 --- a/ql/src/test/results/clientpositive/interval_arithmetic.q.out +++ b/ql/src/test/results/clientpositive/interval_arithmetic.q.out @@ -607,10 +607,10 @@ POSTHOOK: Input: default@interval_arithmetic_1 109 20:30:40.246913578 89 02:14:26.000000000 109 20:30:40.246913578 89 02:14:26.000000000 PREHOOK: query: explain -select current_date + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 +select date '2016-11-08' + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 PREHOOK: type: QUERY POSTHOOK: query: explain -select current_date + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 +select date '2016-11-08' + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-0 is a root stage @@ -624,7 +624,7 @@ STAGE PLANS: alias: interval_arithmetic_1 Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: COMPLETE Select Operator - expressions: 2017-02-20 03:04:00.0 (type: timestamp) + expressions: 2016-11-11 03:04:00.0 (type: timestamp) outputColumnNames: _col0 Statistics: Num rows: 12288 Data size: 491520 Basic stats: COMPLETE Column stats: COMPLETE Limit @@ -632,15 +632,15 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE ListSink -PREHOOK: query: select current_date + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 +PREHOOK: query: select date '2016-11-08' + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### -POSTHOOK: query: select current_date + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 +POSTHOOK: query: select date '2016-11-08' + interval '1 2:02:00' day to second + interval '2' day + interval '1' hour + interval '1' minute + interval '60' second from interval_arithmetic_1 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@interval_arithmetic_1 #### A masked pattern was here #### -2017-02-20 03:04:00 +2016-11-11 03:04:00 PREHOOK: query: drop table interval_arithmetic_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@interval_arithmetic_1
