Re: Question on large partition key

2019-12-31 Thread Jon Haddad
I suggest checking out Aaron Morton's post on the 3.0 storage engine. https://thelastpickle.com/blog/2016/03/04/introductiont-to-the-apache-cassandra-3-storage-engine.html On Tue, Dec 31, 2019 at 11:20 AM Subroto Barua wrote: > I have a table --- > > create Table mytable ( > > Id text, > > cdat

Question on large partition key

2019-12-31 Thread Subroto Barua
I have a table --- create Table mytable ( Id text, cdate timestamp, Tk text, Primary key (id, cdate) ) with clustering order by (cdate desc); One of the partition key has 2,099,414 rows; using the following formula: row_size = sum_of_all_columns_ size_within_row + partition_key_size row_size