[ 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)