Version 1.13
SELECT * FROM JSONParser (
ON { table | view | (query) }
USING
TextColumn ('text_column')
Nodes ('parent_node/child_node' [,...])
[ SearchPath ('node_name/...') ]
[ Delimiter ('delimiter') ]
[ MaxItemNum (max_item_number) ]
[ NodeIDOutputColumn ('node_id_output_column') ]
[ ParentNodeOutputColumn ('parent_node_output_column') ]
[ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
[ ErrorHandler ('{'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}
[[; output_column :] input_column [,...]')]
]
) AS alias;