[TAJO-1754] Implement several functions to handle json array

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Function/UDF
• Assignee: Jihoon Son
• Reporter: Jihoon Son
• Created: 13/Aug/15 01:04
• Updated: 13/Aug/15 14:04
• Resolved: 13/Aug/15 13:34

Description

json_array_get

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

json_array_contains

SELECT json_array_contains('[1, 2, 3]', 2);

json_array_length

SELECT json_array_length('[1, 2, 3]');