hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-7075) JsonSerde raises NullPointerException when object key is not lower case
Date Wed, 28 May 2014 08:21:01 GMT

     [ https://issues.apache.org/jira/browse/HIVE-7075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Navis reassigned HIVE-7075:
---------------------------

    Assignee: Navis

> JsonSerde raises NullPointerException when object key is not lower case
> -----------------------------------------------------------------------
>
>                 Key: HIVE-7075
>                 URL: https://issues.apache.org/jira/browse/HIVE-7075
>             Project: Hive
>          Issue Type: Bug
>          Components: HCatalog, Serializers/Deserializers
>    Affects Versions: 0.12.0
>            Reporter: Yibing Shi
>            Assignee: Navis
>         Attachments: HIVE-7075.1.patch.txt, HIVE-7075.2.patch.txt, HIVE-7075.3.patch.txt
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message