[HIVE-7075] JsonSerde raises NullPointerException when object key is not lower case

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.14.0
• Component/s: HCatalog, Serializers/Deserializers
• Assignee: Navis Ryu
• Reporter: Yibing Shi
• Created: 16/May/14 06:29
• Updated: 13/Nov/14 19:41
• Resolved: 09/Jun/14 20:28

Description

We have noticed that the JsonSerde produces a NullPointerException if a JSON object has a key value that is not lower case. For example. Assume we have the file "one.json":

{ "empId" : 123, "name" : "John" } { "empId" : 456, "name" : "Jane" }

hive> CREATE TABLE emps (empId INT, name STRING)
ROW FORMAT SERDE "org.apache.hive.hcatalog.data.JsonSerDe";

hive> LOAD DATA LOCAL INPATH 'one.json' INTO TABLE emps;

hive> SELECT * FROM emps;

Failed with exception java.io.IOException:java.lang.NullPointerException

--------

Notice, it seems to work if the keys are lower case. Assume we have the file 'two.json':

{ "empid" : 123, "name" : "John" } { "empid" : 456, "name" : "Jane" }

hive> DROP TABLE emps;

hive> CREATE TABLE emps (empId INT, name STRING)
ROW FORMAT SERDE "org.apache.hive.hcatalog.data.JsonSerDe";

hive> LOAD DATA LOCAL INPATH 'two.json' INTO TABLE emps;

hive> SELECT * FROM emps;
OK
123 John
456 Jane

Issue Links

• links to: review board