I am not getting count as result. Where i keep on getting n number of results below.
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) On Thu, Feb 16, 2017 at 12:37 PM, Jan Kesten <j...@dafuer.de> wrote: > Hi, > > do you got a result finally? > > Those messages are simply warnings telling you that c* had to read many > tombstones while processing your query - rows that are deleted but not > garbage collected/compacted. This warning gives you some explanation why > things might be much slower than expected because per 100 rows that count > c* had to read about 15 times rows that were deleted already. > > Apart from that, count(*) is almost always slow - and there is a default > limit of 10.000 rows in a result. > > Do you really need the actual live count? To get a idea you can always > look at nodetool cfstats (but those numbers also contain deleted rows). > > > Am 16.02.2017 um 13:18 schrieb Selvam Raman: > > 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 "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
