[ https://issues.apache.org/jira/browse/SPARK-31119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan resolved SPARK-31119. --------------------------------- Fix Version/s: 3.0.0 Resolution: Fixed Issue resolved by pull request 27876 [https://github.com/apache/spark/pull/27876] > Add interval value support for extract expression as source > ----------------------------------------------------------- > > Key: SPARK-31119 > URL: https://issues.apache.org/jira/browse/SPARK-31119 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.1.0 > Reporter: Kent Yao > Assignee: Kent Yao > Priority: Major > Fix For: 3.0.0 > > > {code:java} > <extract expression> ::= EXTRACT <left paren> <extract field> FROM <extract > source> <right paren> > <extract source> ::= <datetime value expression> | <interval value expression> > {code} > We now only support datetime values as extract source for expression but it's > alternative function `date_part` supports both datetime and interval. > For ANSI compliance and the consistency between extract and `date_part`, we > support intervals for extract expressions. -- 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