phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1710) Implement the json_extract_path_text built-in function
Date Sat, 07 Mar 2015 19:23:38 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-1710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor updated PHOENIX-1710:
----------------------------------
    Assignee: NIsala Niroshana

> 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 Taylor
>            Assignee: NIsala Niroshana
>
> 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)

Mime
View raw message