Re: Cassandra fetches complete partition

2015-01-19 Thread Eric Stevens
Read 1 live and 0 tombstoned cells | > 19:28:35,425 | 10.76.214.80 | 2574 > > > Request complete | > 19:28:35,425 | 10.76.214.80 | 2943 > > > > > > > > &g

Re: Cassandra fetches complete partition

2015-01-19 Thread nitin padalia
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" wrote: &g

Re: Cassandra fetches complete partition

2015-01-19 Thread nitin padalia
rows_per_partition to 1002 then it is HIT for all. On Jan 19, 2015 2:17 PM, "nitin padalia" 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 pa

Cassandra fetches complete partition

2015-01-19 Thread nitin padalia
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 =