PathAnalyzer Example | Teradata Vantage - PathAnalyzer Example - Teradata Vantage

Input

• InputTable: clickstream1, as in PathGenerator Example

SQL Call

SELECT * FROM PathAnalyzer(
  ON clickstream1 AS InputTable
  OUT TABLE OutputTable(path_output)
  USING
  SeqColumn('path')
  CountColumn('cnt')
  HashCode('false')
  Delimiter(',')
) AS dt ;

Output

 message                                                                                
 -------------------------------------------------------------------------------------- 
Query executed successfully.
 Output is stored in the table specified in OutputTable argument.

SELECT * FROM path_output ORDER BY node;
 node              parent          children                  subpath_cnt depth partitioned       
 ----------------- --------------- ------------------------- ----------- ----- ----------------- 
 ^                                 [(^,a),(^,c),(^,h),(^,p)]          34     0 ^                
 ^,a               ^               [(^,a,h),(^,a,p)]                  11     1 ^,a              
 ^,a,h             ^,a             [(^,a,h,c),(^,a,h,p)]               5     2 ^,a,h            
 ^,a,h,c           ^,a,h           [(^,a,h,c,$)]                       3     3 ^,a,h,c          
 ^,a,h,p           ^,a,h           [(^,a,h,p,$)]                       2     3 ^,a,h,p          
 ^,a,p             ^,a             [(^,a,p,s)]                         6     2 ^,a,p            
 ^,a,p,s           ^,a,p           [(^,a,p,s,o)]                       6     3 ^,a,p,s          
 ^,c               ^               [(^,c,s)]                           1     1 ^,c              
 ^,c,s             ^,c             [(^,c,s,o)]                         1     2 ^,c,s            
 ^,c,s,o           ^,c,s           [(^,c,s,o,e)]                       1     3 ^,c,s,o          
 ^,c,s,o,e         ^,c,s,o         [(^,c,s,o,e,$)]                     1     4 ^,c,s,o,e        
 ^,h               ^               [(^,h,a),(^,h,c),(^,h,e)]          20     1 ^,h              
 ^,h,a             ^,h             [(^,h,a,c),(^,h,a,p)]               6     2 ^,h,a            
 ^,h,a,c           ^,h,a           [(^,h,a,c,p)]                       4     3 ^,h,a,c          
 ^,h,a,c,p         ^,h,a,c         [(^,h,a,c,p,i)]                     4     4 ^,h,a,c,p        
 ^,h,a,c,p,i       ^,h,a,c,p       [(^,h,a,c,p,i,s)]                   4     5 ^,h,a,c,p,i      
 ^,h,a,c,p,i,s     ^,h,a,c,p,i     [(^,h,a,c,p,i,s,o)]                 4     6 ^,h,a,c,p,i,s    
 ^,h,a,c,p,i,s,o   ^,h,a,c,p,i,s   [(^,h,a,c,p,i,s,o,e)]               4     7 ^,h,a,c,p,i,s,o  
 ^,h,a,c,p,i,s,o,e ^,h,a,c,p,i,s,o [(^,h,a,c,p,i,s,o,e,$)]             4     8 ^,h,a,c,p,i,s,o,e
 ^,h,a,p           ^,h,a           [(^,h,a,p,i)]                       2     3 ^,h,a,p          
 ^,h,a,p,i         ^,h,a,p         [(^,h,a,p,i,s)]                     2     4 ^,h,a,p,i        
 ^,h,a,p,i,s       ^,h,a,p,i       [(^,h,a,p,i,s,o)]                   2     5 ^,h,a,p,i,s      
 ^,h,a,p,i,s,o     ^,h,a,p,i,s     [(^,h,a,p,i,s,o,$)]                 2     6 ^,h,a,p,i,s,o    
 ^,h,c             ^,h             [(^,h,c,h),(^,h,c,p)]              12     2 ^,h,c            
 ^,h,c,h           ^,h,c           [(^,h,c,h,p)]                       7     3 ^,h,c,h          
 ^,h,c,h,p         ^,h,c,h         [(^,h,c,h,p,$)]                     7     4 ^,h,c,h,p        
 ^,h,c,p           ^,h,c           [(^,h,c,p,e)]                       5     3 ^,h,c,p          
 ^,h,c,p,e         ^,h,c,p         [(^,h,c,p,e,$)]                     5     4 ^,h,c,p,e        
 ^,h,e             ^,h             [(^,h,e,$)]                         2     2 ^,h,e            
 ^,p               ^               [(^,p,c)]                           2     1 ^,p              
 ^,p,c             ^,p             [(^,p,c,p)]                         2     2 ^,p,c            
 ^,p,c,p           ^,p,c           [(^,p,c,p,s)]                       2     3 ^,p,c,p          
 ^,p,c,p,s         ^,p,c,p         [(^,p,c,p,s,o)]                     2     4 ^,p,c,p,s        
 ^,p,c,p,s,o       ^,p,c,p,s       [(^,p,c,p,s,o,e)]                   2     5 ^,p,c,p,s,o      
 ^,p,c,p,s,o,e     ^,p,c,p,s,o     [(^,p,c,p,s,o,e,$)]                 2     6 ^,p,c,p,s,o,e

The output table is the same as the PathStart Example output.

Download a zip file of all examples and a SQL script file that creates their input tables.