3.5.2 Limit values applicable to query definitions

The following table shows the limit values applicable to query definitions.

Table 3-10 Limit values applicable to query definitions

No.ItemValue range
1Number of CQL commands that can be specified in a single input file1 to 1,024
2Length of a CQL command1 to 300,000 characters
3Number of strings inside a stream1 to 3,000
4Length of each stream data item (size of a line)1 to 2,147,483,647 bytes
5Name size (stream name, relation name, query name, column name, and alias)1 to 100 characters
6Number of search items (number of select expressions in the SELECT clause)1 to 3,000
7Column specification list1 to 255
8Number of comparison predicates and parentheses inside a search condition1 to 255
9The total number of streams and relations that can be specified in a CQL query1 to 64
10Number of lines that can exist in the ROWS window1 to 100,000
11Time specificationSECOND1 to 2,678,400
12MILLISECOND1 to 86,400,000
13MINUTE1 to 44,640
14HOUR1 to 744
15DAY1 to 31