Mark Grover created HIVE-3844: --------------------------------- Summary: Unix timestamps don't seem to be read correctly from HDFS Key: HIVE-3844 URL: https://issues.apache.org/jira/browse/HIVE-3844 Project: Hive Issue Type: Bug Components: Serializers/Deserializers Affects Versions: 0.8.1 Reporter: Mark Grover Assignee: Mark Grover
Serega Shepak pointed out that something like {code} select cast(date_occurrence as timestamp) from xvlr_data limit 10 {code} where date_occurrence has BIGINT type (timestamp in milliseconds) works. But it doesn't work if the declared type is TIMESTAMP on column. The data in the date_occurence column in unix timestamp in millis. -- 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