[SPARK-35773] Parse year-month interval literals to tightest types

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: Kousuke Saruta
• Reporter: Max Gekk
• Created: 15/Jun/21 16:38
• Updated: 13/Jul/21 12:28
• Resolved: 13/Jul/21 12:28

Description

Modify AstBuilder.visitInterval to parse year-month interval literals to tightest types. For example:
INTERVAL '10' YEAR should be parsed as YearMonthIntervalType(YEAR, YEAR) but not as YearMonthIntervalType(YEAR, MONTH).

Issue Links

• duplicates: SPARK-35076 Parse interval literals as ANSI intervals
• is a clone of: SPARK-35737 Parse day-time interval literals to tightest types
• is blocked by: SPARK-35680 Support fields by year-month interval type
• is blocked by: SPARK-35704 Support fields by the day-time interval type
• links to: [Github] Pull Request #32892 (sarutak)
• links to: [Github] Pull Request #32892 (sarutak)
• links to: [Github] Pull Request #32905 (sarutak)
• links to: [Github] Pull Request #32905 (sarutak)
• links to: [Github] Pull Request #32949 (sarutak)
• links to: [Github] Pull Request #32949 (sarutak)
• links to: [Github] Pull Request #32949 (sarutak)