XMLRelation Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

The output table schema depends on the OutputType argument.

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.