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
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 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 projec
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().
ho
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 wrote:
> Yeah it helps a lot. I always have this doubt with me. What is the
> difference between CLI
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 wrote:
> Using cqlsh you can do:
>
> SELECT COUNT(*) FROM columnfamily LIMIT 5000;
>
> Does that help?
>
> Read more: http://www.datastax.com/docs/1
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 wrote:
> I have inserted 1000 rows in Cassandra database. Now I am trying to
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 i