The following table shows the limit values applicable to query definitions.
Table 3-10 Limit values applicable to query definitions
No. | Item | Value range | |
---|---|---|---|
1 | Number of CQL commands that can be specified in a single input file | 1 to 1,024 | |
2 | Length of a CQL command | 1 to 300,000 characters | |
3 | Number of strings inside a stream | 1 to 3,000 | |
4 | Length of each stream data item (size of a line) | 1 to 2,147,483,647 bytes | |
5 | Name size (stream name, relation name, query name, column name, and alias) | 1 to 100 characters | |
6 | Number of search items (number of select expressions in the SELECT clause) | 1 to 3,000 | |
7 | Column specification list | 1 to 255 | |
8 | Number of comparison predicates and parentheses inside a search condition | 1 to 255 | |
9 | The total number of streams and relations that can be specified in a CQL query | 1 to 64 | |
10 | Number of lines that can exist in the ROWS window | 1 to 100,000 | |
11 | Time specification | SECOND | 1 to 2,678,400 |
12 | MILLISECOND | 1 to 86,400,000 | |
13 | MINUTE | 1 to 44,640 | |
14 | HOUR | 1 to 744 | |
15 | DAY | 1 to 31 |