[jira] [Updated] (SPARK-29024) Ignore case while resolving time zones

["Maxim Gekk (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-29024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maxim Gekk updated SPARK-29024:
-------------------------------
    Summary: Ignore case while resolving time zones  (was: Support the `zulu` time zone)

> Ignore case while resolving time zones
> --------------------------------------
>
>                 Key: SPARK-29024
>                 URL: https://issues.apache.org/jira/browse/SPARK-29024
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Maxim Gekk
>            Priority: Minor
>
> The `zulu` time zone is checked by https://github.com/apache/spark/blob/67b4329fb08fd606461aa1ac9274c4a84d15d70e/sql/core/src/test/resources/sql-tests/inputs/pgSQL/timestamp.sql#L31 but `getZoneId` fails on resolving it:
> {code}
> scala> getZoneId("zulu")
> java.time.zone.ZoneRulesException: Unknown time-zone ID: zulu
>   at java.time.zone.ZoneRulesProvider.getProvider(ZoneRulesProvider.java:272)
>   at java.time.zone.ZoneRulesProvider.getRules(ZoneRulesProvider.java:227)
>   at java.time.ZoneRegion.ofId(ZoneRegion.java:120)
>   at java.time.ZoneId.of(ZoneId.java:411)
>   at java.time.ZoneId.of(ZoneId.java:359)
>   at java.time.ZoneId.of(ZoneId.java:315)
>   at org.apache.spark.sql.catalyst.util.DateTimeUtils$.getZoneId(DateTimeUtils.scala:77)
>   ... 49 elided
> {code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org