nPath Function Results Example | Teradata Vantage - nPath Results Example: ACCUMULATE String over 64000 Characters, CDISTINCT - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-02-17
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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)(CDISTINCT 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. The length of the value of path is 82887.

session_id path
1 [ONLINE STATEMENT ENROLLMENT, CUSTOMER SUPPORT, ACCOUNT HISTORY, VIEW DEPOSIT DETAILS, PROFILE UPDATE, FREQUENTLY ASKED QUESTIONS, FUNDS TRANSFER, ACCOUNT HISTORY, ONLINE STATEMENT ENROLLMENT, BANK STATEMENT, COMPLAINTS, BANK STATEMENT, ACCOUNT SUMMARY, COMPLAINTS, FUNDS TRANSFER, … , BANK STATEMENT, CUSTOMER SUPPORT]