incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Re: How to find total number of rows in Cassandra databaase?
Date Sun, 21 Apr 2013 20:39:42 GMT
Yeah it helps a lot. I always have this doubt with me. What is the
difference between CLI and CQL?



On Sun, Apr 21, 2013 at 1:30 PM, Utkarsh Sengar <utkarsh2012@gmail.com>wrote:

> Using cqlsh you can do:
>
> SELECT COUNT(*) FROM columnfamily LIMIT 5000;
>
> Does that help?
>
> Read more: http://www.datastax.com/docs/1.0/references/cql/SELECT
>
> Thanks,
> -Utkarsh
>
>
>
> On Sun, Apr 21, 2013 at 1:04 PM, Techy Teck <comptechgeeky@gmail.com>wrote:
>
>> I have inserted 1000 rows in Cassandra database. Now I am trying to find
>> out how many rows have been inserted in Cassandra database using the CLI
>> mode.
>>
>>
>> In rdbms, I can do this sql-
>>
>> *       SELECT count(*) from TABLE;*
>>
>> And this will give me total count for that table;
>>
>> How to do the same thing in Cassandra database?
>>
>> I am running Cassandra 1.2.3
>>
>
>
>
> --
> Thanks,
> -Utkarsh
>

Mime
View raw message