[ https://issues.apache.org/jira/browse/HIVE-7075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009264#comment-14009264 ]
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/12646738/HIVE-7075.3.patch.txt {color:red}ERROR:{color} -1 due to 14 failed/errored test(s), 5540 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_parquet_decimal1 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_optimization org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_insert1 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_load_dyn_part1 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_scriptfile1 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_tez_dml org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_root_dir_external_table org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_schemeAuthority2 org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_authorization_ctas org.apache.hadoop.hive.common.metrics.TestMetrics.testScopeConcurrency org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimal org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimalX org.apache.hive.hcatalog.pig.TestOrcHCatPigStorer.testWriteDecimalXY org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/305/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/305/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-Build-305/ 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: 14 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12646738 > 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, 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)