Support Questions
Find answers, ask questions, and share your expertise

Hive table Select query fails -Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object -

Highlighted

Hive table Select query fails -Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object -

New Contributor

Hello :

I am trying to load Twitter JSON objects into HIVE. I am using JsonSerde - a read/write SerDe for JSON Data (and related Jar) for this from GitHub. My select queries are failing with following error -

Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object - JSONException: Expected a ':' after a key at 21 [character 22 line 1]

Please help.

3 REPLIES 3
Highlighted

Re: Hive table Select query fails -Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object -

Super Guru

@New Hadoopy

try to parse your json file in an online json parser. For example, here. Apparently your json is not valid.

Highlighted

Re: Hive table Select query fails -Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object -

New Contributor
Highlighted

Re: Hive table Select query fails -Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object -

New Contributor

Hii
You can also use https://onlinejsontools.org/ for json validator,beautify,minify,xml,yaml,CSV,bson,plain text,base64,tsv.
Do checkout this site!

Don't have an account?