[
https://issues.apache.org/jira/browse/IMPALA-8547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17184765#comment-17184765
]
ASF subversion and git services commented on IMPALA-8547:
---------------------------------------------------------
Commit adf2c464aed5d35c976c1439982e0a927f76b609 in impala's branch
refs/heads/master from Eugene Zimichev
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=adf2c46 ]
IMPALA-8547: get_json_object fails to get value for numeric key
Allows numeric keys for JSON objects in get_json_object. This patch
makes Impala consistent with Hive and Postgres behavior for
get_json_object.
Queries such as "select get_json_object('{"1": 5}', '$.1');"
would fail before this patch. Now the query will return '5'.
Testing:
* Added tests to expr-test
Change-Id: I7df037ccf2c79da0ba86a46df1dd28ab0e9a45f4
Reviewed-on: http://gerrit.cloudera.org:8080/14905
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> get_json_object fails to get value for numeric key
> --------------------------------------------------
>
> Key: IMPALA-8547
> URL: https://issues.apache.org/jira/browse/IMPALA-8547
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 3.1.0
> Reporter: Eugene Zimichev
> Assignee: Eugene Zimichev
> Priority: Minor
> Labels: built-in-function
>
> {code:java}
> select get_json_object('{"1": 5}', '$.1');
> {code}
> returns error:
>
> {code:java}
> "Expected key at position 2"
> {code}
>
> I guess it's caused by using function FindEndOfIdentifier that expects first
> symbol of key to be a letter.
> Hive version of get_json_object works fine in this case.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
