Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive server pushing parquet timestamp values by one hour in BST timezone

hive server pushing parquet timestamp values by one hour in BST timezone

Explorer

'HDP--3.1.4,The table containing the parquet timestamp which has hourly data ,hive server is pushing the hour data into into next date example is shown below , please check before and after 29 th Mar 2020 , where Mar 29 is the BST time settings with day light saving'

| 2020-03-22  | 2020-03-22 00:00:59.0  | 2020-03-22 23:59:59.0  |
| 2020-03-23  | 2020-03-23 00:00:59.0  | 2020-03-23 23:59:59.0  |
| 2020-03-24  | 2020-03-24 00:00:59.0  | 2020-03-24 23:59:59.0  |
| 2020-03-25  | 2020-03-25 00:00:59.0  | 2020-03-25 23:59:59.0  |
| 2020-03-26  | 2020-03-26 00:00:59.0  | 2020-03-26 23:59:59.0  |
| 2020-03-27  | 2020-03-27 00:00:59.0  | 2020-03-27 23:59:59.0  |
| 2020-03-28  | 2020-03-28 00:00:59.0  | 2020-03-28 23:59:59.0  |
| 2020-03-29  | 2020-03-29 00:00:59.0  | 2020-03-30 00:59:59.0  |
| 2020-03-30  | 2020-03-30 01:00:59.0  | 2020-03-31 00:59:59.0  |
| 2020-03-31  | 2020-03-31 01:00:59.0  | 2020-04-01 00:59:59.0  |
| 2020-04-01  | 2020-04-01 01:00:59.0  | 2020-04-02 00:59:59.0  |
| 2020-04-02  | 2020-04-02 01:00:59.0  | 2020-04-03 00:59:59.0  |
Don't have an account?
Coming from Hortonworks? Activate your account here