cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Selvam Raman <sel...@gmail.com>
Subject Count(*) is not working
Date Thu, 16 Feb 2017 12:18:00 GMT
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
"லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Mime
View raw message