You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Sahil Takiar (Jira)" <ji...@apache.org> on 2020/07/22 22:47:00 UTC

[jira] [Created] (IMPALA-9993) Improve get_json_object path specification format

Sahil Takiar created IMPALA-9993:
------------------------------------

             Summary: Improve get_json_object path specification format
                 Key: IMPALA-9993
                 URL: https://issues.apache.org/jira/browse/IMPALA-9993
             Project: IMPALA
          Issue Type: Improvement
          Components: Backend
            Reporter: Sahil Takiar


Filing as a follow up to IMPALA-8547 based on some of the discussion in [https://gerrit.cloudera.org/#/c/14905/]

It seems most databases have a slightly different way of handling JSON data. The Hive / Impala behavior seems similar to MySQL in syntax (e.g. JSON_EXTRACT), although MySQL is much more restrictive about the path specification format. Postgres on the other hand has a slightly different syntax for path specification compared to MySQL / Hive / Impala, and is more permissive in what formats it allows.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)