[SPARK-23264] Support interval values without INTERVAL clauses

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Later
• Affects Version/s: 2.2.1
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Takeshi Yamamuro
• Reporter: Takeshi Yamamuro
• Created: 30/Jan/18 06:13
• Updated: 07/Jan/20 17:17
• Resolved: 03/Jan/20 20:52

Description

The master currently cannot parse a SQL query below;

SELECT cast('2017-08-04' as date) + 1 days;

Since other dbms-like systems support this syntax (e.g., hive and mysql), it might help to support in spark.

Issue Links

• links to: [Github] Pull Request #20433 (maropu)
• links to: [Github] Pull Request #20872 (maropu)
• links to: GitHub Pull Request #20433
• links to: GitHub Pull Request #27080