SAX_Multiple_Input_function.sql

--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
  PARTITION BY partition_columns
  ON <(SELECT partition_column1, partition_column2, ...
              stdev_value1 AS value_column1,
              stdev_value2 AS value_column2, ...
      FROM Statistics_Table)> AS stdevstats
  PARTITION BY partition_columns
  VALUE_COLUMN_NAMES('value_column1', 'value_column2', ...)
  [PAA_INTERVAL('paa_interval_value_column1',
              'paa_interval_value_column2', ...)]
  [ALPHABET_SIZE('alphabet_size_value_column1',
              'alphabet_size_value_column2', ...)]
  [ZNORM('znorm_value_column1', 'znorm_value_column2', ...)]
  [MEAN_VAL('mean_value_column1', 'mean_value_column2', ...)]
  [STDEV_VAL('stdev_value_column1', 'stdev_value_column2', ...)]
  [ACCUMULATE('accumulate_column1', 'accumulate_column2', ...)]
  [TIME_COLUMN_NAME('time_column1', 'time_column2', ...)]
);