You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2015/07/31 02:43:38 UTC
[38/43] hive git commit: HIVE-11143: Tests
udf_from_utc_timestamp.q/udf_to_utc_timestamp.q do not work with updated Java
timezone information (Jason Dere, reviewed by Alex Pivovarov)
HIVE-11143: Tests udf_from_utc_timestamp.q/udf_to_utc_timestamp.q do not work with updated Java timezone information (Jason Dere, reviewed by Alex Pivovarov)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/f312d17e
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/f312d17e
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/f312d17e
Branch: refs/heads/spark
Commit: f312d17ef19d79a3b67792a67afd8435f90681ef
Parents: 9ae70cb
Author: Jason Dere <jd...@hortonworks.com>
Authored: Wed Jul 29 14:26:16 2015 -0700
Committer: Jason Dere <jd...@hortonworks.com>
Committed: Wed Jul 29 14:26:16 2015 -0700
----------------------------------------------------------------------
.../clientpositive/udf_from_utc_timestamp.q | 30 ++++-----
.../clientpositive/udf_to_utc_timestamp.q | 30 ++++-----
.../clientpositive/udf_from_utc_timestamp.q.out | 66 ++++++++++----------
.../clientpositive/udf_to_utc_timestamp.q.out | 66 ++++++++++----------
4 files changed, 96 insertions(+), 96 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/f312d17e/ql/src/test/queries/clientpositive/udf_from_utc_timestamp.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/udf_from_utc_timestamp.q b/ql/src/test/queries/clientpositive/udf_from_utc_timestamp.q
index de98507..b113eec 100644
--- a/ql/src/test/queries/clientpositive/udf_from_utc_timestamp.q
+++ b/ql/src/test/queries/clientpositive/udf_from_utc_timestamp.q
@@ -1,24 +1,24 @@
DESCRIBE FUNCTION from_utc_timestamp;
DESC FUNCTION EXTENDED from_utc_timestamp;
-explain select from_utc_timestamp('2015-02-11 10:30:00', 'PST');
+explain select from_utc_timestamp('2012-02-11 10:30:00', 'PST');
select
-from_utc_timestamp('2015-02-11 04:30:00', 'PST'),
-from_utc_timestamp('2015-02-11 04:30:00', 'Europe/Moscow'),
-from_utc_timestamp('2015-02-11 04:30:00', 'GMT+8'),
-from_utc_timestamp('2015-02-11 04:30:00', 'GMT'),
-from_utc_timestamp('2015-02-11 04:30:00', ''),
-from_utc_timestamp('2015-02-11 04:30:00', '---'),
+from_utc_timestamp('2012-02-11 04:30:00', 'PST'),
+from_utc_timestamp('2012-02-11 04:30:00', 'Europe/Moscow'),
+from_utc_timestamp('2012-02-11 04:30:00', 'GMT+8'),
+from_utc_timestamp('2012-02-11 04:30:00', 'GMT'),
+from_utc_timestamp('2012-02-11 04:30:00', ''),
+from_utc_timestamp('2012-02-11 04:30:00', '---'),
from_utc_timestamp(cast(null as string), 'PST'),
-from_utc_timestamp('2015-02-11 04:30:00', cast(null as string));
+from_utc_timestamp('2012-02-11 04:30:00', cast(null as string));
select
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'PST'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'Europe/Moscow'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT+8'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), ''),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), '---'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'PST'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'Europe/Moscow'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT+8'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), ''),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), '---'),
from_utc_timestamp(cast(null as timestamp), 'PST'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), cast(null as string));
\ No newline at end of file
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), cast(null as string));
http://git-wip-us.apache.org/repos/asf/hive/blob/f312d17e/ql/src/test/queries/clientpositive/udf_to_utc_timestamp.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/udf_to_utc_timestamp.q b/ql/src/test/queries/clientpositive/udf_to_utc_timestamp.q
index fe0b647..cca6d7d 100644
--- a/ql/src/test/queries/clientpositive/udf_to_utc_timestamp.q
+++ b/ql/src/test/queries/clientpositive/udf_to_utc_timestamp.q
@@ -1,24 +1,24 @@
DESCRIBE FUNCTION to_utc_timestamp;
DESC FUNCTION EXTENDED to_utc_timestamp;
-explain select to_utc_timestamp('2015-02-11 10:30:00', 'PST');
+explain select to_utc_timestamp('2012-02-11 10:30:00', 'PST');
select
-to_utc_timestamp('2015-02-10 20:30:00', 'PST'),
-to_utc_timestamp('2015-02-11 08:30:00', 'Europe/Moscow'),
-to_utc_timestamp('2015-02-11 12:30:00', 'GMT+8'),
-to_utc_timestamp('2015-02-11 04:30:00', 'GMT'),
-to_utc_timestamp('2015-02-11 04:30:00', ''),
-to_utc_timestamp('2015-02-11 04:30:00', '---'),
+to_utc_timestamp('2012-02-10 20:30:00', 'PST'),
+to_utc_timestamp('2012-02-11 08:30:00', 'Europe/Moscow'),
+to_utc_timestamp('2012-02-11 12:30:00', 'GMT+8'),
+to_utc_timestamp('2012-02-11 04:30:00', 'GMT'),
+to_utc_timestamp('2012-02-11 04:30:00', ''),
+to_utc_timestamp('2012-02-11 04:30:00', '---'),
to_utc_timestamp(cast(null as string), 'PST'),
-to_utc_timestamp('2015-02-11 04:30:00', cast(null as string));
+to_utc_timestamp('2012-02-11 04:30:00', cast(null as string));
select
-to_utc_timestamp(cast('2015-02-10 20:30:00' as timestamp), 'PST'),
-to_utc_timestamp(cast('2015-02-11 08:30:00' as timestamp), 'Europe/Moscow'),
-to_utc_timestamp(cast('2015-02-11 12:30:00' as timestamp), 'GMT+8'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), ''),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), '---'),
+to_utc_timestamp(cast('2012-02-10 20:30:00' as timestamp), 'PST'),
+to_utc_timestamp(cast('2012-02-11 08:30:00' as timestamp), 'Europe/Moscow'),
+to_utc_timestamp(cast('2012-02-11 12:30:00' as timestamp), 'GMT+8'),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT'),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), ''),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), '---'),
to_utc_timestamp(cast(null as timestamp), 'PST'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), cast(null as string));
\ No newline at end of file
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), cast(null as string));
http://git-wip-us.apache.org/repos/asf/hive/blob/f312d17e/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out b/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
index 577d41c..5b4bc35 100644
--- a/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out
@@ -8,9 +8,9 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESC FUNCTION EXTENDED from_utc_timestamp
POSTHOOK: type: DESCFUNCTION
from_utc_timestamp(timestamp, string timezone) - Assumes given timestamp is UTC and converts to given timezone (as of Hive 0.8.0)
-PREHOOK: query: explain select from_utc_timestamp('2015-02-11 10:30:00', 'PST')
+PREHOOK: query: explain select from_utc_timestamp('2012-02-11 10:30:00', 'PST')
PREHOOK: type: QUERY
-POSTHOOK: query: explain select from_utc_timestamp('2015-02-11 10:30:00', 'PST')
+POSTHOOK: query: explain select from_utc_timestamp('2012-02-11 10:30:00', 'PST')
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -25,58 +25,58 @@ STAGE PLANS:
Row Limit Per Split: 1
Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 2015-02-11 02:30:00.0 (type: timestamp)
+ expressions: 2012-02-11 02:30:00.0 (type: timestamp)
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
ListSink
PREHOOK: query: select
-from_utc_timestamp('2015-02-11 04:30:00', 'PST'),
-from_utc_timestamp('2015-02-11 04:30:00', 'Europe/Moscow'),
-from_utc_timestamp('2015-02-11 04:30:00', 'GMT+8'),
-from_utc_timestamp('2015-02-11 04:30:00', 'GMT'),
-from_utc_timestamp('2015-02-11 04:30:00', ''),
-from_utc_timestamp('2015-02-11 04:30:00', '---'),
+from_utc_timestamp('2012-02-11 04:30:00', 'PST'),
+from_utc_timestamp('2012-02-11 04:30:00', 'Europe/Moscow'),
+from_utc_timestamp('2012-02-11 04:30:00', 'GMT+8'),
+from_utc_timestamp('2012-02-11 04:30:00', 'GMT'),
+from_utc_timestamp('2012-02-11 04:30:00', ''),
+from_utc_timestamp('2012-02-11 04:30:00', '---'),
from_utc_timestamp(cast(null as string), 'PST'),
-from_utc_timestamp('2015-02-11 04:30:00', cast(null as string))
+from_utc_timestamp('2012-02-11 04:30:00', cast(null as string))
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
-from_utc_timestamp('2015-02-11 04:30:00', 'PST'),
-from_utc_timestamp('2015-02-11 04:30:00', 'Europe/Moscow'),
-from_utc_timestamp('2015-02-11 04:30:00', 'GMT+8'),
-from_utc_timestamp('2015-02-11 04:30:00', 'GMT'),
-from_utc_timestamp('2015-02-11 04:30:00', ''),
-from_utc_timestamp('2015-02-11 04:30:00', '---'),
+from_utc_timestamp('2012-02-11 04:30:00', 'PST'),
+from_utc_timestamp('2012-02-11 04:30:00', 'Europe/Moscow'),
+from_utc_timestamp('2012-02-11 04:30:00', 'GMT+8'),
+from_utc_timestamp('2012-02-11 04:30:00', 'GMT'),
+from_utc_timestamp('2012-02-11 04:30:00', ''),
+from_utc_timestamp('2012-02-11 04:30:00', '---'),
from_utc_timestamp(cast(null as string), 'PST'),
-from_utc_timestamp('2015-02-11 04:30:00', cast(null as string))
+from_utc_timestamp('2012-02-11 04:30:00', cast(null as string))
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-2015-02-10 20:30:00 2015-02-11 08:30:00 2015-02-11 12:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 NULL NULL
+2012-02-10 20:30:00 2012-02-11 08:30:00 2012-02-11 12:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 NULL NULL
PREHOOK: query: select
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'PST'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'Europe/Moscow'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT+8'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), ''),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), '---'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'PST'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'Europe/Moscow'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT+8'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), ''),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), '---'),
from_utc_timestamp(cast(null as timestamp), 'PST'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), cast(null as string))
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), cast(null as string))
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'PST'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'Europe/Moscow'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT+8'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), ''),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), '---'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'PST'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'Europe/Moscow'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT+8'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT'),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), ''),
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), '---'),
from_utc_timestamp(cast(null as timestamp), 'PST'),
-from_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), cast(null as string))
+from_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), cast(null as string))
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-2015-02-10 20:30:00 2015-02-11 08:30:00 2015-02-11 12:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 NULL NULL
+2012-02-10 20:30:00 2012-02-11 08:30:00 2012-02-11 12:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 NULL NULL
http://git-wip-us.apache.org/repos/asf/hive/blob/f312d17e/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out b/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
index 81ecd44..1730f8c 100644
--- a/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
+++ b/ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out
@@ -8,9 +8,9 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESC FUNCTION EXTENDED to_utc_timestamp
POSTHOOK: type: DESCFUNCTION
to_utc_timestamp(timestamp, string timezone) - Assumes given timestamp is in given timezone and converts to UTC (as of Hive 0.8.0)
-PREHOOK: query: explain select to_utc_timestamp('2015-02-11 10:30:00', 'PST')
+PREHOOK: query: explain select to_utc_timestamp('2012-02-11 10:30:00', 'PST')
PREHOOK: type: QUERY
-POSTHOOK: query: explain select to_utc_timestamp('2015-02-11 10:30:00', 'PST')
+POSTHOOK: query: explain select to_utc_timestamp('2012-02-11 10:30:00', 'PST')
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -25,58 +25,58 @@ STAGE PLANS:
Row Limit Per Split: 1
Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 2015-02-11 18:30:00.0 (type: timestamp)
+ expressions: 2012-02-11 18:30:00.0 (type: timestamp)
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
ListSink
PREHOOK: query: select
-to_utc_timestamp('2015-02-10 20:30:00', 'PST'),
-to_utc_timestamp('2015-02-11 08:30:00', 'Europe/Moscow'),
-to_utc_timestamp('2015-02-11 12:30:00', 'GMT+8'),
-to_utc_timestamp('2015-02-11 04:30:00', 'GMT'),
-to_utc_timestamp('2015-02-11 04:30:00', ''),
-to_utc_timestamp('2015-02-11 04:30:00', '---'),
+to_utc_timestamp('2012-02-10 20:30:00', 'PST'),
+to_utc_timestamp('2012-02-11 08:30:00', 'Europe/Moscow'),
+to_utc_timestamp('2012-02-11 12:30:00', 'GMT+8'),
+to_utc_timestamp('2012-02-11 04:30:00', 'GMT'),
+to_utc_timestamp('2012-02-11 04:30:00', ''),
+to_utc_timestamp('2012-02-11 04:30:00', '---'),
to_utc_timestamp(cast(null as string), 'PST'),
-to_utc_timestamp('2015-02-11 04:30:00', cast(null as string))
+to_utc_timestamp('2012-02-11 04:30:00', cast(null as string))
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
-to_utc_timestamp('2015-02-10 20:30:00', 'PST'),
-to_utc_timestamp('2015-02-11 08:30:00', 'Europe/Moscow'),
-to_utc_timestamp('2015-02-11 12:30:00', 'GMT+8'),
-to_utc_timestamp('2015-02-11 04:30:00', 'GMT'),
-to_utc_timestamp('2015-02-11 04:30:00', ''),
-to_utc_timestamp('2015-02-11 04:30:00', '---'),
+to_utc_timestamp('2012-02-10 20:30:00', 'PST'),
+to_utc_timestamp('2012-02-11 08:30:00', 'Europe/Moscow'),
+to_utc_timestamp('2012-02-11 12:30:00', 'GMT+8'),
+to_utc_timestamp('2012-02-11 04:30:00', 'GMT'),
+to_utc_timestamp('2012-02-11 04:30:00', ''),
+to_utc_timestamp('2012-02-11 04:30:00', '---'),
to_utc_timestamp(cast(null as string), 'PST'),
-to_utc_timestamp('2015-02-11 04:30:00', cast(null as string))
+to_utc_timestamp('2012-02-11 04:30:00', cast(null as string))
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 NULL NULL
+2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 NULL NULL
PREHOOK: query: select
-to_utc_timestamp(cast('2015-02-10 20:30:00' as timestamp), 'PST'),
-to_utc_timestamp(cast('2015-02-11 08:30:00' as timestamp), 'Europe/Moscow'),
-to_utc_timestamp(cast('2015-02-11 12:30:00' as timestamp), 'GMT+8'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), ''),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), '---'),
+to_utc_timestamp(cast('2012-02-10 20:30:00' as timestamp), 'PST'),
+to_utc_timestamp(cast('2012-02-11 08:30:00' as timestamp), 'Europe/Moscow'),
+to_utc_timestamp(cast('2012-02-11 12:30:00' as timestamp), 'GMT+8'),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT'),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), ''),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), '---'),
to_utc_timestamp(cast(null as timestamp), 'PST'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), cast(null as string))
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), cast(null as string))
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
-to_utc_timestamp(cast('2015-02-10 20:30:00' as timestamp), 'PST'),
-to_utc_timestamp(cast('2015-02-11 08:30:00' as timestamp), 'Europe/Moscow'),
-to_utc_timestamp(cast('2015-02-11 12:30:00' as timestamp), 'GMT+8'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), 'GMT'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), ''),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), '---'),
+to_utc_timestamp(cast('2012-02-10 20:30:00' as timestamp), 'PST'),
+to_utc_timestamp(cast('2012-02-11 08:30:00' as timestamp), 'Europe/Moscow'),
+to_utc_timestamp(cast('2012-02-11 12:30:00' as timestamp), 'GMT+8'),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), 'GMT'),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), ''),
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), '---'),
to_utc_timestamp(cast(null as timestamp), 'PST'),
-to_utc_timestamp(cast('2015-02-11 04:30:00' as timestamp), cast(null as string))
+to_utc_timestamp(cast('2012-02-11 04:30:00' as timestamp), cast(null as string))
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 2015-02-11 04:30:00 NULL NULL
+2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 2012-02-11 04:30:00 NULL NULL