incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Utkarsh Sengar <utkarsh2...@gmail.com>
Subject Re: How to find total number of rows in Cassandra databaase?
Date Sun, 21 Apr 2013 23:19:00 GMT
Difference b/w cqlsh and cli is documented by the datastax guys here
nicely: http://www.datastax.com/support-forums/topic/cli-vs-cql

Thanks,
-Utkarsh


On Sun, Apr 21, 2013 at 1:39 PM, Techy Teck <comptechgeeky@gmail.com> wrote:

> 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
>>
>
>


-- 
Thanks,
-Utkarsh

Mime
View raw message