Joe McDonnell created IMPALA-14550:
--------------------------------------
Summary: Revisit AS OF behavior / messages during Daylight Saving
clock changeover
Key: IMPALA-14550
URL: https://issues.apache.org/jira/browse/IMPALA-14550
Project: IMPALA
Issue Type: Task
Components: Frontend
Affects Versions: Impala 5.0.0
Reporter: Joe McDonnell
Some Impala tests ran during the USA daylight savings backward time clock
adjustment (where the period from 1am to 2am happens twice). Some Iceberg tests
using AS OF failed with this message:
{noformat}
Invalid TIMESTAMP expression: UDF WARNING: Timestamp '2025-11-02
01:31:25.984641000' in timezone 'America/Los_Angeles' could not be converted to
UTC{noformat}
This makes sense as that time period happens twice, so there is ambiguity about
what UTC value this corresponds to. We should think about having a better error
message for this case.
Some tests that use now() also failed. now() is defined as the local time zone,
so it doesn't make sense for it to behave differently from a manually specific
time. We should think about whether there are ways to use this functionality
during this time change. If we don't think that is possible or useful, we
should document this limitation.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
