Live instructor-led & Self-paced Online Certification Training Courses (Big Data, Hadoop, Spark) Forums Hive How to resolve the following error while running a query in hive

Viewing 1 reply thread
  • Author
    • #6553

      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

    • #6554

      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.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.