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
SELECT * FROM Sessionize (
  ON { table | view | (query) }
    PARTITION BY expression [,...]
    ORDER BY order_column [,...]
  USING
  TimeColumn ('time_column')
  TimeOut (session_timeout)
  [ ClickLag (min_human_click_lag) ]
  [ EmitNull ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})]
) AS alias;