Page History

...

If set to true, order/sort by without limit in subqueries and views will be removed.

Datetime

hive.datetime.formatter

• Default Value: DATETIME
• Added In: Hive 4.0.0 with

  Jira
  server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key HIVE-25576

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)

Currently the configuration only affects the behavior of the following SQL functions:

• unix_timestamp(string,[string])
• from_unixtime

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.

SerDes and ISerDes and I/O

SerDes

hive.script.serde

...