hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gang Tim Liu (JIRA)" <>
Subject [jira] [Commented] (HIVE-2971) GET_JSON_OBJECT fails on some valid JSON keys
Date Tue, 01 May 2012 17:48:48 GMT


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:
>             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
> ...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 ). 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:!default.jspa
For more information on JIRA, see:


View raw message