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