[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Bergeron updated HIVE-3454: -------------------------------- Labels: newbie newdev patch (was: ) Status: Patch Available (was: Open) Using java.sql.Date instead of java.util.Date because java.sql.Date implements a timezone agnostic method of representing timestamps (always UTC, which is what a unix epoch timestamp is defined as) > Problem with CAST(BIGINT as TIMESTAMP) > -------------------------------------- > > Key: HIVE-3454 > URL: https://issues.apache.org/jira/browse/HIVE-3454 > Project: Hive > Issue Type: Bug > Components: Types, UDF > Affects Versions: 0.9.0, 0.8.1, 0.8.0 > Reporter: Ryan Harris > Labels: patch, newbie, newdev > Attachments: HIVE-3454.1.patch.txt > > > Ran into an issue while working with timestamp conversion. > CAST(unix_timestamp() as TIMESTAMP) should create a timestamp for the current > time from the BIGINT returned by unix_timestamp() > Instead, however, a 1970-01-16 timestamp is returned. -- 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