[SPARK-29524] Unordered interval units

• Type: Sub-task
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 20/Oct/19 09:01
• Updated: 05/Jun/20 19:41

Description

Currently, Spark requires particular order of interval units in casting from strings - `YEAR` .. `MICROSECOND`. PostgreSQL allows any order:

maxim=# select interval '1 second 2 hours';
 interval
----------
 02:00:01
(1 row)

but Spark fails on while parsing:

spark-sql> select interval '1 second 2 hours';
NULL

Issue Links

• links to: GitHub Pull Request #26180