The output table format depends on the OutputType argument. For OutputType ('string') or OutputType ('bytes'), the format also depends on the WindowType argument.
Output Table Schema, OutputType ('string') or OutputType ('bytes')
The table has only one row for a 'global' window, but multiple rows for a 'sliding' window. In the following column names, n varies from 1 to N.
| Column | Data Type | Description |
|---|---|---|
| accumulate_column | Any | Column copied from input table. |
| time_column_start | Numeric or time SQL data type | Point on time axis where window starts. |
| time_column_end | Numeric or time SQL data type | Point on time axis where window ends. |
| target_column_n_saxcode | CLOB | SAX code for nth window. |
| target_column_n_mean | DOUBLE PRECISION | [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Mean value used to calculate SAX value for nth window. |
| target_column_n_stdev | DOUBLE PRECISION | [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Standard deviation value used to calculate SAX value for nth window. |
Output Table Schema, OutputType ('bitmap')
The table has only one row. In the following column names, n varies from 1 to N.
| Column | Data Type | Description |
|---|---|---|
| accumulate_column | Any | Column copied from input table. |
| time_columnstart | Numeric or time SQL data type | Contains point on time axis where window starts. |
| time_column_end | Numeric or time SQL data type | Contains point on time axis where window ends. |
| target_column_n_bitmap | VARCHAR | Contains bitmap value for nth window, a JSON string containing key-value pairs of form "xx":d, where "xx" is a SAX code and d is a value between 0.00 and 1.00. |
Output Table Schema, OutputType ('characters')
The table has one row for each SAX symbol. You can input this output table to the function HMMUnsupervised.
| Column | Data Type | Description |
|---|---|---|
| accumulate_column | Any | Column copied from input table. |
| key | VARCHAR | Column by which input table is partitioned. |
| time_column_start | Numeric or time SQL data type | Contains point on time axis where window starts. |
| time_columnend | Numeric or time SQL data type | Contains point on time axis where window ends. |
| saxchar_n | CHARACTER(1) | Contains character value for nth window. |
| target_column_n_mean | DOUBLE PRECISION | [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Contains mean value used to calculate SAX value for nth window. |
| target_column_n_stdev | DOUBLE PRECISION | [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Contains standard deviation value used to calculate SAX value for nth window. |