You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2017/02/24 01:08:52 UTC
[20/50] [abbrv] hive git commit: HIVE-15973 : Make
interval_arithmetic.q test robust
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/hive-14535
Commit: 1e00fb357c305b29cada4819793eb9ad5e63cb55
Parents: 54977d2
Author: Ashutosh Chauhan <ha...@apache.org>
Authored: Sun Feb 19 17:47:58 2017 -0800
Committer: Ashutosh Chauhan <ha...@apache.org>
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