Limitations

The upper limits are as follows:

  • Cells in a partition: ~2 billion (2^31); single column value size: 2 GB (1 MB is recommended)

  • Clustering column value length of: 65535 (2^16 - 1)

  • Key length: 65535 (2^16 - 1)

  • Table / column family name length: 222 characters

  • Keyspace name length: 222 characters

  • Query parameters in a query: 65535 (2^16 - 1)

  • Statements in a batch: 65535 (2^16 - 1)

  • Fields in a tuple: 32768 (2^15) (just a few fields, such as 2 to 10, are recommended)

  • Collection (list): collection limit is ~2 billion (2^31); values size is 65535 (2^16 - 1)

  • Collection (set): collection limit is ~2 billion (2^31); values size is 65535 (2^16 - 1)

  • Collection (map): collection limit for number of keys is 65535 (2^16 - 1); values size is 65535 (2^16 - 1)

  • Blob size: 2 GB (less than 1 MB is recommended)

  • Vector: maximum dimension is 8K (2^13)

The limits specified for collections are for non-frozen collections.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com