question error:HIVE action alter table in Archives of Support Questions (Read Only)

error:HIVE action alter table

Ashok — Fri, 16 Sep 2022 08:47:21 GMT

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)

Re: error:HIVE action alter table

Harsh J — Wed, 28 Aug 2013 11:04:31 GMT

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.

Re: error:HIVE action alter table

Jais — Mon, 21 Dec 2015 22:13:57 GMT

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!!