"ERROR: Class org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe not found" when running Hive LLAP Queries Using MultiDelimiterSerde

SupportKB

Problem Description:
When running Hive LLAP Queries using MultiDelimiterSerde, it fails with the following error: 

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassNotFoundException: 
Class org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe not found

The issue persists even after adding a link to /usr/hdp/current/hive-server2-hive2/lib/hive-contrib.jar
under /usr/hdp/current/hive-server2-hive2/auxlib just like Hive 1.2.
Cause:
This is an issue because hive-contrib.jar is not included in the LLAP package. This is a Product Defect ( HIVE-16076).
 
Solution:


Workaround Add the hive-contrib.jar path(hive.aux.jars.path) in hive-interatcive-site.xml through Ambari Hive configs.

About:
This article created by Hortonworks Support (Article: 000006754) on 2017-12-11 11:06
OS: n/a
Type: n/a
Version: n/a