SQL-MapReduce Call - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
SELECT * FROM npath (
  ON aggregate_clicks
  PARTITION BY sessionid
  ORDER BY clicktime
  MODE (overlapping)
  PATTERN ('A.A')
  SYMBOLS (TRUE AS A)
  RESULT (FIRST(sessionid OF A) AS sessionid,
  ACCUMULATE (pagetype OF A) AS path)
) ORDER BY sessionid;