Page History

...

• 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.

...