[SPARK-29383] Support the optional prefix `@` in interval strings

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 08/Oct/19 09:44
• Updated: 29/Mar/20 02:16

Description

PostgreSQL allows `@` at the beginning and `ago` at the end of interval strings:

maxim=# select interval '@ 14 seconds';
 interval 
----------
 00:00:14

See https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-INPUT