The output table format depends on the values of the Output and WindowType arguments.
For 'string' or 'bytes' output, the output table has only one row for a 'global' window, but multiple rows for a 'sliding' window. The following table describes the output table columns. In the column names, n varies from 1 to N.
| Column Name | Data Type | Description |
|---|---|---|
| accumulate_column | Any | A column to be included in the output table, specified with the Accumulate argument. |
| time_column_start | Numeric or time SQL data type | The point on the time axis where the window starts. |
| time_column_end | Numeric or time SQL data type | The point on the time axis where the window ends. |
| value_column_n_saxcode | VARCHAR for 'string', BYTE for 'bytes' | The SAX code for the nth window; a string for 'string', a byte array for 'bytes'. |
| value_column_n_mean | DOUBLE PRECISION | The mean value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'. |
| value_column_n_stdev | DOUBLE PRECISION | The standard deviation value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'. |
For 'bitmap' output, the output table has only one row, whose columns are described in the following table. In column names, n varies from 1 to N.
| Column Name | Data Type | Description |
|---|---|---|
| accumulate_column | Any | A column to be included in the output table, specified with the Accumulate argument. |
| time_columnstart | Numeric or time SQL data type | The point on the time axis where the window starts. |
| time_column_end | Numeric or time SQL data type | The point on the time axis where the window ends. |
| value_column_n_bitmap | VARCHAR | The bitmap value for the nth window; a JSON string containing key-value pairs of the form "xx":d, where "xx" is a SAX code and d is a value between 0.00 and 1.00. |
For 'characters' output, each SAX symbol has its own row in the output table. You can input this output table to the function HMMUnsupervisedLearner.
| Column Name | Data Type | Description |
|---|---|---|
| accumulate_column | Any | A column to be included in the output table, specified with the Accumulate argument. |
| key | VARCHAR | The column on which the input table is partitioned. |
| time_column_start | Numeric or time SQL data type | The point on the time axis where the window starts. |
| time_columnend | Numeric or time SQL data type | The point on the time axis where the window ends. |
| saxchar_n | CHAR(1) | The character value for the nth window. |
| value_column_n_mean | DOUBLE PRECISION | The mean value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'. |
| value_column_n_stdev | DOUBLE PRECISION | The standard deviation value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'. |