16.20 - Sessionizeの例 - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engineの分析関数

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
プログラミング リファレンス
featnum
B035-1206-162K-JPN

入力

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