[
https://issues.apache.org/jira/browse/HIVE-2971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13265938#comment-13265938
]
Gang Tim Liu commented on HIVE-2971:
------------------------------------
Yes, removing space like the following works fine:
SELECT GET_JSON_OBJECT("{\"FormName\": 12345}", "$.FormName") FROM
akramer_one_row;
> GET_JSON_OBJECT fails on some valid JSON keys
> ---------------------------------------------
>
> Key: HIVE-2971
> URL: https://issues.apache.org/jira/browse/HIVE-2971
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Reporter: Adam Kramer
> Priority: Minor
>
> hive> SELECT GET_JSON_OBJECT("{\"Form Name\": 12345}", "$.Form\ Name") FROM
> akramer_one_row;
> Mapred Local Task Succeeded . Convert the Join into MapJoin
> OK
> NULL
> ...this also returns null for "$.Form Name" and "$.Form\\ Name". It should
> return the relevant key.
> Removing the space works fine, however, spaces are allowed as JSON keys (see
> spec at http://www.json.org/ ). As such, this is a bug.
> Claiming that this is org.json's problem, or something similar, does not
> solve this bug. It's Hive that claims this gets a JSON object, so it needs to
> provide the JSON object.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
