- OutputPatternTable
- [Required if PatternsOrRules is 'patterns' or 'both', disallowed otherwise] Specify the name of the table where the function outputs the patterns.
- OutputRuleTable
- [Required if PatternsOrRules is 'patterns' or 'both', disallowed otherwise] Specify the name of the table where the function outputs the rules.
- TargetColumns
- Specify the names of the columns that contain transaction items to analyze.
- TransactionIDColumns
- Specify the names of the columns that contain identifiers for the transaction items.Do not specify the same column in both this argument and the PartitionColumns argument, because this causes incorrect counting in the partitions.
- PatternsOrRules
- [Optional] Specify whether the function outputs patterns, rules, or both. An example of a pattern is {onions, potatoes, hamburger}.
- PartitionColumns
- [Optional] Specify the names of columns that define the partitions into which the function groups the input data and calculates output for it. At least one column must be usable as a distribution key.Do not specify the same column in both this argument and the TransactionIDColumns argument, because this causes incorrect counting in the partitions.
- PatternDistributionKeyColumn
- [Optional] Specify the name of the column to use as the distribution key for output_pattern_table.
- RuleDistributionKeyColumn
- [Optional] Specify the name of the column to use as the distribution key for output_rule_table.
- CompressionLevel
- [Optional] Specify the compression level the output tables.
- GroupSize
- [Optional] Specify the number of transaction items to assign to each worker. This value must be an INTEGER in the range from 1 to the number of distinct transaction items, inclusive. For a machine with limited RAM, use a relatively small value.
- MinSupport
- [Optional] Specify the minimum support value of returned patterns (including the specified support value). This value must be a NUMERIC in the range [0, 1].
- MinConfidence
- [Optional] Specify the minimum confidence value of returned patterns (including the specified confidence value). This value must be a NUMERIC in the range [0, 1].
- MaxPatternLength
- [Optional] Specify the maximum length of returned patterns. The length of a pattern is the sum of the item numbers in the antecedent and consequence columns. This value must be an INTEGER greater than 2. MaxPatternLength also limits the length of returned rules to this value.
- AntecedentCountRange
- [Optional] Specify the range for na, the number of items in the antecedent. The function returns only patterns for which na is in the range [lower_bound, upper_bound]. The lower_bound must be greater an integer greater than 0. The lower_bound and upper_bound can be equal.
- ConsequenceCountRange
- [Optional] Specify the range for nc, the number of items in the consequence. The function returns only patterns for which nc is in the range [lower_bound, upper_bound]. The lower_bound must be greater an integer greater than 0. The lower_bound and upper_bound can be equal.
- Delimiter
- [Optional] Specify the delimiter that separates items in the output.