Unable to work with JSON in HIVE


#1

I followed the following sequence of command.
in the database bs0fcs1496_twitter_sentiment all tables are already created.

hive>use bsofcs1496_twitter_sentiment;
hive>ADD JAR hdfs:///data/hive/json-serde-1.1.9.9-Hive13-jar-with-dependencies.jar;
hive>SET hive.support.sql11.reserved.keywords=false;
CREATE VIEW trial_unload AS
SELECT
id,
text,
user.time_zone
FROM tweets_raw;
FAILED: RuntimeException MetaException(message:java.lang.ClassNotFoundException Class org.openx.data.jsonserde.JsonSerDe not found)

Please help me.


#2

Hi @Bhanu_Saurabh,

You might have to use new JSON serde as per the Hive version.

Just curious if you found any solution on Hortonworks support for the same?