| ==== |
| ---- QUERY |
| SET timezone="Asia/Kuala_Lumpur"; |
| SELECT * FROM hive_kuala_lumpur_legacy; |
| ---- RESULTS |
| 1899-12-31 16:00:00 |
| 1909-12-31 17:00:00 |
| 1934-12-31 16:40:00 |
| 1939-12-31 16:40:00 |
| 1941-12-31 16:30:00 |
| 1943-12-31 15:00:00 |
| 1969-01-28 16:30:00 |
| 1999-12-31 16:00:00 |
| ==== |
| ---- QUERY |
| SET timezone="Asia/Kuala_Lumpur"; |
| SET convert_legacy_hive_parquet_utc_timestamps=true; |
| SELECT * FROM hive_kuala_lumpur_legacy; |
| ---- RESULTS |
| 1900-01-01 00:00:00 |
| 1910-01-01 00:00:00 |
| 1935-01-01 00:00:00 |
| 1940-01-01 00:00:00 |
| 1942-01-01 00:00:00 |
| 1944-01-01 00:00:00 |
| 1969-01-29 00:00:00 |
| 2000-01-01 00:00:00 |
| ==== |
