[
https://issues.apache.org/jira/browse/SPARK-31469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenchen Fan resolved SPARK-31469.
---------------------------------
Fix Version/s: 3.0.0
Resolution: Fixed
Issue resolved by pull request 28242
[https://github.com/apache/spark/pull/28242]
> 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
> Assignee: Kent Yao
> Priority: Major
> Fix For: 3.0.0
>
>
> 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
