Unable to count records of a column family with 210 columns x 500K rows

[Arthur Zubarev <Ar...@Aol.com>]

Hello,

I am unable to count records using cqlsh (e.g.  select count(*) from MyCF limit 50000;) 
I have a column family with 210 columns x 500K rows. The row length is 40K chars.
The same issue is with any other large CF.

Re: Unable to count records of a column family with 210 columns x 500K rows

[Arthur Zubarev <Ar...@Aol.com>]

I sent this email a little early, the error I get is:

Request did not complete within rpc_timeout.

If I merely repeat the same query I get:

cqlsh:my_dw> select count(*) from MyCF limit 70000;
TSocket read 0 bytes
cqlsh:my_dw> select count(*) from MyCF limit 70000;
Traceback (most recent call last):
  File "/usr/bin/cqlsh", line 1001, in perform_statement_untraced
    self.cursor.execute(statement, decoder=decoder)
  File "/usr/share/cassandra/lib/cql-internal-only-1.4.0.zip/cql-1.4.0/cql/cursor.py", line 80, in execute
    response = self.get_response(prepared_q, cl)
  File "/usr/share/cassandra/lib/cql-internal-only-1.4.0.zip/cql-1.4.0/cql/thrifteries.py", line 77, in get_response
    return self.handle_cql_execution_errors(doquery, compressed_q, compress, cl)
  File "/usr/share/cassandra/lib/cql-internal-only-1.4.0.zip/cql-1.4.0/cql/thrifteries.py", line 96, in handle_cql_execution_errors
    return executor(*args, **kwargs)
  File "/usr/share/cassandra/lib/cql-internal-only-1.4.0.zip/cql-1.4.0/cql/cassandra/Cassandra.py", line 1782, in execute_cql3_query
    self.send_execute_cql3_query(query, compression, consistency)
  File "/usr/share/cassandra/lib/cql-internal-only-1.4.0.zip/cql-1.4.0/cql/cassandra/Cassandra.py", line 1793, in send_execute_cql3_query
    self._oprot.trans.flush()
  File "/usr/share/cassandra/lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TTransport.py", line 293, in flush
    self.__trans.write(buf)
  File "/usr/share/cassandra/lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TSocket.py", line 117, in write
    plus = self.handle.send(buff)
error: [Errno 32] Broken pipe

I then lose C* and need to restart its service to reconnect.

Does that mean I have an underpowered machine?

From: Arthur Zubarev 
Sent: Tuesday, June 11, 2013 10:02 AM
To: user@cassandra.apache.org 
Subject: Unable to count records of a column family with 210 columns x 500K rows

Hello,

I am unable to count records using cqlsh (e.g.  select count(*) from MyCF limit 50000;) 
I have a column family with 210 columns x 500K rows. The row length is 40K chars.
The same issue is with any other large CF.