1.0 - 8.00 - FrequentPaths Example 4: SeqPatternTable - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

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

message
Finished. Totally 69 patterns were found.

This query returns the following table:

SELECT * FROM sp_table ORDER BY 1;

(Row order can vary.)

session_id pattern
0 ACCOUNT SUMMARY;FAQ
0 ACCOUNT SUMMARY
0 ACCOUNT SUMMARY;FAQ;ACCOUNT HISTORY
0 ACCOUNT SUMMARY;ACCOUNT HISTORY
0 ACCOUNT SUMMARY;FAQ;ACCOUNT HISTORY;ACCOUNT SUMMARY
0 ACCOUNT SUMMARY;ACCOUNT HISTORY;FUNDS TRANSFER
0 ACCOUNT SUMMARY;FAQ;ACCOUNT HISTORY;VIEW DEPOSIT DETAILS
0 ACCOUNT SUMMARY;ACCOUNT HISTORY;ACCOUNT SUMMARY
0 ACCOUNT SUMMARY;FAQ;FUNDS TRANSFER
0 ACCOUNT SUMMARY;ACCOUNT HISTORY;VIEW DEPOSIT DETAILS
0 ACCOUNT SUMMARY;FAQ;FUNDS TRANSFER;ACCOUNT SUMMARY
0 ACCOUNT SUMMARY;FUNDS TRANSFER
0 ACCOUNT SUMMARY;FAQ;FUNDS TRANSFER;VIEW DEPOSIT DETAILS
0 ACCOUNT SUMMARY;FUNDS TRANSFER;ACCOUNT SUMMARY
0 ACCOUNT SUMMARY;FAQ;ACCOUNT SUMMARY
0 ACCOUNT SUMMARY;FUNDS TRANSFER;VIEW DEPOSIT DETAILS
0 ACCOUNT SUMMARY;FAQ;ACCOUNT SUMMARY;VIEW DEPOSIT DETAILS
... ...