[ https://issues.apache.org/jira/browse/HIVE-7075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14005373#comment-14005373 ]
Hive QA commented on HIVE-7075: ------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12645962/HIVE-7075.1.patch.txt {color:red}ERROR:{color} -1 due to 12 failed/errored test(s), 5526 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_insert1 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_tez_dml org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_root_dir_external_table org.apache.hive.hcatalog.data.schema.TestHCatSchema.testCannotInstantiateSchemaWithRepeatedFieldNames org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimal org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimalX org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimalXY org.apache.hive.hcatalog.templeton.TestWebHCatE2e.getHadoopVersion org.apache.hive.hcatalog.templeton.TestWebHCatE2e.getHiveVersion org.apache.hive.hcatalog.templeton.TestWebHCatE2e.getPigVersion org.apache.hive.hcatalog.templeton.TestWebHCatE2e.getStatus org.apache.hive.hcatalog.templeton.TestWebHCatE2e.invalidPath {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/258/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/258/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-Build-258/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 12 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12645962 > 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 > Attachments: HIVE-7075.1.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)