Version 1.14
SELECT * FROM FPGrowth (
ON { table | view | (query) } AS InputTable
[ OUT TABLE OutputPatternsTable (output_patterns_table) ]
[ OUT TABLE OutputRulesTable (output_rules_table) ]
USING
TargetColumns ({ 'target_column' | target_column_range }[,...] )
TransactionIDColumns ({ 'trans_id_column' | trans_id_column_range }[,...])
[ PatternsOrRules ({ 'patterns' | 'rules' | 'both' }) ]
[ GroupByColumns ({ 'group_by_column' | group_by_column_range }[,...]) ]
[ PatternDistributionKeyColumn ('p_distribution_key_column') ]
[ RuleDistributionKeyColumn ('r_distribution_key_column') ]
[ CompressionLevel ({ 'nocompress' | 'high' | 'medium' | 'low' }) ]
[ GroupSize (group_size) ]
[ MinSupport (min_support) ]
[ MinConfidence (min_confidence) ]
[ MaxPatternLength (pattern_length) ]
[ AntecedentCountRange ('lower-bound_upper_bound') ]
[ ConsequenceCountRange ('lower-bound_upper_bound') ]
[ Delimiter ('delimiter') ]
) AS alias;