[
https://issues.apache.org/jira/browse/TAJO-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14695182#comment-14695182
]
ASF GitHub Bot commented on TAJO-1754:
--------------------------------------
Github user hyunsik commented on the pull request:
https://github.com/apache/tajo/pull/687#issuecomment-130662056
+1 LGTM!
> 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
>
>
> h4. json_array_get
> {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}
> h4. json_array_contains
> {noformat}
> SELECT json_array_contains('[1, 2, 3]', 2);
> {noformat}
> h4. json_array_length
> {noformat}
> SELECT json_array_length('[1, 2, 3]');
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
