[
https://issues.apache.org/jira/browse/SPARK-27881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17921530#comment-17921530
]
Dongjoon Hyun commented on SPARK-27881:
---------------------------------------
Yes, in general, Apache Spark aims to be ANSI compatible as much as possible.
Especially, from Spark 4, we enabled ANSI mode by default, SPARK-44444 .
However, it doesn't limit new adoption of new technologies. For example, we
adopt SQL Pipe syntax, SPARK-49555, in Spark 4.
For this issue, at that time, yes, our expectation was to see more industry
adoptions in other DBMSes for that syntax at least. I didn't track the status
of that syntax. That's the reason why I asked you if there is any update or
additional info for re-evaluation, [~S71955].
> Support CAST (... FORMAT <pattern>) expression
> ----------------------------------------------
>
> Key: SPARK-27881
> URL: https://issues.apache.org/jira/browse/SPARK-27881
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.1.0
> Reporter: Peter Toth
> Priority: Minor
>
> SQL:2016 standard supports the following Cast functions
> {noformat}
> CAST(<datetime> AS <char string type> [FORMAT <template>])
> CAST(<char string> AS <datetime type> [FORMAT <template>])
> {noformat}
> to specify patterns to use during cast.
> Oracle DB 18 already supports a similar formatting option during cast:
> [https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CAST.html]
> There is an initiative in Impala: IMPALA-4018 and Hive HIVE-21575 to support.
> (Please note that accepting the {{CAST (... FORMAT <pattern>)}} is just one
> part of these tickets, the other part regarding patterns is covered here:
> SPARK-27882.)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
