FrequentPaths Example 4: SeqPatternTable - Teradata Vantage

Input

• InputTable: bank_web_clicks1, as in FrequentPaths Example 1: ItemColumn

SQL Call

SELECT * FROM FrequentPaths (
  ON bank_web_clicks1 AS InputTable
  OUT TABLE OutputTable (output4)
  OUT TABLE SeqPatternTable (sp_table)
  USING
  PartitionColumns ('session_id')
  TimeColumn ('datestamp')
  ItemColumn ('page')
  MinSupport (2)
) AS dt;

Output

Finished. Totally 69 patterns were found.

This query returns the following table:

SELECT * FROM sp_table ORDER BY 1;

(Row order can vary.)