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 >