1.1 - 8.10 - XMLParser Example: ErrorHandler - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
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 ;

Output

The output table has the column ERROR_HANDLER, which contains the value of the input column xmldocument followed by a semicolon.

 xid out_nodeid out_parent_node owner title  author                errorhandler 
 --- ---------- --------------- ----- ------ --------------------- ------------ 
   1          1 bookstore       Billy                              NULL        
   1          2 bookitem              Cosmos Carl Sagan,Ann Druyan NULL        
   2       NULL NULL            NULL  NULL   NULL                  <bookstore>;

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.