spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wenchen Fan (Jira)" <j...@apache.org>
Subject [jira] [Assigned] (SPARK-31507) Remove millennium, century, decade, millisecond, microsecond and epoch from extract fucntion
Date Wed, 22 Apr 2020 10:26:00 GMT

     [ https://issues.apache.org/jira/browse/SPARK-31507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Wenchen Fan reassigned SPARK-31507:
-----------------------------------

    Assignee: Kent Yao

> Remove millennium, century, decade, millisecond, microsecond and epoch from extract fucntion
> --------------------------------------------------------------------------------------------
>
>                 Key: SPARK-31507
>                 URL: https://issues.apache.org/jira/browse/SPARK-31507
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Kent Yao
>            Assignee: Kent Yao
>            Priority: Major
>
> Extracting millennium, century, decade, millisecond, microsecond and epoch from datetime
is neither ANSI standard nor quite common in modern SQL platforms. None of the systems listing
below support these except PostgreSQL.
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
> https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm
> https://prestodb.io/docs/current/functions/datetime.html
> https://docs.cloudera.com/documentation/enterprise/5-8-x/topics/impala_datetime_functions.html
> https://docs.snowflake.com/en/sql-reference/functions-date-time.html#label-supported-date-time-parts
> https://www.postgresql.org/docs/9.1/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
> https://docs.teradata.com/reader/kmuOwjp1zEYg98JsB8fu_A/SIkE2wnHyQBnU4AGWRZSRw



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message