1.1 - 8.10 - XMLRelation Output - 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)

The output table schema depends on the OutputType syntax element.

XMLRelation Output Table Schema, OutputType ('fullpath') (Default)

In this table, n is in the range [0, max_depth).] The node at depth 0 is the root.

Column Data Type Description
docid_column INTEGER or VARCHAR [Column appears once for each specified docid_column.] Column copied from input table. Identifier of XML document.
out_nodeid INTEGER Identifier of extracted node. Unique within XML document.
element VARCHAR Node name.
attributes VARCHAR Node attributes. Value has this form:

attributename = value [delimiter value … ]

value_col VARCHAR Node value (text content).
dnelement VARCHAR [Column appears once for each n.] Name of node at depth n.
dnattributes VARCHAR [Column appears once for each n.] Attributes of node at depth n. Value has this form:

attributename = value [delimiter value … ]

dnvalue_col VARCHAR [Column appears once for each n.] Value (text content) of node at depth n.
dnid INTEGER [Column appears once for each n.] Identifier of node at depth n (its out_nodeid).
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.

Output Table Schema, OutputType ('fulldata')

In this table, n is in the range [0, max_depth).] The node at depth 0 is the root.

Column Data Type Description
docid_column INTEGER or VARCHAR [Column appears once for each specified docid_column.] Column copied from input table. Identifier of XML document.
out_nodeid INTEGER Identifier of extracted node. Unique within XML document.
dnelement VARCHAR [Column appears once for each n.] Name of node at depth n.
dnattributes VARCHAR [Column appears once for each n.] Attributes of node at depth n. Value has this form:

attributename = value [delimiter value … ]

dnvalue_col VARCHAR [Column appears once for each n.] Value (text content) of node at depth n.
dnid INTEGER [Column appears once for each n.] Identifier of node at depth n (its out_nodeid).
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.

OutputType Table Schema, OutputType ('parentchild')

Column Data Description
docid_column INTEGER or VARCHAR [Column appears once for each specified docid_column.] Column copied from input table. Identifier of XML document.
out_nodeid INTEGER Identifier of extracted node. Unique within XML document.
element VARCHAR Node name.
attributes VARCHAR Node attributes. Value has this form:

attributename = value [delimiter value … ]

value_col VARCHAR Node value (text content).
parent_id INTEGER Parent node identifier.
accumulate_column Same as in input table Column copied from input table.