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',
                  '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', ...)]
);