SELECT * FROM JSONParser ( ON json_parser_data_2 TextColumn('data') Nodes('glossary/title', 'GlossDiv/title', 'GlossEntry/Abbrev', 'GlossSeeAlso/GlossSeeAlso', '/email') Delimiter (' , ') Accumulate ('id') NodeIdOutputColumn ('out_nodeid') ParentNodeOutputColumn ('out_parent_node') ) ORDER BY 1, 2;