[HIVE-3844] Unix timestamps don't seem to be read correctly from HDFS as Timestamp column

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.8.0
• Component/s: Serializers/Deserializers
• Assignee: Venki Korukanti
• Reporter: Mark Grover
• Created: 28/Dec/12 18:26
• Updated: 16/Dec/16 16:44

Description

Serega Shepak pointed out that something like

select cast(date_occurrence as timestamp) from xvlr_data limit 10

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.

Issue Links

• contains: HIVE-13435 Hive fails to read timestamp stored as binary / int64 from externally generated parquet files
• relates to: HIVE-3822 Casting from double to timestamp type seems inconsistent
• relates to: HIVE-9298 Support reading alternate timestamp formats
• relates to: HIVE-4803 LazyTimestamp should accept numeric values