[DRILL-4373] Drill and Hive have incompatible timestamp representations in parquet

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.10.0
• Component/s: Storage - Hive, Storage - Parquet
• Labels: doc-impacting
• Assignee: Vitalii Diravka
• Reporter: Rahul Kumar Challapalli
• Reviewer: Krystal
• Created: 08/Feb/16 21:50
• Updated: 31/Mar/17 23:01
• Resolved: 03/Mar/17 08:44

Description

git.commit.id.abbrev=83d460c

I created a parquet file with a timestamp type using Drill. Now if I define a hive table on top of the parquet file and use "timestamp" as the column type, drill fails to read the hive table through the hive storage plugin

Implementation:

Added int96 to timestamp converter for both parquet readers and controling it by system / session option "store.parquet.int96_as_timestamp".
The value of the option is false by default for the proper work of the old query scripts with the "convert_from TIMESTAMP_IMPALA" function.

When the option is true using of that function is unnesessary and can lead to the query fail.

Issue Links

• breaks: DRILL-5034 Select timestamp from hive generated parquet always return in UTC
• links to: GitHub Pull Request #600