SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
SELECT * FROM npath (
  ON clickstream PARTITION BY userid ORDER BY clicktime
  Symbols (pagetype='home' AS home,
    pagetype!='home' AND pagetype!='checkout' AS view,
    pagetype='checkout' AS checkout)
  Pattern ('home.view*.checkout')
  Result (FIRST(userid of ANY(home, checkout, view)) AS userid,
    FIRST (sessionid of ANY(home, checkout, view)) AS sessionid,
    COUNT (* of any(home, checkout, view)) AS cnt,
    FIRST (clicktime of ANY(home)) AS firsthome,
    LAST (clicktime of ANY(checkout)) AS lastcheckout)
  Filter (FIRST (clicktime + '10 minutes' ::interval OF ANY (home)) > 
    FIRST (clicktime of any(checkout))) 
  Mode (NONOVERLAPPING)
);