[
https://issues.apache.org/jira/browse/HIVE-5275?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14061808#comment-14061808
]
Jens Schmitt commented on HIVE-5275:
------------------------------------
*before hive2:*
{code}
hive>create external table ext_test_table
>(
> id int,
> value string
>)
>ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
>location 'hdfs://hadoopHDFSCluster/mytestdir'
>;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde:
org.openx.data.jsonserde.JsonSerDe
{code}
then i added the following to hive-site.xml:
{code}
<property>
<name>hive.aux.jars.path</name>
<value>/usr/lib/hive/lib/hive-serde-json.jar</value>
</property>
{code}
and after that:
{code}
hive>create external table ext_test_table
>(
> id int,
> value string
>)
>ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
>location 'hdfs://hadoopHDFSCluster/mytestdir'
>;
OK
Time taken: 0.15 seconds
{code}
========================================================================================
*with hive2* it just remains the same error... it only works if add the jar
manually in every hive session:
{code}
hive>add jar /data/home/jschmitt/hive-json-serde-1.1.9.2.jar;
Added hive-json-serde-1.1.9.2.jar to class path
Added resource: hive-json-serde-1.1.9.2.jar
{code}
the same applys of course for selecting from that external table... and so on
> HiveServer2 should respect hive.aux.jars.path property and add aux jars to
> distributed cache
> --------------------------------------------------------------------------------------------
>
> Key: HIVE-5275
> URL: https://issues.apache.org/jira/browse/HIVE-5275
> Project: Hive
> Issue Type: Improvement
> Components: HiveServer2
> Reporter: Alex Favaro
>
> HiveServer2 currently ignores the hive.aux.jars.path property in
> hive-site.xml. That means that the only way to use a custom SerDe is to add
> it to AUX_CLASSPATH on the server and manually distribute the jar to the
> cluster nodes. Hive CLI does this automatically when hive.aux.jars.path is
> set. It would be nice if HiverServer2 did the same.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
