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


#1

While i am trying to execute below query in Hive web Console,

CREATE VIEW tweets_simple AS
SELECT          
id,
cast ( from_unixtime( unix_timestamp(concat( '2013 ', substring(created_at,5,15)), 'yyyy MMM dd hh:mm:ss')) as timestamp) ts,
text,
user.time_zone 
FROM tweets_raw;

I am getting below error, could you please assist me in resolving the issue,
FAILED: RuntimeException MetaException(message:java.lang.ClassNotFoundException Class org.openx.data.jsonserde.JsonSerDe not found)


#2

Hi @karthik_venkatesan,

You are required to add JsonSerDe JAR before executing CREATE VIEW

Hope this helps.

Thanks


#3

@abhinav Thank you for your update. It works now.