Hortonworks.com
  • Explore
    • All Tags
    • All Questions
    • All Articles
    • All Ideas
    • All Repos
    • All SKB
    • All Users
    • All Badges
    • Leaderboard
  • Create
    • Ask a question
    • Create Article
    • Post Idea
    • Add Repo
  • Tracks
    • All Tracks
    • Community Help
    • Cloud & Operations
    • CyberSecurity
    • Data Ingestion & Streaming
    • Data Processing
    • Data Science & Advanced Analytics
    • Design & Architecture
    • Governance & Lifecycle
    • Hadoop Core
    • Sandbox & Learning
    • Security
    • Solutions
  • Login
HCC Hortonworks Community Connection
  • Home /
  • Solutions /
  • Home /
  • Solutions /
avatar image

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

bthiyagarajan created · Dec 13, 2017 at 07:08 AM
avatar image
0

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
Support ID: 000006754
thub.nodes.view.add-new-comment
solutionhwsupportHive
Add comment · Show 1
10 |6000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 5 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

avatar image Samarendra Sahoo · Feb 07 at 03:12 PM 0
Share

Where to check the hive-interatcive-site.xml? Could you pls share the relative path? Dont see this @.../Hive/Config/ directory...

avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image

Related posts

ERROR:"SemanticException [Error 10072]: Database does not exist: XX Connection String: DSN=HIVE;UID=ABC" while connecting to Hive from Microstrategy through ODBC

ERROR: "Unable to determine if hdfs://x.x.x.x:8020/test/t_carpo is encrypted" when creating an Hive external table

Error "Perhaps the document has an indexed string field (solr.StrField) which is too large" when writing to Solr Ambari infra Solr Ranger Audits

Hiveserver2 Interactive Web UI is unable to display queries data after HDP 2.6.3 upgrade

Error:"java.lang.OutOfMemoryError: unable to create new native thread" when executing Hive jobs

Error:"Caused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00" when running a CREATE EXTERNAL TABLE query in Hive

ERROR:"java.lang.ClassCastException: org.apache.hadoop.hive.ql.exec.vector.BytesColumnVector cannot be cast to org.apache.hadoop.hive.ql.exec.vector.LongColumnVector" when running Hive query

LLAP queries are not working in a SSL enabled environment

ERROR:"SemanticException Error while configuring input job properties"when accessing HBase table from Hive after upgrading to Ambari 2.2.2.

The Hive ODBC Driver does not support LIMIT keyword

This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.

HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service

© 2011-2019 Hortonworks Inc. All Rights Reserved.

Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.

  • Anonymous
  • Login
  • Create
  • Ask a question
  • Create Article
  • Post Idea
  • Add Repo
  • Create SupportKB
  • Tracks
  • Community Help
  • Cloud & Operations
  • CyberSecurity
  • Data Ingestion & Streaming
  • Data Processing
  • Data Science & Advanced Analytics
  • Design & Architecture
  • Governance & Lifecycle
  • Hadoop Core
  • Sandbox & Learning
  • Security
  • Solutions
  • Explore
  • All Tags
  • All Questions
  • All Articles
  • All Ideas
  • All Repos
  • All SKB
  • All Users
  • Leaderboard
  • All Badges