Jihoon Son created TAJO-1754:
--------------------------------

             Summary: Implement json_array_get(json_array, index) function
                 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)

Reply via email to