1.0 - 8.00 - XMLParser Example 4: ErrorHandler - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

The second XML document is missing the closing tag </bookstore>.

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