7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The FPGrowth function has one required input table. The following table describes its columns.

FPGrowth Input Table Schema
Column Name Data Type Description
item_column Any except BYTEINT The table can have more than one such column. These columns contain the transaction items to analyze.
id_column Any The table can have more than one such column. These columns contain the identifiers of the transaction items.
group_by_column Any The table can have more than one such column. These columns define the partitions for the input data. At least one column must be usable as a distribution key.
p_distribution_key_column Any Contains the distribution key for output_pattern_table.
r_distribution_key_column Any Contains the distribution key for output_rule_table.