Hive / HCatalog Forum

JSON SERDE not working in hive 0.13.0

  • #55762
    Dheeraj
    Participant

    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 ‘org.openx.data.jsonserde.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.

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #57749
    James Frentress
    Participant

    Hive13 requires updates to the SerDe. Hortonworks has been kind enough to make that change ot openx and publish it under dist here: https://github.com/sheetaldolas/Hive-JSON-Serde/tree/master

    #64465
    Ravi Vaswani
    Participant

    Hi,

    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.

    Regards,
    Ravi

You must be to reply to this topic. | Create Account

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.