1.1 - 8.10 - FrequentPaths Example: SeqPatternTable - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
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

The output table "output4" is identical to the output table shown in FrequentPaths Example: ItemColumn, "output1".

The SequencePatternTable can be shown with the following query:

SELECT session_id, CAST(pattern AS varchar(500)) FROM sp_table ORDER BY 1;

 session_id pattern                                                                         
 ---------- ------------------------------------------------------------------------------- 
          0 account summary;account summary;view deposit details                           
          0 funds transfer;account summary                                                 
          0 account summary;account history;funds transfer                                 
          0 account history;funds transfer                                                 
          0 account summary;account history;view deposit details                           
          0 account summary;funds transfer;view deposit details                            
          0 funds transfer;view deposit details                                            
          0 account history;view deposit details                                           
          0 account summary;funds transfer;account summary                                 
          0 account history;account summary                                                
          0 account summary;funds transfer                                                 
          0 account history                                                                
          0 account summary;view deposit details                                           
          0 account summary;account history;account summary                                
          0 funds transfer                                                                 
          0 account summary                                                                
          0 account summary;account summary                                                
          0 account summary;account history                                                
          0 view deposit details                                                           
          0 account summary;faq;view deposit details                                       
          0 faq;account summary;view deposit details                                       
          0 faq;funds transfer;account summary                                             
          0 faq;account history                                                            
          0 faq;account summary                                                            
          0 account summary;faq;account summary                                            
          0 account summary;faq                                                            
          0 faq                                                                            
          0 account summary;faq;funds transfer                                             
          0 faq;account history;account summary                                            
          0 faq;account history;view deposit details                                       
          0 faq;funds transfer                                                             
          0 account summary;faq;account history                                            
          0 account summary;faq;funds transfer;account summary                             
          0 faq;view deposit details                                                       
          0 account summary;faq;account history;view deposit details                       
          0 account summary;faq;funds transfer;view deposit details                        
          0 account summary;faq;account summary;view deposit details                       
          0 faq;funds transfer;view deposit details                                        
          0 account summary;faq;account history;account summary                            
          1 account summary                                                                
          1 funds transfer;account summary                                                 
          1 account history;account summary                                                
          1 account history;account history                                                
          1 view deposit details                                                           
          1 account summary;view deposit details                                           
          1 account summary;account summary;account summary                                
          1 account summary;view deposit details;account history                           
          1 funds transfer;view deposit details                                            
          1 account summary;funds transfer;account history                                 
          1 account summary;account history;view deposit details                           
          1 view deposit details;account history                                           
          1 account summary;account summary;account history;account summary                
          1 account history;account summary;account history                                
          1 funds transfer;view deposit details;account history                            
          1 account summary;funds transfer;account summary                                 
          1 account summary;account summary;account summary;account summary                
          1 funds transfer;account history                                                 
          1 account history                                                                
          1 account summary;funds transfer;view deposit details;account history            
          1 account history;view deposit details                                           
          1 account summary;account history;account summary;account history                
          1 account summary;account history;account summary                                
          1 account summary;account history                                                
          1 account summary;account summary                                                
          1 account summary;funds transfer;view deposit details                            
          1 account summary;account history;account history                                
          1 funds transfer                                                                 
          1 account summary;funds transfer                                                 
          1 account summary;account summary;view deposit details                           
          1 account summary;account summary;account history                                
          1 account summary;account summary;funds transfer                                 
          1 account summary;account summary;account summary;account history                
          1 account summary;account summary;account summary;account history;account summary
          1 account summary;account summary;account summary;funds transfer                 
          1 account summary;faq;view deposit details                                       
          1 account summary;faq;funds transfer;view deposit details                        
          1 account summary;faq;funds transfer                                             
          1 account summary;faq;account summary                                            
          1 account summary;faq;account summary;account summary                            
          1 faq;account summary                                                            
          1 account summary;faq                                                            
          1 account summary;account summary;faq;account summary;account summary            
          1 account summary;faq;funds transfer;account summary                             
          1 account summary;account summary;faq;account summary                            
          1 account summary;faq;account summary;view deposit details                       
          1 account summary;account summary;faq                                            
          1 account summary;faq;account history;account summary                            
          1 faq                                                                            
          1 faq;view deposit details                                                       
          1 faq;account summary;account summary                                            
          1 faq;account history;view deposit details                                       
          1 faq;funds transfer                                                             
          1 faq;account history                                                            
          1 faq;funds transfer;account summary                                             
          1 faq;funds transfer;view deposit details                                        
          1 faq;account history;account summary                                            
          1 account summary;faq;account history;view deposit details                       
          1 account summary;faq;account history                                            
          1 faq;account summary;view deposit details                                       
          2 faq;faq                                                                        
          2 account history;funds transfer                                                 
          2 account history                                                                
          2 account summary;account history;account summary                                
          2 account summary;funds transfer                                                 
          2 account summary;account summary;account history                                
          2 account summary;account summary;account summary;funds transfer                 
          2 account summary;account summary;account summary;account history;account summary
          2 account summary;account summary;account summary                                
          2 account history;account summary                                                
          2 account summary;faq;faq                                                        
          2 account summary;account history;funds transfer                                 
          2 account summary                                                                
          2 account summary;account summary;funds transfer                                 
          2 account summary;account summary;account history;account summary                
          2 account summary;account summary;account summary;account summary                
          2 account summary;account history                                                
          2 funds transfer                                                                 
          2 account summary;account summary;account summary;account history                
          2 account summary;account summary                                                
          2 faq                                                                            
          2 account history;account summary;faq                                            
          2 account summary;account history;faq                                            
          2 account summary;account summary;faq                                            
          2 account history;faq                                                            
          2 account summary;faq                                                            
          2 account summary;account history;account summary;faq                            
          2 account summary;account summary;account history;faq                            
          3 account summary;account history;account history                                
          3 account summary;account history;account summary                                
          3 account summary                                                                
          3 account history;account summary;account history                                
          3 account history;account history                                                
          3 account history;account summary                                                
          3 account history                                                                
          3 account summary;account summary;account summary;account summary                
          3 account summary;account summary;account history;account summary                
          3 account summary;account summary                                                
          3 account summary;account history;account summary;account history                
          3 account summary;account summary;account summary                                
          3 account summary;account history                                                
          3 account summary;account summary;account history                                
          3 account summary;account summary;faq;account summary                            
          3 account summary;account summary;account history;faq                            
          3 faq;account summary;account summary                                            
          3 faq                                                                            
          3 account history;account summary;faq                                            
          3 account summary;account history;account summary;faq                            
          3 account summary;faq;account summary                                            
          3 account summary;account summary;faq;account summary;account summary            
          3 account summary;account summary;faq                                            
          3 account summary;account history;faq                                            
          3 faq;account summary                                                            
          3 account history;faq                                                            
          3 account summary;faq;account summary;account summary                            
          3 account summary;faq                                                            
          4 faq;faq                                                                        
          4 account summary;view deposit details                                           
          4 account summary                                                                
          4 view deposit details                                                           
          4 account summary;faq;faq                                                        
          4 account summary;faq;view deposit details                                       
          4 faq;view deposit details                                                       
          4 faq                                                                            
          4 account summary;faq                                                            
          5 view deposit details                                                           
          5 account history                                                                
          5 view deposit details;account history                                           
          5 account summary;account history                                                
          5 account summary;view deposit details;account history                           
          5 funds transfer;account history                                                 
          5 funds transfer                                                                 
          5 funds transfer;view deposit details                                            
          5 account summary;funds transfer;account history                                 
          5 account summary;funds transfer;view deposit details;account history            
          5 funds transfer;view deposit details;account history                            
          5 account summary;view deposit details                                           
          5 account summary;funds transfer;view deposit details                            
          5 account summary;funds transfer                                                 
          5 account summary

(Row order can vary.)

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