[
https://issues.apache.org/jira/browse/PHOENIX-1710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ranganath Govardhanagiri resolved PHOENIX-1710.
-----------------------------------------------
Resolution: Won't Fix
As per the JSON ISO standard document the 4 query functions defined are :
JSON_VALUE, JSON_QUERY, JSON_EXISTS and JSON_TABLE.
Following ISO standard, we have created PRs to implement those. Resolving this
as won't fix. Please let me know if you have any concerns.
> Implement the json_extract_path_text built-in function
> ------------------------------------------------------
>
> Key: PHOENIX-1710
> URL: https://issues.apache.org/jira/browse/PHOENIX-1710
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James R. Taylor
> Priority: Major
>
> Implement the json_extract_path_text modeled after the Postgres function.
> This function returns JSON pointed to by the path elements argument. In
> Phoenix, it could be implemented like this:
> {code}
> VARCHAR json_extract_path_text (VARCHAR json, VARCHAR ARRAY path_elems paths)
> {code}
> For example:
> {code}
> SELECT json_extract_path_text(json_col, ARRAY['f4','f6']) FROM my_table;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
