Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen

PMeinshausen/Path_Summarizer.sql

Created September 18, 2014 11:15
Show Gist options
  • Save PMeinshausen/b94bebb64731887a6473 to your computer and use it in GitHub Desktop.
Save PMeinshausen/b94bebb64731887a6473 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Path_Summarizer.sql
--Syntax (version 1.1)
SELECT * FROM Path_Summarizer(
ON {table_name|view_name|(query)}
PARTITION BY expression [, ...]
[CNT('count_column')]
DELIMITER(',')
SEQ('sequence-column')
PARTITIONNAMES('partitionby-col-name' [, ...])
HASH('true'|'false')
PREFIX('prefix-column')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment