[
https://issues.apache.org/jira/browse/SPARK-27881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17921470#comment-17921470
]
Sujith Chacko edited comment on SPARK-27881 at 1/27/25 5:33 PM:
----------------------------------------------------------------
We observed that this feature is supported in Hive, and our customers who want
to leverage the same functionality in Spark are facing roadblocks due to its
absence. We wanted to understand if the reason Spark does not support this
feature is that it does not appear to align with the ANSI SQL standard?
[~dongjoon]
was (Author: s71955):
We observed that this feature is supported in Hive, and our customers who want
to leverage the same functionality in Spark are facing roadblocks due to its
absence. We wanted to understand if the reason Spark does not support this
feature is that it does not appear to align with the ANSI SQL standard?
> 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
