1.0 - 8.00 - PathStart Example - 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 PathStart (
  ON (
    SELECT * FROM PathSummarizer (
      ON PathGenerator (
        ON clickstream1
        USING
        SeqColumn ('path')
        Delimiter (',')
      ) PARTITION BY prefix
      USING
      SeqColumn ('sequence')
      PrefixColumn ('prefix')
      PartitionNames ('prefix')
      Delimiter (',')
      CountColumn ('cnt')
      HashCode ('false')
    ) AS dt2
  ) PARTITION BY (parent)
  USING
  CountColumn ('cnt')
  Delimiter (',')
  ParentColumn ('parent')
  PartitionNames ('partitioned')
  NodeColumn ('node')
) AS dt ORDER BY depth ASC, node;

Output

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