[SPARK-29187] Return null from `date_part()` for the null `field`

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 20/Sep/19 08:08
• Updated: 10/Apr/20 13:52
• Resolved: 21/Sep/19 03:29

Description

PostgreSQL return NULL for the NULL field from the date_part() function:

maxim=# select date_part(null, date'2019-09-20');
 date_part 
-----------
          
(1 row)

but Spark fails with the error:

spark-sql> select date_part(null, date'2019-09-20');
Error in query: null; line 1 pos 7

Issue Links

• links to: GitHub Pull Request #25865