hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Basjes (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-9252) Linking custom SerDe jar to table definition.
Date Sun, 04 Jan 2015 16:32:34 GMT
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)

Mime
View raw message