Jesus Camacho Rodriguez created HIVE-24157:
----------------------------------------------
Summary: Strict mode to fail on CAST timestamp <-> numeral
Key: HIVE-24157
URL: https://issues.apache.org/jira/browse/HIVE-24157
Project: Hive
Issue Type: Improvement
Components: SQL
Reporter: Jesus Camacho Rodriguez
There is some interest in enforcing that CAST numeral <-> timestamp is
disallowed to avoid confusion among users, e.g., SQL standard does not allow
numeral <-> timestamp casting, timestamp type is timezone agnostic, etc.
We should introduce a strict config for timestamp (similar to others before):
If the config is true, we shall fail while compiling the query with a
meaningful message.
To provide similar behavior, Hive has multiple functions that provide clearer
semantics for numeral to timestamp conversion (and vice versa):
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
