You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2015/08/13 04:02:45 UTC

[jira] [Updated] (TAJO-1754) Implement several functions to handle json array

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

Jihoon Son updated TAJO-1754:
-----------------------------
    Summary: Implement several functions to handle json array  (was: Implement json_array_get(json_array, index) function)

> Implement several functions to handle json array
> ------------------------------------------------
>
>                 Key: TAJO-1754
>                 URL: https://issues.apache.org/jira/browse/TAJO-1754
>             Project: Tajo
>          Issue Type: Sub-task
>          Components: Function/UDF
>            Reporter: Jihoon Son
>            Assignee: Jihoon Son
>             Fix For: 0.11.0
>
>
> Here are some examples.
> {noformat}
> SELECT json_array_get('["a", "b", "c"]', 0); => "a"
> SELECT json_array_get('["a", "b", "c"]', 1); => "b"
> SELECT json_array_get('["c", "b", "a"]', -1); => "a"
> SELECT json_array_get('["c", "b", "a"]', -2); => "b"
> SELECT json_array_get('[]', 0); => null
> SELECT json_array_get('["a", "b", "c"]', 10); => null
> SELECT json_array_get('["c", "b", "a"]', -10); => null
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)