...
- Default Value:
DATETIME
- Added In: Hive 4.0.0 with
,Jira server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key HIVE-25576 Jira server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key HIVE-27673
The formatter to use for handling datetime values. The possible values are:
- DATETIME: For using java.time.format.DateTimeFormatter
- SIMPLE: For using java.text.SimpleDateFormat (known bugs: HIVE-25458, HIVE-25403, HIVE-25268)
Currently the configuration only affects the behavior of the following SQL functions:
- unix_timestamp(string,[string])
- from_unixtime
- date_format
The SIMPLE formatter exists purely for compatibility purposes with previous versions of Hive thus its use is discouraged. It suffers from known bugs that are unlikely to be fixed in subsequent versions of the product. Furthermore, using SIMPLE formatter may lead to strange behavior, and unexpected results when combined with SQL functions/operators that are using the new DATETIME formatter.
...