com.cloudera.hive.serde.jsonserde Not found error

I am facing the com.cloudera.hive.serde.jsonserde not found error even after adding the jar hive-serdes-1.0-SNAPSHOT.jar file.
Can anyone guide me what might be the reason .
I am able to create the tweets_partioned table but when i try to load the data facing above error.

2 Answer(s)


execute the command

Now add jar using add jar command as shown below before creating the table
Hive> add jar /directory/hive-serdes-1.0-SNAPSHOT.jar;
directory is the directory where is located your hive-serdes-1.0-SNAPSHOT.jar.
example for me, i did theses command;
Hive> add jar /home/cloudera/Downloads/hive-serdes/hive-serdes-1.0-SNAPSHOT.jar;
Hive> create table tweets ........ ;


hi Yogesh,

You need to add the complete jar to the Hive classpath on the hive command like. Examples can be downloaded from Dezyre LMS Module 9 "Advanced HiveQL" , files "Hive Queries and Python scripts ".