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. |