[ 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)