You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2015/07/24 22:05:04 UTC
[jira] [Updated] (PHOENIX-1710) Implement the
json_extract_path_text built-in function
[ https://issues.apache.org/jira/browse/PHOENIX-1710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas D'Silva updated PHOENIX-1710:
------------------------------------
Issue Type: New Feature (was: Sub-task)
Parent: (was: PHOENIX-1661)
> 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: New Feature
> Reporter: James Taylor
> Assignee: Aakash Pradeep
> Fix For: 5.0.0, 4.4.1
>
>
> 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
(v6.3.4#6332)