Example 5: Find First Product with Multiple Referrers in Any Session - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
16.10
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-05-10
dita:mapPath
hoj1499019223447.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata® Database

SQL-MapReduce Call

SELECT * FROM NPATH (
   ON aggregate_clicks
   PARTITION BY sessionid
   ORDER BY clicktime
   USING
   MODE (nonoverlapping)
   PATTERN ('REFERRER{2,}')
   SYMBOLS (referrer IS NOT NULL AS REFERRER)
   RESULT (FIRST(sessionid OF REFERRER) AS sessionid,
   FIRST(productname OF REFERRER) AS product)
) as dt ORDER BY dt.sessionid;

Output

nPath Range-Matching Example 5 Output Table
sessionid product
1 envelopes
2 tables
3 bookcases
4 tables
5 Appliances