I am using cassandra 3.9. Primary Key: id text;
On Thu, Feb 16, 2017 at 12:25 PM, Cogumelos Maravilha < cogumelosmaravi...@sapo.pt> wrote: > C* version please and partition key. > > On 02/16/2017 12:18 PM, Selvam Raman wrote: > > Hi, > > I want to know the total records count in table. > > I fired the below query: > select count(*) from tablename; > > and i have got the below output > > Read 100 live rows and 1423 tombstone cells for query SELECT * FROM > keysace.table WHERE token(id) > token(test:ODP0144-0883E-022R-002/047-052) > LIMIT 100 (see tombstone_warn_threshold) > > Read 100 live rows and 1435 tombstone cells for query SELECT * FROM > keysace.table WHERE token(id) > token(test:2565-AMK-2) LIMIT 100 (see > tombstone_warn_threshold) > > Read 96 live rows and 1385 tombstone cells for query SELECT * FROM > keysace.table WHERE token(id) > token(test:-2220-UV033/04) LIMIT 100 (see > tombstone_warn_threshold). > > > > > Can you please help me to get the total count of the table. > > -- > Selvam Raman > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து" > > > -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"