hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <>
Subject [jira] [Updated] (HIVE-1575) get_json_object does not support JSON array at the root level
Date Wed, 25 Mar 2015 02:37:52 GMT


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

patch #4.
- require path to start with $. or $[
- add java junit tests from udf_get_json_object.q file for easier testing

> get_json_object does not support JSON array at the root level
> -------------------------------------------------------------
>                 Key: HIVE-1575
>                 URL:
>             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,
HIVE-1575.3.patch, HIVE-1575.4.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.
> Per the JSON RFC, an array is indeed legal top-level JSON-text

This message was sent by Atlassian JIRA

View raw message