Input
The second XML document is missing the closing tag </bookstore>.
xid | xmldocument |
---|---|
1 | <bookstore owner="Judy"> : <owner>Billy</owner><items> : <bookitem category="ASTRONOMY"> : <title lang="en">Cosmos</title> : <author>Carl Sagan</author> : <author>Ann Druyan</author> : <year edition="1">1980</year> : <price> : <member>49.99</member> : <public>60.00</public> : </price> : </bookitem> : </items> </bookstore> |
2 | <bookstore> |
SQL Call
SELECT * FROM XMLParser ( ON xml_inputs_error USING TextColumn ('xmldocument') Nodes ('bookstore/owner', 'bookitem/title', 'bookitem/author') ErrorHandler ('true;xmldocument') Accumulate ('xid') ) AS dt ORDER BY xid;
Output
The output table has the column ERROR_HANDLER, which contains the value of the input column xmldocument followed by a semicolon.
xid | out_node_id | out_parent_node | owner | title | author | ERROR_HANDLER |
---|---|---|---|---|---|---|
1 | 1 | bookstore | Billy | |||
1 | 2 | bookitem | Cosmos | Carl Sagan, Ann Druyan | ||
2 |
<bookstore>; |