[jira] [Commented] (HIVE-22397) "describe table" statement for the table backed by custom storage handler fail with CNF

["Naveen Gangam (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-22397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967134#comment-16967134 ] 

Naveen Gangam commented on HIVE-22397:
--------------------------------------

[~Rajkumar Singh] Are you running this reproducer from Hive CLI or from beeline? The {{ADD JAR}} is a carry-over from the hive CLI fat client era. Its not really ideal to be used in the beeline/hiveserver2 model.
The recommended way to configure custom UDFs and SerDes with HiveServer to is to use {{hive.aux.jars.path}} or {{hive.reloadable.aux.jars.path}} to have a user-configurable location for such central resources on the server side. Once configured, the users can just drop jars into this directory/path, without having to restart the HS2. Then there would not be a need for {{add jars}} from any of the beeline sessions. Please refer to the documentation below. 

https://docs.cloudera.com/documentation/enterprise/5-9-x/topics/cm_mc_hive_udf.html#concept_t1x_srm_2r

> "describe table"  statement for the table backed by custom storage handler fail with CNF
> ----------------------------------------------------------------------------------------
>
>                 Key: HIVE-22397
>                 URL: https://issues.apache.org/jira/browse/HIVE-22397
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 3.1.2
>            Reporter: Rajkumar Singh
>            Assignee: Rajkumar Singh
>            Priority: Major
>         Attachments: HIVE-22397.patch
>
>
> Steps to Repro:
> {code:java}
> 1) describe customsdtable;
> 2) ADD JAR hdfs:///user/hive/customsdtable.jar;
> 3) describe customsdtable;
> CNF is expected for #1 but even adding the custome serde, hive fail with following exception for statement #3
> Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.ClassNotFoundException
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)