Value cannot be cast to timestamp for the beginning of the Daylight saving time

[mbasmanova]

Presto fails to cast the timestamp representing the beginning of the Daylight saving time:

presto> select cast(varchar '2017-03-12 02:00:00' as timestamp);
Query 20181017_170049_38639_mwuxk failed: Value cannot be cast to timestamp: 2017-03-12 02:00:00

[rschlussel]

what would the correct behavior be? 2am does not exist on the day we switch to DST. The same way you can't have a timestamp 2017-03-12 24:00:00.

[haozhun]

This is a known issue. It should work because "TIMESTAMP" should have LocalDateTime semantics. However, "TIMESTAMP" in Hive has Instant semantics. Presto screwed up and gave "TIMESTAMP" Instant semantics. With Instant semantics, failing is the right behavior. (Potentially, there could be a lenient version in a function.)

This code will work if the new semantics is turned on. But the new semantics is not ready due to lack of connector support. And the new semantics is completely different.

See #10326

[findepi]

Closing in favor of #7122 and #10326