Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen

PMeinshausen/Sessionization.sql

Created September 18, 2014 11:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save PMeinshausen/4cacd81e23f66a08c208 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save PMeinshausen/4cacd81e23f66a08c208 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Sessionization.sql
--Syntax (version 1.2)
SELECT * FROM Sessionize(
ON {table_name | view_name | (query)}
PARTITION BY expression [, ...]
ORDER BY order_by_columns
TIMECOLUMN ('timestamp_column')
TIMEOUT (session_timeout_value)
[RAPIDFIRE (min_human_click_lag)]
[EMITNULL]
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment