Version 2.7
SELECT * FROM FrequentPaths ( ON { table | view | (query) } AS InputTable ON { table | view | (query) } AS ItemDefinitionTable OUT TABLE OutputTable (output_table) [ OUT TABLE SeqPatternTable (sequence_pattern_table) ] USING PartitionColumns ( { 'partition_column' | partition_column_range }[,...]) [ TimeColumn ('time_column') ] [ PathFilters ([Separator (symbol),] 'filter' [,...]) ] [ GroupByColumns ({ 'group_column' | group_column_range}[,...]) ] { ItemColumn ('sequence_column') | PathColumn ('path_column') | ItemDefinitionColumns ('[index_column:definition_column:item_column]') } MinSupport (minimum) [ MaxLength (maximum_length) ] [ MinLength (minimum_length) ] [ ClosedPattern ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})] ) AS alias;
For the ItemDefinitionColumns syntax element, the brackets inside the parentheses are required. For example:
ItemDefinitionColumns ([id:def:item])