入力
sessionize_table| partition_id |
clicktime |
userid |
productname |
pagetype |
referrer |
productprice |
|---|
| 1 |
1110000 |
333 |
|
Home |
www.yahoo.com |
|
| 1 |
1112000 |
333 |
Ipod |
Checkout |
www.yahoo.com |
200.2 |
| 1 |
1160000 |
333 |
Bose |
Checkout |
|
340 |
| 1 |
1200000 |
333 |
|
Home |
www.google.com |
|
| 1 |
1203000 |
67403 |
|
Home |
www.google.com |
|
| 1 |
1300000 |
67403 |
|
Home |
www.google.com |
|
| 1 |
1301000 |
67403 |
|
Home |
|
|
| 1 |
1302000 |
67403 |
|
Home |
|
|
| 1 |
1340000 |
67403 |
Iphone |
Checkout |
|
650 |
| 1 |
1450000 |
67403 |
Bose |
Checkout |
|
750 |
| 1 |
1450200 |
80000 |
|
Home |
godaddy.com |
|
| 1 |
1450600 |
80000 |
Bose |
Checkout |
|
340 |
| 1 |
1450800 |
80000 |
Itrip |
Checkout |
|
450 |
| 1 |
1452000 |
880000 |
Iphone |
Checkout |
|
650 |
SQL呼び出し
SELECT * FROM Sessionize (
ON sessionize_table PARTITION BY partition_id ORDER BY clicktime
USING
TimeColumn ('clicktime')
TimeOut (60)
ClickLag (0.2)
) ORDER BY partition_id, clicktime;
出力
列1～5| partition_id |
clicktime |
userid |
productname |
pagetype |
|---|
| 1 |
1110000 |
333 |
|
Home |
| 1 |
1112000 |
333 |
Ipod |
Checkout |
| 1 |
1160000 |
333 |
Bose |
Checkout |
| 1 |
1200000 |
333 |
|
Home |
| 1 |
1203000 |
67403 |
|
Home |
| 1 |
1300000 |
67403 |
|
Home |
| 1 |
1301000 |
67403 |
|
Home |
| 1 |
1302000 |
67403 |
|
Home |
| 1 |
1340000 |
67403 |
Iphone |
Checkout |
| 1 |
1450000 |
67403 |
Bose |
Checkout |
| 1 |
1450200 |
80000 |
|
Home |
| 1 |
1450600 |
80000 |
Bose |
Checkout |
| 1 |
1450800 |
80000 |
Itrip |
Checkout |
| 1 |
1452000 |
880000 |
Iphone |
Checkout |
列6～9| referrer |
productprice |
SESSIONID |
CLICKLAG |
|---|
| www.yahoo.com |
|
0 |
f |
| www.yahoo.com |
200.2 |
0 |
f |
| |
340 |
0 |
f |
| www.google.com |
|
0 |
f |
| www.google.com |
|
0 |
f |
| www.google.com |
|
1 |
f |
| |
|
1 |
f |
| |
|
1 |
f |
| |
650 |
1 |
f |
| |
750 |
2 |
f |
| godaddy.com |
|
2 |
t |
| |
340 |
2 |
f |
| |
450 |
2 |
t |
| |
650 |
2 |
f |