nPath Function Results Example | Teradata Vantage - nPath Results Example: Hindi Input, ACCUMULATE DISTINCT and CDISTINCT - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

Input

unicode_path
id price event
2 2.20000000000000E 000 ఈవట1
2 5.13300000000000E 001 ఈవట2
2 9.88123000000000E 002 ఈవట3
2 -1.20000000000000E-001 ఈవట4
2 1.10000000000000E 000 ఈవట5
2 1.12000000000000E 001 ఈవట5
2 1.22000000000000E 001 ఈవట5
2 1.20000000000000E 000 ఈవట1

SQL Call

SELECT * FROM nPath (
  ON unicode_path PARTITION BY id
  USING
  Mode (NONOVERLAPPING)
  Pattern ('A*')
  Symbols (true AS A)
  Result (
    ACCUMULATE (DISTINCT event OF A DELIMITER ',  ' ) AS acc_result_distinct,
    ACCUMULATE (CDISTINCT event OF A DELIMITER ',  ' ) AS acc_result_cdistinct
  )
) AS dt;

Output

acc_result_distinct acc_result_cdistinct
[ఈవట3, ఈవట5, ఈవట1, ఈవట4, ఈవట2] [ఈవట3, ఈవట5, ఈవట1, ఈవట4, ఈవట2, ఈవట1]