11

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

Rajesh Kumar
  • 1,270
  • 4
  • 15
  • 31

1 Answers1

9

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

jorgebg
  • 6,560
  • 1
  • 22
  • 31
Yasmeen
  • 801
  • 1
  • 7
  • 20
  • To build on what @Yasmeen said, the partition limitation is the smaller of 2 billion cells or the amount of data that can fit on a single node. For example, if you have only 1GB of space on node and each cell is 100MB, then the max size of the partition would be 10 cells. The reason is that a partition must fit on a single node (i.e. a partition cannot span nodes). – Akbar Ahmed Jan 15 '15 at 22:46
  • I believe we understand the billion as US billion 10^9 – maryoush Jan 31 '17 at 18:16
  • did not answer the length, but the size. there are different things. – Andy May 31 '18 at 15:39
  • Link is dead and there's no equivalent page in http://cassandra.apache.org/doc/latest/ – PickBoy Jul 15 '19 at 09:14
  • 1
    Possible new location: https://cwiki.apache.org/confluence/display/CASSANDRA2/CassandraLimitations – Eric Bolinger Oct 22 '19 at 21:33