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