1.0 - 8.00 - FrequentPaths Example 5: PathFilters - 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 (output5)
  USING
  PartitionColumns ('session_id')
  TimeColumn ('datestamp')
  ItemColumn('page')
  PathFilters ('STW(ACCOUNT SUMMARY) EDW(ACCOUNT HISTORY)')
  MinSupport (2)
) AS dt;

Output

message
Finished. Totally 15 patterns were found.

This query returns the following table:

SELECT * FROM output5 ORDER BY 3 DESC, 2 DESC, 1;
                               pattern                               | support | length 
---------------------------------------------------------------------+---------+--------
 ACCOUNT SUMMARY;FUNDS TRANSFER;VIEW DEPOSIT DETAILS;ACCOUNT HISTORY |       2 |      4
 ACCOUNT SUMMARY;FUNDS TRANSFER;ACCOUNT HISTORY                      |       2 |      3
 ACCOUNT SUMMARY;FUNDS TRANSFER;VIEW DEPOSIT DETAILS                 |       2 |      3
 ACCOUNT SUMMARY;VIEW DEPOSIT DETAILS;ACCOUNT HISTORY                |       2 |      3
 FUNDS TRANSFER;VIEW DEPOSIT DETAILS;ACCOUNT HISTORY                 |       2 |      3
 ACCOUNT SUMMARY;ACCOUNT HISTORY                                     |       2 |      2
 ACCOUNT SUMMARY;FUNDS TRANSFER                                      |       2 |      2
 ACCOUNT SUMMARY;VIEW DEPOSIT DETAILS                                |       2 |      2
 FUNDS TRANSFER;ACCOUNT HISTORY                                      |       2 |      2
 FUNDS TRANSFER;VIEW DEPOSIT DETAILS                                 |       2 |      2
 VIEW DEPOSIT DETAILS;ACCOUNT HISTORY                                |       2 |      2
 ACCOUNT HISTORY                                                     |       2 |      1
 ACCOUNT SUMMARY                                                     |       2 |      1
 FUNDS TRANSFER                                                      |       2 |      1
 VIEW DEPOSIT DETAILS                                                |       2 |      1
(15 rows)