PMeinshausen

[ Launch: boxChart Prototype ] 10015145 by PMeinshausen[ Launch: boxChart Prototype ] 10015087 by PMeinshausen

PMeinshausen

--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

PMeinshausen

--Syntax (Single Input function version 1.0)

SELECT * FROM attribution
(
 ON {input_table | view | query}
 PARTITION BY expression [, ...] 
 ORDER BY order_by_columns
 EVENT_COLUMN_NAME('event_column')
 CONVERSION_EVENT_TYPE_VALUE('click1', 'click2', ...)
 [EXCLUDING_EVENT_TYPE_VALUE('email')]

PMeinshausen

--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')
);

PMeinshausen

--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

PMeinshausen

--Syntax (version 1.1)
/*
DWT is adopted to emit a list of coefficients and some meta data for each sequence. 
The function assumes that each sequence can be fitted into the memory of the worker.
*/

SELECT * FROM DWT(
  ON (SELECT 1) PARTITION BY 1 
   [DOMAIN('host:port')]
   [DATABASE('db_name')]

PMeinshausen

--Syntax (version 1.1)

SELECT * FROM DWT2D(
ON (SELECT 1) PARTITION BY 1 
[DOMAIN('host:port')]
[DATABASE('db_name')]
[USERID('user_id')]
[PASSWORD('password')]
[SSLSETTINGS('SSLsettings')]
[SSLTRUSTSTOREPASSWORD('SSLtruststorepassword')]

PMeinshausen

--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')]

PMeinshausen

--This syntax assumes that each sequence can be fitted into the memory of the worker.
--Syntax (version 1.1)

SELECT * FROM IDWT(
  ON (SELECT 1) PARTITION BY 1 
  [DOMAIN('host:port')]
  [DATABASE('db_name')]
  [USERID('user_id')]
  [PASSWORD('password')]
  [SSLSETTINGS('SSLsettings')]

PMeinshausen

--Syntax (version 1.1)

SELECT * FROM IDWT2D(
  ON (SELECT 1) PARTITION BY 1 
  [DOMAIN('host:port')]
  [DATABASE('db_name')]
  [USERID('user_id')]
  [PASSWORD('password')]
  [SSLSETTINGS('SSLsettings')]
  [SSLTRUSTSTOREPASSWORD('SSLtruststorepassword')]