1.0 - 8.00 - FrequentPaths Input - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)
Table Description
InputTable Contains sequence data to process, in either of these formats:
Format Description
Sequence/path Each row contains a string of format '[item[,...]]'. Outer brackets belong to string (for example, '[A, B, C, D]').

To output strings in this format, use Introduction to nPath function with its Accumulate argument.

Item Each row represents one item in a sequence.

With this format, specify either ItemDefinitionTable or ItemColumn argument.

ItemDefinitionTable [Optional] Required if you omit both ItemColumn and PathColumn arguments.
The function ignores input rows with NULL values.

InputTable Schema

Column Data Type Description
partition_column INTEGER, SHORT, or LONG Sequence index. Rows with same index belong to same sequence.
item_column CHARACTER or VARCHAR [Appears only if you omit ItemDefinitionTable.] Sequence item.
time_column Any except DOUBLE PRECISION [Optional] Sequence item timestamp. Items in same sequence with same time stamp belong to same item set.
path_column CHARACTER or VARCHAR [Optional] Paths (as sequence strings).

ItemDefinitionTable Schema

Column Data Type Description
index_column INTEGER, SHORT, or LONG Used to determine when more than one predicate in definition_column is satisfied, in which case item_column applies.
definition_column CHARACTER or VARCHAR Predicate definition.
item_column CHARACTER or VARCHAR Sequence item for which predicate is true.

Function applies predicates to input table in index order. If more than one predicate is true for a row, function assigns row the value that corresponds to predicate with smallest index.

If input table row has no corresponding definition in item definition table, function skips that row.