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;