[jira] [Updated] (HIVE-6423) Read Timestamps and Dates from Avro files (stored as Strings in ISO format)

["Nick White (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-6423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nick White updated HIVE-6423:
-----------------------------

    Attachment: HIVE-6423.patch

> Read Timestamps and Dates from Avro files (stored as Strings in ISO format)
> ---------------------------------------------------------------------------
>
>                 Key: HIVE-6423
>                 URL: https://issues.apache.org/jira/browse/HIVE-6423
>             Project: Hive
>          Issue Type: New Feature
>          Components: HiveServer2
>    Affects Versions: 0.12.0
>            Reporter: Nick White
>         Attachments: HIVE-6423.patch
>
>
> Avro doesn't have native timestamp or date data types. Some tools (e.g. apache Sqoop) work around this by adding the java.sql.Types type number as an "sqlType" attribute to the Avro schema JSON field element. The attached patch makes the Avro SerDe look for an sqlType attribute, and if it is a Hive primitive type that's not an Avro primitive type (i.e. timestamp and date) it returns the appropriate Hive type (the one corresponding to the SQL type).



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)