[SPARK-43492] Define the DATE_ADD and DATE_DIFF functions with 3-args

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 13/May/23 11:12
• Updated: 15/May/23 02:14
• Resolved: 15/May/23 02:14

Description

Spark supports the DATE_ADD and DATE_DIFF functions with 2 arguments but when an user calls the same functions with 3 arguments, Spark SQL outputs the confusing error:

spark-sql (default)> select date_add(MONTH, 1, date'2023-05-13');
[UNRESOLVED_COLUMN.WITHOUT_SUGGESTION] A column or function parameter with name `MONTH` cannot be resolved. ; line 1 pos 16;
'Project [unresolvedalias('date_add('MONTH, 1, 2023-05-13), None)]
+- OneRowRelation