Niels Basjes created HIVE-9252:
----------------------------------
Summary: 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
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
(v6.3.4#6332)
