[
https://issues.apache.org/jira/browse/CASSANDRA-8899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14379410#comment-14379410
]
Tommy Stendahl commented on CASSANDRA-8899:
-------------------------------------------
I think I run in to this problem and I think I found the cause.
Using 2.1.2 I did {{select count\(*)}} on a large table in cqlsh and got the
error {{errors={}, last_host=127.0.0.1}}. I then tried the same thing using
2.1.3 and got the error {{OperationTimedOut: errors={}, last_host=127.0.0.1}}.
Then I realized that what happens is that there is a timeout in cqlsh because
the query takes very long time. This timeout is configurable, see
[-CASSANDRA-7516-|https://issues.apache.org/jira/browse/CASSANDRA-7516] for
details. The default timeout is 10s, I had to increase it to 30s.
> 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
> Assignee: Benjamin Lerer
>
> 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)
