[ https://issues.apache.org/jira/browse/HIVE-2971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13271040#comment-13271040 ]
Hudson commented on HIVE-2971: ------------------------------ Integrated in Hive-trunk-h0.21 #1419 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1419/]) HIVE-2971 GET_JSON_OBJECT fails on some valid JSON keys (gangtimliu via kevinwilfong) (Revision 1335630) Result = SUCCESS kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1335630 Files : * /hive/trunk/data/files/json.txt * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFJson.java * /hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q * /hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out > 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 > Assignee: Gang Tim Liu > Priority: Minor > Attachments: Hive-2971-patch > > > 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