Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

error:HIVE action alter table

Explorer

When I tried to alter the table and added the external serde,its shows the error as :

 

Added /tmp/b07e0a29-979b-49fd-8d09-a007a4a76529_resources/json-serde-1.1.6-jar-with-dependencies.jar to class path Added resource: /tmp/b07e0a29-979b-49fd-8d09-a007a4a76529_resources/json-serde-1.1.6-jar-with-dependencies.jar FAILED: RuntimeException MetaException(message:org.apache.hadoop.hive.serde2.SerDeException SerDe org.apache.hadoop.hive.contrib.serde2.JsonSerde does not exist)

 

 

1 ACCEPTED SOLUTION

Master Guru

You will need to add your hive-contrib-*.jar under $HIVE_HOME/lib/ as an "add jar" command before you can execute this, as the class seems to be from an off-default contrib package.

View solution in original post

2 REPLIES 2

Master Guru

You will need to add your hive-contrib-*.jar under $HIVE_HOME/lib/ as an "add jar" command before you can execute this, as the class seems to be from an off-default contrib package.

Contributor

Hi,

 

 

I am also facing similar issue can you tell me where I need to add hive-contib.jar , We are using cdh5.4.2. Please let me know the exact path. Thanks!!