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