+1 for using spark for counts. On Feb 17, 2017 4:25 PM, "kurt greaves" <k...@instaclustr.com> wrote:
> if you want a reliable count, you should use spark. performing a count (*) > will inevitably fail unless you make your server read timeouts and > tombstone fail thresholds ridiculous > > On 17 Feb. 2017 04:34, "Jan" <j...@dafuer.de> wrote: > >> Hi, >> >> could you post the output of nodetool cfstats for the table? >> >> Cheers, >> >> Jan >> >> Am 16.02.2017 um 17:00 schrieb Selvam Raman: >> >> 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 >> "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து" >> >> >>
