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. |