Hello all, I am doing some data modeling and want to make sure that I understand some nuances to cell counts, partition sizes, and related recommendations. Am I correct in my understanding that tables for which every column is in the primary key will always have 0 cells?
For example, using https://cql-calculator.herokuapp.com/, I tested the following table definition with 1000000 (1 million) rows per partition and an average value size of 255 bytes, and it returned that there were 0 cells and the partition took up 32 bytes total: CREATE TABLE IF NOT EXISTS widgets ( id timeuuid, key_id timeuuid, parent_id timeuuid, value text, PRIMARY KEY ((parent_id, key_id), value, id) ) Obviously the total amount of disk space for this table must be more than 32 bytes. In this situation, how should I be reasoning about partition sizes (in terms of the 2B cell limit, and 100MB-400MB partition size limit)? Additionally, are there other limits / potential performance issues I should be concerned about? Ben Christenson Developer Kinetic Data, Inc. Your business. Your process. 651-556-0937 | ben.christen...@kineticdata.com www.kineticdata.com | community.kineticdata.com
