Repository: hive Updated Branches: refs/heads/master dab8cc012 -> 307bbca96
HIVE-20599: CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException (Naresh P R reviewed by Prasanth Jayachandran) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/307bbca9 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/307bbca9 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/307bbca9 Branch: refs/heads/master Commit: 307bbca96c8bc845183db3608e5ef508a17a8bf4 Parents: dab8cc0 Author: nareshpr <prnaresh.nar...@gmail.com> Authored: Tue Sep 25 10:12:28 2018 -0700 Committer: Prasanth Jayachandran <prasan...@apache.org> Committed: Tue Sep 25 10:14:26 2018 -0700 ---------------------------------------------------------------------- .../test/queries/clientpositive/udf_to_string.q | 2 ++ .../results/clientpositive/udf_to_string.q.out | 18 ++++++++++++++++++ 2 files changed, 20 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/307bbca9/ql/src/test/queries/clientpositive/udf_to_string.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/udf_to_string.q b/ql/src/test/queries/clientpositive/udf_to_string.q index 818f80f..4bb6220 100644 --- a/ql/src/test/queries/clientpositive/udf_to_string.q +++ b/ql/src/test/queries/clientpositive/udf_to_string.q @@ -17,3 +17,5 @@ SELECT CAST(CAST(-3.14 AS DECIMAL(3,2)) AS STRING) FROM src tablesample (1 rows) SELECT CAST('Foo' AS STRING) FROM src tablesample (1 rows); +SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); +SELECT CAST(interval_year_month('1-2') AS STRING); http://git-wip-us.apache.org/repos/asf/hive/blob/307bbca9/ql/src/test/results/clientpositive/udf_to_string.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udf_to_string.q.out b/ql/src/test/results/clientpositive/udf_to_string.q.out index bf2f72d..fc888a1 100644 --- a/ql/src/test/results/clientpositive/udf_to_string.q.out +++ b/ql/src/test/results/clientpositive/udf_to_string.q.out @@ -88,3 +88,21 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### Foo +PREHOOK: query: SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +17624 00:30:30.000000000 +PREHOOK: query: SELECT CAST(interval_year_month('1-2') AS STRING) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +POSTHOOK: query: SELECT CAST(interval_year_month('1-2') AS STRING) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +1-2