cassandra-cli has some good online help.

There are no features to count rows as cassandra does not count them, but it 
it's only 1,000 try using list;

You can also see the number of rows by using nodetool cfstats. 

Cheers

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 23/04/2013, at 6:50 PM, Techy Teck <comptechge...@gmail.com> wrote:

> Is there any way to see how many rows are there using CLI mode? If I don't 
> want to use CQL mode.
> 
> 
> On Mon, Apr 22, 2013 at 12:13 AM, Nikolay Mihaylov <n...@nmmm.nu> wrote:
> Hi
> 
> it is very important to know that counting rows is very very very expensive.
> here is my 5 cents - 
> 
> in one of my early projects we made separate column family, with just single 
> row.
> we inserted each row key from other CF on this row as column key.
> 
> then once a day or who, we did get_count().
> 
> however because get_count() became way too slow,
> we have split the keys on several rows - e.g. on 1024 rows.
> it is still way too slow, but we do not need it to be realtime.
> 
> in our "second" project we decided to use cassandra counters.
> however in order to be distinct, we need to read before write.
> this degrade insert performance, so we did special CF with hashesh and other 
> stuff.
> insert performance is still slow. 2 sec or something for 500-600 counters
> (note single insert is OK, but we need to do 500-600 per batch, and 100-200 
> batches per second).
> 
> finally we have researched about probabilistic counters and we decided to use 
> these.
> we also decided to make the project in Python, and we did not do proper tests 
> yes.
> 
> this is our final "take", it uses modified hyper log log, so we do not need 
> to read at all.
> 
> https://github.com/nmmmnu/CubicHyperLogLog
> 
> we tested the library very well, but not with real live data.
> version for Redis is included too for easy testing.
> 
> Nikolay.
> 
> 
> 
> 
> 
> On Mon, Apr 22, 2013 at 2:19 AM, Utkarsh Sengar <utkarsh2...@gmail.com> wrote:
> 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 <comptechge...@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 <utkarsh2...@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 <comptechge...@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
> 
> 

Reply via email to