The SQL-MapReduce call uses custom values for the arguments NodeIdOutputColumnName and ParentNodeOutputColumnName.
SELECT * FROM JSONParser ( ON json_parser_data TextColumn ('data') Nodes ('menu/{id,value}', 'menuitem/value') Delimiter ('|') NodeIdOutputColumn ('Fieldnumber') ParentNodeOutputColumn ('ParentName') Accumulate ('id') ) ORDER BY 1, 2;