[ https://issues.apache.org/jira/browse/SPARK-29187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan updated SPARK-29187: -------------------------------- Parent Issue: SPARK-31415 (was: SPARK-30375) > Return null from `date_part()` for the null `field` > --------------------------------------------------- > > Key: SPARK-29187 > URL: https://issues.apache.org/jira/browse/SPARK-29187 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Maxim Gekk > Assignee: Maxim Gekk > Priority: Minor > Fix For: 3.0.0 > > > PostgreSQL return NULL for the NULL field from the date_part() function: > {code} > maxim=# select date_part(null, date'2019-09-20'); > date_part > ----------- > > (1 row) > {code} > but Spark fails with the error: > {code} > spark-sql> select date_part(null, date'2019-09-20'); > Error in query: null; line 1 pos 7 > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org