My question is specifically for row cache? As in cassandra 2.1.2 when I populate a Column Family with 1000 rows for a partition and rows_per_partition setting is 1000 for the Column Family then for first and last row, it says cache miss.. if I mention specific row key in query? If I increase rows_per_partition to 1002 then it is HIT for all. On Jan 19, 2015 2:17 PM, "nitin padalia" <padalia.ni...@gmail.com> wrote:
> Hi, > > Does Cassandra fetches complete partition if I include Cluster key in > where clause. > > Or What is the difference in: > 1. Select * from column_family where partition_key = 'somekey' limit 1; > 2. Select * from column_family where partition_key = 'somekey' and > clustering_key = 'some_clustring_key'; > > > > Thanks! in advance. > Nitin Padalia >