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)