[
https://issues.apache.org/jira/browse/DRILL-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14934208#comment-14934208
]
Parth Chandra commented on DRILL-2908:
--------------------------------------
Documentation note: To use int96 to decode a timestamp (from Hive or Impala)
you need to use the convert_from function with 'TIMESTAMP_IMPALA' as the type.
eg:
SELECT convert_from(timestamp_field, 'TIMESTAMP_IMPALA') as
timestamp_field from dfs.file_with_timestamp.parquet
(This needs to be documented in
https://drill.apache.org/docs/supported-data-types/#convert_to-and-convert_from-data-types
as well).
> Support reading the Parquet int 96 type
> ---------------------------------------
>
> Key: DRILL-2908
> URL: https://issues.apache.org/jira/browse/DRILL-2908
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Parquet
> Reporter: Jason Altekruse
> Assignee: Parth Chandra
> Fix For: 1.2.0
>
>
> While Drill does not currently have an int96 type, it is supported by the
> parquet format and we should be able to read files that contain columns of
> this type. For now we will read the data into a varbinary and users will have
> to use existing convert_from functions or write their own to interpret the
> type of data actually stored. One example is the Impala timestamp format
> which is encoded in an int96 column.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
