Maxim Gekk created SPARK-29524:
----------------------------------
Summary: Unordered interval units
Key: SPARK-29524
URL: https://issues.apache.org/jira/browse/SPARK-29524
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 2.4.4
Reporter: Maxim Gekk
Currently, Spark requires particular order of interval units in casting from
strings - `YEAR` .. `MICROSECOND`. PostgreSQL allows any order:
{code}
maxim=# select interval '1 second 2 hours';
interval
----------
02:00:01
(1 row)
{code}
but Spark fails on while parsing:
{code}
spark-sql> select interval '1 second 2 hours';
NULL
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]