[
https://issues.apache.org/jira/browse/HIVE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14380723#comment-14380723
]
Jason Dere commented on HIVE-1575:
----------------------------------
+1 if tests look good
> 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, HIVE-1575.3.patch, HIVE-1575.4.patch, HIVE-1575.5.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
(v6.3.4#6332)
