YifanZhang created IMPALA-14467:
-----------------------------------
Summary: get_json_object fails to parse JSON paths with dots in
key names
Key: IMPALA-14467
URL: https://issues.apache.org/jira/browse/IMPALA-14467
Project: IMPALA
Issue Type: Bug
Components: Backend
Reporter: YifanZhang
This query returns null:
{code:java}
SELECT GET_JSON_OBJECT ('{"a.com":1}', '$.a.com'); {code}
This query fails:
{code:java}
SELECT GET_JSON_OBJECT ('{"a.com":1}', '$."a.com"');
failed: UDF ERROR: Failed to parse json path '$."a.com"': Expected key at
position 2{code}
MySQL8.0 returns the correct result:
{code:java}
mysql> SELECT JSON_EXTRACT('{"a.com":1}', '$."a.com"');
+------------------------------------------+
| JSON_EXTRACT('{"a.com":1}', '$."a.com"') |
+------------------------------------------+
| 1 |
+------------------------------------------+ {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
