search

rcongiu / Hive-JSON-Serde

Read - Write JSON SerDe for Apache Hive.
Other
733 stars 391 forks source link

Json Malformed Error #133

Closed sburman02 closed 8 years ago

sburman02 commented 8 years ago

Hi,

My Json file I feel is valid. I am getting this error when ever I am trying to query. I was successful in creating the table. I am also attaching the JSON file : Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object - JSONException: Missing value at 1 [character 2 line 1].

sburman02 commented 8 years ago

StudentJson.txt

I am on HDP 2.3, Hive 1.2.1.2.3 Wondering what is wrong with my JSON file ?

Thanks & regards, Sudipta

rcongiu commented 8 years ago

It has to be all in one line ( no \n in the body )