The output table format depends on the OutputType syntax element. For OutputType ('string') or OutputType ('bytes'), the format also depends on the WindowType syntax element.
Output Table Schema, OutputType ('string') or OutputType ('bytes')
For WindowType ('global'), the table has one row for each partition. For WindowType ('sliding'), the table has multiple rows for each partition.
| Column | Data Type | Description |
|---|---|---|
| accumulate_column | Any | Column copied from InputTable. |
| 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_saxcode | CLOB | SAX code for target_column for window. |
| target_column_mean | DOUBLE PRECISION | [Column appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Mean value used to calculate SAX value for window. |
| target_column_stdev | DOUBLE PRECISION | [Column appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Standard deviation value used to calculate SAX value for window. |
Output Table Schema, OutputType ('bitmap')
The table has one row for each partition.
| Column | Data Type | Description |
|---|---|---|
| accumulate_column | Any | Column copied from InputTable. |
| 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_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 (ML Engine).
| Column | Data Type | Description |
|---|---|---|
| accumulate_column | Any | Column copied from InputTable. |
| value_column | VARCHAR | Column name from InputTable. |
| 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. |
| saxchar | CHARACTER(1) | Character value for window. |