Kent Yao created SPARK-31119:
--------------------------------
Summary: 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: Bug
Components: SQL
Affects Versions: 3.0.0, 3.1.0
Reporter: Kent Yao
{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
