Version 2.5
SELECT * FROM XMLParser (
ON { table | view | (query) }
USING
TextColumn ('text_column')
Nodes ('node_pair_string [,...]')
[ Sibling ('sibling_node_string [,...]') ]
[ Delimiter ('delimiter') ]
[ SiblingDelimiter ('sibling_delimiter') ]
[ MaxItemNum (max_item_number) ]
[ Ancestor ('nodes_path' [,...]) ]
[ OutputColumnNodeID ('output_column_node') ]
[ OutputColumnParentNodeName ('output_column_parent_node') ]
[ OutputColumnGrandparentNodeName ('output_column_grandparent_node') ]
[ ErrorHandler ('{'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}[; [output_column:] column[,...]]') ]
[ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
) AS alias;