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)