[jira] [Updated] (HIVE-1575) get_json_object does not support JSON array at the root level

["Alexander Pivovarov (JIRA)" <ji...@apache.org>]

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

Alexander Pivovarov updated HIVE-1575:
--------------------------------------
    Attachment: HIVE-1575.2.patch

patch #2 - wrap array with object a and adjust jsonpath

> get_json_object does not support JSON array at the root level
> -------------------------------------------------------------
>
>                 Key: HIVE-1575
>                 URL: https://issues.apache.org/jira/browse/HIVE-1575
>             Project: Hive
>          Issue Type: Improvement
>          Components: UDF
>    Affects Versions: 0.7.0
>            Reporter: Steven Wong
>            Assignee: Alexander Pivovarov
>         Attachments: 0001-Updated-UDFJson-to-allow-arrays-as-a-root-object.patch, HIVE-1575.2.patch
>
>
> Currently, get_json_object(json_txt, path) always returns null if json_txt is not a JSON object (e.g. is a JSON array) at the root level.
> I have a table column of JSON arrays at the root level, but I can't parse it because of that.
> get_json_object should accept any JSON value (string, number, object, array, true, false, null), not just object, at the root level. In other words, it should behave as if it were named get_json_value or simply get_json.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)