Menu
Is there any limit on maximum length we can specify for a column while creating Cassandra table, if yes, then how much we can specify?
I am new to using Cassandra, please let me know
254
Maximum recommended capacity for Cassandra 1.2 and later is 3 to 5TB per node for uncompressed data. For Cassandra 1.1, it is 500 to 800GB per node. Be sure to account for replication.
If you need to know informaiton about table or tables you can use Nodetool cfstats command. Syntax: If you will only provide the name of keyspace, it will provide stats for all the tables in that keyspace.
To calculate the size of a row, we need to sum the size of all columns within the row and add that sum to the partition key size. Assuming the size of the partition key is consistent throughout a table, calculating the size of a table is almost identical to calculating the size of a partition.
Partition size is measured by the number of cells (values) that are stored in the partition. Cassandra's hard limit is 2 billion cells per partition, but you'll likely run into performance issues before reaching that limit.
The maximum number of cells (rows x columns) in a single partition is 2 billion and the maximum column key (and row key) size is 64KB and the maximum column value size is 2 GB. you can refer this https://cwiki.apache.org/confluence/display/CASSANDRA2/CassandraLimitations
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
