You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have one Json file and I have validated it, Its a valid json.
now creating Hive table on this file and then selecting data but its showing
Error: java.io.IOException:
org.apache.hadoop.hive.serde2.SerDeException: Row is not a valid JSON Object
- JSONException: A JSONObject text must end with '}' at 2 [character 3 line 1]
(state=,code=0)
when I tried to set below property.
ALTER TABLE test_rahul SET SERDEPROPERTIES ( "ignore.malformed.json" = "true");
Then It showing Null values for all the fields. Can someone Kindly Help me.
I have one Json file and I have validated it, Its a valid json.
now creating Hive table on this file and then selecting data but its showing
when I tried to set below property.
Then It showing Null values for all the fields. Can someone Kindly Help me.
json File:
Jar Added:
I tried multiple option but didn't worked .Can someone suggest me what is the issue here/or do I need to change the delimiter/add new properties.
The text was updated successfully, but these errors were encountered: