You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mark Grover (JIRA)" <ji...@apache.org> on 2012/12/19 20:37:13 UTC
[jira] [Created] (HIVE-3822) Casting from double to timestamp type
seems inconsistent
Mark Grover created HIVE-3822:
---------------------------------
Summary: Casting from double to timestamp type seems inconsistent
Key: HIVE-3822
URL: https://issues.apache.org/jira/browse/HIVE-3822
Project: Hive
Issue Type: Bug
Affects Versions: 0.9.0
Reporter: Mark Grover
Assignee: Mark Grover
{code}
select cast(1355944339 as timestamp) from decimal_3 limit 1;
1970-01-16 08:39:04.339
select cast(1355944339000 as timestamp) from decimal_3 limit 1;
2012-12-19 11:12:19
select cast(1355944339.123456789 as timestamp) from decimal_3 limit 1;
2012-12-19 11:12:19.1234567
{code}
If specifying the unixTimestamp without a decimal point, we need to specify the millisecond timestamp. If specifying with a decimal point, we need to specify only the second timestamp and the rest goes after decimal. Moreover, it seems like some precision is lost (notice '89' are lost in the last query.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira