CQL limits

Upper CQL limits.

Observe the following upper limits:

• Columns in a partition: 2B (2³¹); single column value size: 2 GB ( 1 MB is recommended)
• Clustering column value, length of: 65535 (2¹⁶-1)
• Key length: 65535 (2¹⁶-1)
• Table / CF name length: 48 characters
• Keyspace name length: 48 characters
• Query parameters in a query: 65535 (2¹⁶-1)
• Statements in a batch: 65535 (2¹⁶-1)
• Fields in a tuple: 32768 (2¹⁵) (just a few fields, such as 2-10, are recommended)
• Collection (List): collection size: 2B (2³¹); values size: 65535 (2¹⁶-1) (Apache Cassandra™ 2.1 and later, using native protocol v3)
• Collection (Set): collection size: 2B (2³¹); values size: 65535 (2¹⁶-1) (Apache Cassandra 2.1 and later, using native protocol v3)
• Collection (Map): collection size: 2B (2³¹); number of keys: 65535 (2¹⁶-1); values size: 65535 (2¹⁶-1) (Apache Cassandra 2.1 and later, using native protocol v3)
• Blob size: 2 GB ( less than 1 MB is recommended)