Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 12 Feb 2015 01:52:12 +0000 (UTC)
From: "Ferdinand Xu (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12764791.1420389136000.21357.1423705932432@Atlassian.JIRA>
In-Reply-To: <JIRA.12764791.1420389136000@Atlassian.JIRA>
References: <JIRA.12764791.1420389136000@Atlassian.JIRA>
 <JIRA.12764791.1420389136911@arcas>
Subject: [jira] [Updated] (HIVE-9252) Linking custom SerDe jar to table
 definition.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Ferdinand Xu updated HIVE-9252:
-------------------------------
    Status: Patch Available  (was: Open)

> 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
>         Attachments: HIVE-9252.1.patch, HIVE-9252.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
(v6.3.4#6332)