cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tyler Hobbs (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8899) cqlsh - not able to get row count with select(*) for large table
Date Tue, 03 Mar 2015 19:42:05 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-8899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345599#comment-14345599
] 

Tyler Hobbs commented on CASSANDRA-8899:
----------------------------------------

This was resolved for 3.0 by CASSANDRA-4914.  I don't believe it would be too difficult to
make 2.0 and 2.1 not use the limit for the max {{count()}} result (without backporting the
rest of the aggregate function changes).

[~blerer] do you want to take a look and see how realistic that is?

> cqlsh - not able to get row count with select(*) for large table
> ----------------------------------------------------------------
>
>                 Key: CASSANDRA-8899
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8899
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Cassandra 2.1.2 ubuntu12.04
>            Reporter: Jeff Liu
>
>  I'm getting errors when running a query that looks at a large number of rows.
> {noformat}
> cqlsh:events> select count(*) from catalog;
>  count
> -------
>  10000
> (1 rows)
> cqlsh:events> select count(*) from catalog limit 11000;
>  count
> -------
>  11000
> (1 rows)
> cqlsh:events> select count(*) from catalog limit 50000;
> errors={}, last_host=127.0.0.1
> cqlsh:events> 
> {noformat}
> We are not able to make the select * query to get row count.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message