Kent Yao created SPARK-31469:
--------------------------------
Summary: Make extract interval field ANSI compliance
Key: SPARK-31469
URL: https://issues.apache.org/jira/browse/SPARK-31469
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.0.0, 3.1.0
Reporter: Kent Yao
Currently, we can extract
millennium/century/decade/year/quarter/month/week/day/hour/minute/second(with
fractions)//millisecond/microseconds and epoch from interval values
millennium/century/decade/year means how many the interval months part can be
converted to that unit-value.
while month/day and so on, the integral remainder of the previous unit.
while getting epoch we have treat month as 30 days which varies the natural
Calendar rules we use.
To avoid ambiguity, I suggest we should only support those extract field
defined ANSI with their abbreviations.
--
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
