Version 1.2
SELECT * FROM FPGrowth ( ON (SELECT 1) PARTITION BY 1 [ Domain ('host:port') ] [ Database ('db_name') ] [ UserID ('user_id') ] [ Password ('password') ] [ SSLSettings ('SSLsettings') ] [ SSLTrustStorePassword ('SSLtruststorepassword') ] InputTable ('input_table') [ OutputPatternTable ('output_pattern_table') ] [ OutputRuleTable ('output_rule_table') ] TranItemColumns ({ 'item_column' | 'item_column_range' }[,...] ) TranIDColumns ({ 'id_column' | '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') ] [ Compress ({ 'nocompress' | 'high' | 'medium' | 'low' }) ] [ DropTable ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] [ GroupSize (group_size) ] [ MinSupport (min_support) ] [ MinConfidence (min_confidence) ] [ MaxPatternLength (pattern_length) ] [ AntecedentCountRange ('lower-bound_upper_bound') ] [ ConsequenceCountRange ('lower-bound_upper_bound') ] [ Delimiter ('delimiter') ] );
For information about the authentication arguments, see the following topics: