7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)

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.