Skip to content

Instantly share code, notes, and snippets.

Paul Meinshausen PMeinshausen

Block or report user

Report or block PMeinshausen

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@PMeinshausen
PMeinshausen / _.md
Created Apr 7, 2014
boxChart Prototype
View _.md
@PMeinshausen
PMeinshausen / _.md
Created Apr 7, 2014
boxChart Prototype
View _.md
View Attribution_Multiple.sql
--Syntax (Multiple Input version 2.1)
SELECT * FROM Attribution(
ON {input_table | view | query}
PARTITION BY user_id
ORDER BY time_stamp
[ON {input_table_n | view_n | query_n}
PARTITION BY user_id
ORDER BY time_stamp [...]]
ON conversion_event_table AS conversion DIMENSION
View DTW.sql
--Syntax (version 1.0)
SELECT * FROM DTW(
ON input_timeseries_table
PARTITION BY partition_columns
ORDER BY ordering_columns
ON template_timiseries_table AS template_table
DIMENSION
ORDER BY ordering_columns
ON mapping_table AS mapping_table
View ADC.sql
--Syntax (version 1.0)
--You call this function by combining a local row function followed by a partition function:
SELECT * FROM ApproxDCountReduce(
ON(SELECT * FROM ApproxDCountMap(
ON {table_name | view_name | (query)}
COLUMNS ('column_name')
[ERROR ('error_tolerance')]
)
View EMAVG.sql
--Syntax (version 1.1)
SELECT * FROM EMAVG(
ON {table_name|view_name|(query)}
PARTITION BY partition_column
ORDER BY order_by_column
[COLUMNS('column_names')]
[RETURN_ALL('true'|'false')]
[START_ROWS('number')]
[ALPHA('alpha_value')]
View FrequentPaths.sql
--Syntax (version 2.0)
SELECT * FROM FrequentPaths(
ON (SELECT 1)
PARTITION BY 1
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
View SAX_Partition_function.sql
--Syntax (Partition function version 1.1)
SELECT * FROM SAX (
ON {table_name | view_name | (query)}
PARTITION BY partition_column
ORDER BY ordering_columns
VALUE_COLUMN_NAMES('value_column1', 'value_column2', ...)
[PAA_SIZE('paa_size_value_column1', 'paa_size_value_column2', ...)]
[MAX_PAA_SIZE('max_paa_value')]
[ALPHABET_SIZE('alphabet_size_value_column1',
View ApproximatePercentile.sql
--Syntax (ApproxPercentileMap version 1.1;
--ApproxPercentileReduce version 1.0)
--The synopsis below shows the syntax for invoking the approximate percentile function for
--a column of data, grouping the data by a different set of columns:
SELECT * FROM ApproxPercentileReduce(
ON(
SELECT * FROM ApproxPercentileMap(
ON {table_name | view_name | (query)}
View CMAVG.sql
--Syntax (version 1.1)
SELECT * FROM CMAVG(
ON {table_name|view_name|(query)}
PARTITION BY partition_column
ORDER BY order_by_column
COLUMNS('column_names')
);
You can’t perform that action at this time.