入力
入力テーブルは、LAG式とLEAD式の例: 入力問合わせの別名なしによるaggregate_clicksです。
SQL-MapReduce呼び出し
SELECT * FROM nPath ( ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime USING Mode (NONOVERLAPPING) Pattern ('^H.A*.P1.A*') Symbols (pagetype='home' AS H, pagetype='page1' AS P1, TRUE AS A) Result ( FIRST (sessionid OF A) AS sessionid, ACCUMULATE (pagetype OF ANY(H,P1,A)) AS path ) ) AS dt ORDER BY dt.sessionid;
出力
sessionid | path |
---|---|
1 | [home, home1, page1, home, home1, page1, home, home, home, home1, page1, checkout, home, home, home, home, home, home, home, home, home] |
2 | [home, home, home, home, home, home, home, home, home, home1, page1, checkout, checkout, home, home] |
3 | [home, home, home, home, home, home, home, home, home1, page1, home, home1, page1, home] |
4 | [home, home, home, home, home, home, home1, home1, home1, page1, page1, page1] |
5 | [home, home, home, home, home1, home1, home1, page1, page1, page1, page2, page2, page2, checkout, checkout, checkout, page2, page2, page2] |