[
https://issues.apache.org/jira/browse/HIVE-9252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16562272#comment-16562272
]
Shawn Weeks commented on HIVE-9252:
-----------------------------------
Can we make this also support loading the InputFormat and RecordReader this
way? Many times with more unusual formats you'll need more than just a Serde to
read it.
> Linking custom SerDe jar to table definition.
> ---------------------------------------------
>
> Key: HIVE-9252
> URL: https://issues.apache.org/jira/browse/HIVE-9252
> Project: Hive
> Issue Type: New Feature
> Components: Serializers/Deserializers
> Reporter: Niels Basjes
> Assignee: Ferdinand Xu
> Priority: Major
> Attachments: HIVE-9252.1.patch
>
>
> In HIVE-6047 the option was created that a jar file can be hooked to the
> definition of a function. (See: [Language Manual DDL: Permanent
> Functions|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-PermanentFunctions]
> )
> I propose to add something similar that can be used when defining an external
> table that relies on a custom Serde (I expect to usually only have the
> Deserializer).
> Something like this:
> {code}
> CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name
> ...
> STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (...)]
> [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> {code}
> Using this you can define (and share !!!) a Hive table on top of a custom
> fileformat without the need to let the IT operations people deploy a custom
> SerDe jar file on all nodes.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
