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
