The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

JSON SERDE not working in hive 0.13.0

  • #55762

    Hi, I am testing on hive 0.13.0 . I am trying to create an external table with jars and i am giving the following for ROW FORMAT

    ROW FORMAT SERDE ‘org.apache.hadoop.hive.contrib.serde2.JsonSerde’
    ROW FORMAT SERDE ‘com.cloudera.hive.serde.JSONSerDe’

    But all of them are returning errors. below are the errors

    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: com.cloudera.hive.serde.JSONSerDe

    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.serde2.object inspector.primitive.AbstractPrimitiveJavaObjectInspector.<init>(Lorg/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils$PrimitiveTypeEntry;)V

    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hadoop.hive.contrib.serde2.JsonSerde

    I am unable to understand what to do now. Any help please.

  • Author
  • #57749
    James Frentress

    Hive13 requires updates to the SerDe. Hortonworks has been kind enough to make that change ot openx and publish it under dist here:

    Ravi Vaswani


    Thanks James for sharing the location of the correct jar file that is compatible with HDP 2.1 and Hive 0.13.
    Can we get access to the corresponding source code files, .java files of this serde? Because in future we may want to modify or customize the serde.
    Just wondering how do we get it.


The forum ‘Hive / HCatalog’ is closed to new topics and replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.