[SPARK-36022] Respect interval fields in extract

• 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: 05/Jul/21 19:53
• Updated: 08/Jul/21 06:41
• Resolved: 08/Jul/21 06:41

Description

Extract should process only existing fields of interval types. For example:

spark-sql> SELECT EXTRACT(MONTH FROM INTERVAL '2021-11' YEAR TO MONTH);
11
spark-sql> SELECT EXTRACT(MONTH FROM INTERVAL '2021' YEAR);
0

The last command should fail as the month field doesn't present in INTERVAL YEAR.

Issue Links

• links to: [Github] Pull Request #33247 (sarutak)
• links to: [Github] Pull Request #33247 (sarutak)