[HIVE-9482] Hive parquet timestamp compatibility

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.15.0
• Fix Version/s: 1.2.0
• Component/s: File Formats
• Assignee: Szehon Ho
• Reporter: Szehon Ho
• Created: 27/Jan/15 22:57
• Updated: 16/Nov/16 18:16
• Resolved: 30/Jan/15 07:49

Description

In current Hive implementation, timestamps are stored in UTC (converted from current timezone), based on original parquet timestamp spec.

However, we find this is not compatibility with other tools, and after some investigation it is not the way of the other file formats, or even some databases (Hive Timestamp is more equivalent of 'timestamp without timezone' datatype).

This is the first part of the fix, which will restore compatibility with parquet-timestamp files generated by external tools by skipping conversion on reading.

Later fix will change the write path to not convert, and stop the read-conversion even for files written by Hive itself.

Issue Links

• relates to: HIVE-6394 Implement Timestmap in ParquetSerde
• links to: review board