spark-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabor Kaszab <>
Subject Introduce FORMAT clause to CAST with SQL:2016 datetime patterns
Date Wed, 20 Mar 2019 09:53:34 GMT
Hey Hive and Spark communities,
[dev@impala in cc]

I'm working on an Impala improvement to introduce the FORMAT clause within
CAST() operator and to implement ISO SQL:2016 datetime pattern support for
this new FORMAT clause:

One example of the new format:
SELECT(CAST("2018-01-02 09:15" as timestamp FORMAT "YYYY-MM-DD HH12:MI"));

I have put together a document for my proposal of how to do this in Impala
and what patterns we plan to support to cover the SQL standard and what
additional patterns we propose to support on top of the standard's

The reason I share this with the Hive and Spark communities because I feel
it would be nice that these systems were in line with the Impala
implementation. So I'd like to involve these communities to the planning
phase of this task so that everyone can share their opinion about whether
this make sense in the proposed form.
Eventually I feel that each of these systems should have the SQL:2016
datetime format and I think it would be nice to have it with a newly
introduced CAST(..FORMAT..) clause.

I would like to ask members from both Hive and Spark to take a look at my
proposal and share their opinion from their own component's perspective. If
we get on the same page I'll eventually open Jiras to cover this
improvement for each mentioned systems.


View raw message