Example 1: Accumulate Pages Visited in Each Session - Teradata® Database

SQL-MapReduce Call

SELECT * FROM NPATH (
   ON aggregate_clicks
   PARTITION BY sessionid
   ORDER BY clicktime
   USING
   MODE (nonoverlapping)
   PATTERN ('A*')
   SYMBOLS (TRUE AS A)
   RESULT (FIRST (sessionid OF A) AS sessionid,
   ACCUMULATE (pagetype OF A) AS path)
) as dt ORDER BY dt.sessionid;

Output