[ https://issues.apache.org/jira/browse/HIVE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Lewis updated HIVE-1575: ----------------------------- Attachment: 0001-Updated-UDFJson-to-allow-arrays-as-a-root-object.patch Sorry if this is a repeat post, wasn't sure how to attach the patch. > 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 > Attachments: > 0001-Updated-UDFJson-to-allow-arrays-as-a-root-object.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 is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.