[jira] [Created] (IMPALA-14467) get_json_object fails to parse JSON paths with dots in key names

["YifanZhang (Jira)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org