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

PMeinshausen

--Syntax (version 1.2)

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

PMeinshausen

--Syntax (version 1.2)

SELECT * FROM Path_Generator(
  ON {table_name | view_name | (query)}
  SEQ('sequence_column')
  [DELIMITER('delimiter_character')]
);

PMeinshausen

--Syntax (version 1.1)

SELECT * FROM Path_Start( 
  ON table_name
  PARTITION BY expression [, ...]
  CNT('count-column')
  [DELIMITER(',')]
  PARENT('parent-column')
  PARTITIONNAMES('partitionby-col-name' [, ...])
  NODE('node-column')

PMeinshausen

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

PMeinshausen

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

PMeinshausen

--Syntax (Multiple Input function version 1.1)

SELECT * FROM SAX(
  ON {table_name | view_name | (query)} as input 
  PARTITION BY partition_columns
  ORDER BY ordering_columns
  ON <(SELECT partition_column1, partition_column2, ...
              mean_value1 AS value_column1,
              mean_value2 AS value_column2, ...
      FROM Statistics_Table)> as meanstats

PMeinshausen

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

PMeinshausen

--Syntax (version 1.0)

SELECT [ALL | DISTINCT [ON (expression [, ...])]] 
  * | expression [[AS] output_name] [, ...]
  FROM NPATH(on_clause1 [on_clause2 ... on_clausen]
    PARTITION BY expression [, ...]
    ORDER BY expression [ASC | DESC] [,...]
    MODE({OVERLAPPING | NONOVERLAPPING}) PATTERN('pattern_of_symbols')
    SYMBOLS(symbol_predicate AS symbol [, ...])
    [FILTER(filter_expression[, ...])]

PMeinshausen

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