Output Message Schema
| Column | Data Type | Description |
|---|---|---|
| message | VARCHAR | Reports number of patterns found. |
Output Table Schema
| Column | Data Type | Description |
|---|---|---|
| pattern | CLOB | Pattern (subsequence) in string format ('item [,...]'). |
| support | INTEGER | Pattern support value (number of input tables sequences that contain the pattern). |
| length | INTEGER | Pattern length. |
| group_column | VARCHAR | [Appears only with GroupByColumns argument.] Column copied from input table. |
Sequence Pattern Table Schema
The table appears only with the SeqPatternTable argument.
| Column | Data Type | Description |
|---|---|---|
| partition_column | Same as in input table | [Column appears once for each specified partition_column.] Column that is, or is part of, the partition key of the input table sequences. |
| pattern | VARCHAR | Pattern found in sequence specified by partition_column. |