title: json SerDe hive 0.13.1
body: <p><strong>I'm trying to create a hive table in wich I will load json data.</strong></p>
  
  <p>Here is what I did:</p>
  
  <p><strong>1 -</strong> I downloaded the project <a href="https://github.com/sheetaldolas/Hive-JSON-Serde/tree/master" rel="nofollow">https://github.com/sheetaldolas/Hive-JSON-Serde/tree/master</a> and changed the cdh5 version to cdh5.2.0 (the cloudera version that I use)</p>
  
  <p><strong>2-</strong> I added the jar from the serde project </p>
  
  <pre><code>.../Hive-JSON-Serde-develop/json-serde/target/json-serde-1.3.1-SNAPSHOT-jar-with-dependencies.jar
  </code></pre>
  
  <p><strong>3-</strong> I tried to create a table</p>
  
  <pre><code>CREATE EXTERNAL TABLE events (..XYZ..)
  ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' WITH SERDEPROPERTIES ( "ignore.malformed.json" = "true") STORED AS TEXTFILE
  </code></pre>
  
  <p>here XYZ is correct because the table is created if I remove the "ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' WITH SERDEPROPERTIES ( "ignore.malformed.json" = "true")" part</p>
  
  <p><strong>And I'm getting a serde error:</strong></p>
  
  <pre><code>java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.serde2.objectinspector.primitive.AbstractPrimitiveJavaObjectInspector.&lt;init&gt;(Lorg/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils$PrimitiveTypeEntry;)V
      at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:277)
      at com.seb.hive.Standard.importStandardEvents(Standard.java:90)
      at com.seb.hive.Standard.main(Standard.java:37)
  </code></pre>
  
  <p><strong>I checked the /tmp/{user}/hive.log but there is nothing:</strong></p>
  
  <pre><code>/tmp/cloudera/hive.log 
  2014-12-10 02:26:04,535 INFO  [main]: session.SessionState (SessionState.java:start(360)) - No Tez session required at this point. hive.execution.engine=mr.
  </code></pre>
  
  <p><strong>My hive version is 0.13.1 and I saw that there were problems with this version of hive</strong>
  <a href="http://hortonworks.com/community/forums/topic/json-serde-not-working-in-hive-0-13-0/" rel="nofollow">http://hortonworks.com/community/forums/topic/json-serde-not-working-in-hive-0-13-0/</a>
  but I downloaded the last version from the repository..so it should be fixed...</p>
  
  <p><strong>What should I also check? Is my approach correcte?</strong></p>
  
  <p>Thank you!</p>