HIVE command line error missing java class

Hi I,m getting the following error. I followed exactly your table script to load twitter data but the twitter data is in avro and the table create that you gave was in JSON…

When I do the following I get an error… How/what is the command to install this java class?

SELECT COUNT(*) from tweets_raw_jp;

FAILED: RuntimeException MetaException(message:java.lang.ClassNotFoundException Class org.openx.data.jsonserde.JsonSerDe not found)

I fixed it now… i navigated in hue to check the folder “/ data/ hive”

I saw 2 jars in there…

The missing one was there but i needed to add in hive command line

ADD JAR hdfs:///data/hive/json-serde-1.1.9.9-Hive13-jar-with-dependencies.jar;

Now I can SELECT COUNT(*) from tweets_raw_jp;

1 Like