Stamatis Zampetakis created HIVE-29255:
------------------------------------------
Summary: Document effects of JDK/tzdata on operations involving
DATETIME and TIMESTAMP data types
Key: HIVE-29255
URL: https://issues.apache.org/jira/browse/HIVE-29255
Project: Hive
Issue Type: Task
Components: Website
Reporter: Stamatis Zampetakis
Various functions and operations involving DATETIME and TIMESTAMP data types
rely on JDK APIs in {{java.time}} package. The results of these APIs are
strongly affected by changes in the [Time Zone
Database|https://www.iana.org/time-zones](tzdata). Different JDK providers and
versions package different tzdata versions thus changing the JDK and/or
Timezone provider can lead to different results in SQL queries and elsewhere.
Although, JDK/tzdata changes are outside the control of Hive we should document
this potential behavior change somewhere so that users are aware.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
