explode_json_array_int

Description

explode_json_array_int table function, accepts a JSON array. Its implementation logic is to convert the JSON array into an array type and then call the explode function for processing. Must be used with LATERAL VIEW.

Syntax

EXPLODE_JSON_ARRAY_INT(<json>)

Parameters

<json> JSON type, its content should be an array.

Return Results

• Returns a single-column multi-row result set composed of all elements in <json>, with the column type being Nullable<JSON>.
• If <json> is NULL or an empty array (element count is 0), returns 0 rows.
• If the elements of the JSON array are not of type INT, an attempt will be made to convert them to INT. Elements that cannot be converted to INT will be converted to NULL.

Examples

CREATE TABLE test_explode_json(id int, j json); INSERT INTO test_explode_json VALUES (1, parse_json('{"a": 1, "b": "hello", "c": [1,2,3]}')), (2, parse_json('[1, 2, "three", 4.5, null]')), (3, parse_json('null')), (4, null), (5, parse_json('[]')), (6, parse_json('{}')), (7, parse_json('[{"x":1},{"y":2}]')), (8, parse_json('{"nested": {"a": 1}, "arr": [1,2]}')); SELECT id, col FROM test_explode_json LATERAL VIEW explode_json_array_int(j) lv AS col ORDER BY id;