XMLRelation Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

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.