Support Questions
Find answers, ask questions, and share your expertise

How to resolve the following error while running a query in hive


The error is: Error in metadata: Cannot validate serde org.apache.hadoop.hive.contrib.serde2.JasonSerDe FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask


Hivetables that point to JSON files as contents, these tables need JSON SerDe jar.

To add jar :
ADD JAR /<local-path>/json-serde-1.0.jar;

Hive tables that does not contain JSON (and does not require the SerDe), can be read the tables easily.

When it comes to the Hive tables that contain JSON data, it will look for dependencies jars to read the data.

New Contributor

This post offers some valuable information and it seems really helpful for readers. Thankful to you for sharing this brilliant stuff over here.I would like to share this information with my friends.Thank you for sharing it.In my opinion your post is a very good platform to get some valuable informations. science project ideas for kids

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.