The FrequentPaths function outputs an output message and output table and, optionally, a sequence pattern table.
FrequentPaths Output Message
| Column Name |
Data Type |
Description |
| message |
VARCHAR |
Message that reports the number of patterns found. |
FrequentPaths Output Table Schema
| Column Name |
Data Type |
Description |
| pattern |
VARCHAR |
Patterns (subsequences) in string format ('item [,...]'). |
| support |
INTEGER |
Support value of pattern. |
| length |
INTEGER |
Length of pattern. |
|
group_by_column
|
VARCHAR |
Column copied from the input table. This column appears only if you specify the GroupByColumns argument. |
FrequentPaths Sequence Pattern Table Schema
| Column Name |
Data Type |
Description |
|
partition_column
|
Same as in input table |
Column that is, or is part of, the partition key of the input table sequences. |
| pattern |
VARCHAR |
Pattern found in the sequence specified by partition_column. |