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