Re: estimated row count for a pk range

2014-07-21 Thread tommaso barbugli
thank you for the reply; I was hoping for something with a bit less overhead than the first solution; the second is not really an option for me. On Monday, 21 July 2014, DuyHai Doan wrote: > 1) Use separate counter to count number of entries in each column family > but it will require you to man

Re: estimated row count for a pk range

2014-07-20 Thread DuyHai Doan
1) Use separate counter to count number of entries in each column family but it will require you to manage the counting manually 2) SELECT DISTINCT partitionKey FROM Normally this query is optimized and is much faster than a SELECT *. However if you have a very big number of distinct partitio

estimated row count for a pk range

2014-07-20 Thread tommaso barbugli
Hello, Lately I collapsed several (around 1k) column families in a bunch (100) of column families. To keep data separated I have added an extra column (family) which is part of the PK. While previous approach allowed me to always have a clear picture of every column family's size; now I have no ot