Re: Introduce FORMAT clause to CAST with SQL:2016 datetime patterns

2019-04-02 Thread Gabor Kaszab
Thanks for the feedback! As I haven't received any comments recently and I hope I have addresses the previous ones I'll advance to the next step and open the related jiras for both Spark and Hive. Cheers, Gabor On Thu, Mar 21, 2019 at 12:00 PM Gabor Kaszab wrote: > Thanks for the quick

Re: Introduce FORMAT clause to CAST with SQL:2016 datetime patterns

2019-03-21 Thread Gabor Kaszab
Thanks for the quick feedbacks, Maciej and Shawn! Maciej: The concern about confusing users with supporting multiple datetime patterns is a valid one. The cleanest way to introduce SQL:2016 patterns would be to drop the existing pattern support (SimpleDateFormat in case of Impala) and replace it

Re: Introduce FORMAT clause to CAST with SQL:2016 datetime patterns

2019-03-20 Thread Shawn Weeks
I’ve done some work on a to timestamp function for hive and one of the things I keep running into is most date time libraries don’t support fractional seconds for their format patterns yet most rdbms do support fractional seconds. It tends to trip things up when your porting sql over. If we’re

Introduce FORMAT clause to CAST with SQL:2016 datetime patterns

2019-03-20 Thread Gabor Kaszab
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: https://issues.apache.org/jira/browse/IMPALA-4018 One example of the