[SPARK-29391] Default year-month units

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 08/Oct/19 11:00
• Updated: 03/Feb/21 13:43
• Resolved: 03/Feb/21 13:34

Description

PostgreSQL can assume default year-month units by defaults:

maxim=# SELECT interval '1-2'; 
   interval    
---------------
 1 year 2 mons

but the same produces NULL in Spark: