phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: TO_DATE function failure in Phoenix 4.3.1 (Bug?)
Date Fri, 24 Jul 2015 19:37:30 GMT
Hi Arun,
Would you mind it on the 4.5 RC we have out and let us know? I suspect it's
fixed.
Thanks,
James

On Fri, Jul 24, 2015 at 10:14 AM, Arun Kumaran Sabtharishi <
arun1087@gmail.com> wrote:

> Dear Phoenix developers and users,
>
> The usage of TO_DATE function to convert varchar to date fails in phoenix
> 4.3.1.
>
> Debugging the phoenix code, the observation is that, it is throwing
> NoClassDefFoundError at ISODateFormatParser class while getting the
> singleton instance of that inner class which is in DateUtil class.
>
> This has been already found and closed in a previous version.
>
> *JIRA link:*
> https://issues.apache.org/jira/browse/PHOENIX-1769
>
>
> *Is this still a bug? *It is 100% reproducible now.
>
> I used the following sqls to create a table, insert data and convert it to
> date while selecting.
>
> CREATE TABLE EMP_TABLE(NAME VARCHAR PRIMARY KEY, DATE_STR VARCHAR);
>
> UPSERT INTO EMP_TABLE VALUES('JAMES TAYLOR', '2014-02-02 11:21:21');
>
> SELECT DATE_STR FROM EMP_TABLE WHERE TO_DATE(DATE_STR) >
> TO_DATE('2001-01-01 05:00:00');
>
>
> Since this is working in 4.0.0 and not in 4.3.1 version to which we
> upgraded recently, we have an alarming situation to downgrade it back to
> 4.0.0. Kindly, let me know a workaround for this and whether this is a
> valid bug.
>
> [image: Inline image 1]
>
>
> Thanks,
> Arun
>

Mime
View raw message