Output Table Schema
Column | Data Type | Description |
---|---|---|
node | CLOB | Path to node, including node itself. |
parent | CLOB | Parent of node (path traveled to node). |
children | CLOB | Children of node (paths traveled from node), a list of subsequences with this syntax:[(subsequence)[,...]] Outer brackets appear in table. |
cnt | INTEGER or BIGINT | Count (sum) of values in input table column count_column. |
depth | INTEGER or BIGINT | Number of steps on path to node. |
prefix | CLOB | Subsequence of node, copied from input table column prefix_column. |