Limit values applicable to query definitions

uCosminexus Stream Data Platform - Application Framework Application Development Guide

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