Version
2.1
SELECT * FROM FrequentPaths ( ON (SELECT 1) PARTITION BY 1 [ Domain ('host:port') ] [ Database ('db_name') ] [ UserID ('user_id') ] [ Password ('password') ] [ SSLSettings ('SSLsettings') ] [ SSLTrustStorePassword ('SSLtruststorepassword') ] InputTable ('input_table') OutputTable ('output_table') [ PartitionColumns ( { 'partition_column' | 'partition_column_range' }[,...]) ] [ TimeColumn ('time_column') ] [ PathFilters ([Separator (symbol),] 'filter' [,...]) ] [ GroupByColumns ({ 'group_by_column' | 'group_by_column_range'[,...]) ] [ SeqPatternTable ('sequence_pattern_table') ] { ItemColumn ('sequence_column') | ItemDefinition ('item_definition_table: [ index_column:definition_column:item_column ]') ] | PathColumn ('path_column')} MinSupport ('minimum') [ MaxLength ('maximum_length') ] [ MinLength ('minimum_length') ] [ ClosedPattern ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})] );
For the ItemDefinition argument, the brackets inside the parentheses are required. For example:
ItemDefinition (id_def_table:[id:def:item])
For information about the authentication arguments, see the following topics: