CQL limits

Upper CQL limits.

Observe the following upper limits:

• Cells in a partition: ~2 billion (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 limit: ~2 billion (2³¹); values size: 65535 (2¹⁶-1) (Cassandra 2.1 and later, using native protocol v3)
• Collection (Set): collection limit: ~2 billion (2³¹); values size: 65535 (2¹⁶-1) (Cassandra 2.1 and later, using native protocol v3)
• Collection (Map): collection limit: ~2 billion (2³¹); number of keys: 65535 (2¹⁶-1); values size: 65535 (2¹⁶-1) (Cassandra 2.1 and later, using native protocol v3)
• Blob size: 2 GB ( less than 1 MB is recommended)