[ https://issues.apache.org/jira/browse/HIVE-7036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13994269#comment-13994269 ]
Hive QA commented on HIVE-7036: ------------------------------- {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/12643916/HIVE-7036.1.patch.txt {color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 5503 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_stats_partscan_1_23 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 {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/165/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-Build/165/console 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: 4 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12643916 > get_json_object bug when extract list of list with index > -------------------------------------------------------- > > Key: HIVE-7036 > URL: https://issues.apache.org/jira/browse/HIVE-7036 > Project: Hive > Issue Type: New Feature > Components: UDF > Affects Versions: 0.12.0, 0.13.0 > Environment: all > Reporter: Ming Ma > Assignee: Navis > Priority: Minor > Labels: udf > Attachments: HIVE-7036.1.patch.txt > > > https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFJson.java#L250 > this line should be out of the for-loop > For example > json = '{"h":[1, [2, 3], {"i": 0}, [{"p": 11}, {"p": 12}, {"pp": 13}]}' > get_json_object(json, '$.h[*][0]') should return back the first node(if > exists) of every childrenof '$.h' > which specifically should be > [2,{"p":11}] > but hive returns only > 2 > because when hive pick the node '2' out, the tmp_jsonList will change to a > list only contains one node '2': > [2] > then it was assigned to variable jsonList, in the next loop, value of i would > be 2 which is greater than the size(always 1) of jsonList, then the loop > broke out. -- This message was sent by Atlassian JIRA (v6.2#6252)