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

This topic has 1 reply, 1 voice, and was last updated 5 years, 6 months ago by DataFlair Team.

Viewing 1 reply thread

Author

Posts
- October 10, 2018 at 3:46 pm #6553
  
  DataFlair Team
  Spectator
  
  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
- October 10, 2018 at 3:46 pm #6554
  
  DataFlair Team
  Spectator
  
  Hive tables 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.
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.