[jira] [Commented] (HIVE-7036) get_json_object bug when extract list of list with index

["Hive QA (JIRA)" <ji...@apache.org>]

    [ 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)