[CALCITE-5776] Support for alternative Interval syntax

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: Guillaume Massé
• Created: 13/Jun/23 21:41
• Updated: 13/Jun/23 23:14

Description

spark.sql("select (CURRENT_DATE - INTERVAL '7 DAYS') ").show
+-----------------------------------------------------------------------+
|date_add(current_date(), (- extractansiintervaldays(INTERVAL '7' DAY)))|
+-----------------------------------------------------------------------+
|                                                             2023-06-06|
+-----------------------------------------------------------------------+ 

currently the parser does not allows:

INTERVAL '7 DAYS' 

it only accepts:

INTERVAL '7' DAYS 

 

Issue Links

• is related to: CALCITE-4134 Interval expressions
• is related to: CALCITE-3383 Allow plural time units in interval literals