cassandra-user mailing list archives

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

Mime
View raw message