FrequentPaths Example: PathFilters - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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. 15 patterns were found.


SELECT CAST(pattern AS varchar(500)), support, length FROM output5 ORDER BY 3 DESC, 2 DESC;

 pattern                                                             support length 
 ------------------------------------------------------------------- ------- ------ 
 account summary;funds transfer;view deposit details;account history       2      4
 funds transfer;view deposit details;account history                       2      3
 account summary;funds transfer;view deposit details                       2      3
 account summary;funds transfer;account history                            2      3
 account summary;view deposit details;account history                      2      3
 account summary;funds transfer                                            2      2
 funds transfer;account history                                            2      2
 account summary;view deposit details                                      2      2
 view deposit details;account history                                      2      2
 account summary;account history                                           2      2
 funds transfer;view deposit details                                       2      2
 account summary                                                           2      1
 account history                                                           2      1
 view deposit details                                                      2      1
 funds transfer                                                            2      1

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.