My Oracle Support Banner

Hive Query Fails with "org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object - JSONException" (Doc ID 2227249.1)

Last updated on FEBRUARY 12, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Linux x86-64


A hive query fails with:

Caused by: org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object - JSONException: Expected a ',' or '}' at 1007 [character 1008 line 1]
at org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.readRow(
at org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.access$200(
at org.apache.hadoop.hive.ql.exec.MapOperator.process(



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.