Version 1.8
SELECT * FROM FPGrowth (
ON { table | view | (query) } AS InputTable
[ OUT TABLE OutputPatternTable (output_pattern_table) ]
[ OUT TABLE OutputRuleTable (output_rule_table) ]
USING
TargetColumns ({ 'target_column' | target_column_range }[,...] )
TransactionIDColumns ({ 'trans_id_column' | trans_id_column_range }[,...])
[ PatternsOrRules ({ 'patterns' | 'rules' | 'both' }) ]
[ PartitionColumns ({ 'partition_column' | partition_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;