nPath Function Results Example | Teradata Vantage - nPath Results Example: ACCUMULATE String over 64000 Characters, DISTINCT - Analytics Database

Input

Input table is banking_web_clicks (see nPath Results Example: ACCUMULATE String over 64000 Characters).

SQL Call

SELECT * FROM nPath (
  ON banking_web_clicks PARTITION BY session_id ORDER BY datestamp
  USING
  Mode (NONOVERLAPPING)
  Pattern ('A*')
  Symbols (TRUE AS A)
  Result (
    FIRST (session_id OF A) AS session_id,
    ACCUMULATE (100000)(DISTINCT page OF A) AS path
  )
) AS dt;

Output

Because ACCUMULATE specifies a size greater than 64000, the data type of the path column is CLOB, even though the length of the value of path is 219.