入力
入力テーブルは、LAG式とLEAD式の例: 入力問合わせの別名なしによるaggregate_clicksです。
SQL-MapReduce呼び出し
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;
出力
sessionid | product |
---|---|
1 | envelopes |
2 | tables |
3 | bookcases |
4 | tables |
5 | Appliances |