With C* 3.10 cqlsh ip --request-timeout=600000 Connected to xxxxx at 10.10.10.10:9042. [cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4] Use HELP for help. cqlsh> USE yyyy ; cqlsh:yyyy> SELECT count(*) from table; count --------- 3572579
On 02/16/2017 12:27 PM, Selvam Raman wrote: > I am using cassandra 3.9. > > Primary Key: > id text; > > On Thu, Feb 16, 2017 at 12:25 PM, Cogumelos Maravilha > <cogumelosmaravi...@sapo.pt <mailto: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 > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
