Jihoon Son created TAJO-763:
-------------------------------
Summary: Out of range problem in utc_usec_to()
Key: TAJO-763
URL: https://issues.apache.org/jira/browse/TAJO-763
Project: Tajo
Issue Type: Bug
Components: function/udf
Reporter: Jihoon Son
Priority: Minor
Fix For: 0.8-incubating
When I run the following query using the utc_usec_to function, I met an out of
range error.
Since this problem occurs only when converting to hour, it seems to relate with
the time zone.
{noformat}
default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05
08:00:00')::INT8*1000);
result: 1 rows (9 B)
?utc_usec_to
-------------------------------
1365116400000000
default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05
09:00:00')::INT8*1000);
Value 24 for hourOfDay must be in the range [0,23]
{noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
