FrequentPaths.sql

--Syntax (version 2.0)

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_name')
  OUTPUTTABLE('output_table_name')
  PARTITIONCOLUMNS('partition_column_list')
  [TIMECOLUMN('sort_column_name')]
  [PATHFILTERS('filter_list']
  [GROUPBYCOLUMNS(groupby_column_list)]
  [SEQUENCEPATTERNRELATION('sequence_pattern_table_name')]
  [ITEMCOLUMN('sequence_column_name')]
  [ITEMDEFINITION('item_definition_table:
    [id_column:definition_column:item_column]')]
  [PATHCOLUMN('path_column_name')]
  MINSUPPORT('minimum_support_value')
  [MAXLENGTH('maximum_length')]
  [MINLENGTH('minimum_length')]
  [CLOSEDPATTERN('true'|'false']
);