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>; |