I am interested to know if the compaction directive is the key because I have the same symptoms on Ubuntu Server 12.04 64 bit C* 1.2.4 with a CF of ~ > half mil records 6,000 chars each.

I can only get back max 6,000 records read in cqlsh, so, if I query SELECT COUNT(*) FROM A_CF LIMIT 6000; It works, but ... LIMIT 7000 results in the "rpc timeout" (I have the read time-out elevated to a value three times greater than the default in cassandra.yaml).

On 06/07/2013 05:56 AM, Keith Wright wrote:
Looking into it further, I believe your issue is that you did not define the table with compact storage.  Without that, CQL3 will treat every column as a composite (as is hinted in your stack trace where you see AbstractCompositeType is the cause of the error).  Try changing your table definition as follows:

create table users (
id uuid primary key,
firstname varchar,
lastname varchar,
password varchar,
age int,
email varchar)
and compaction = {'class' : 'LeveledCompactionStrategy' }

From: Davide Anastasia <davide.anastasia@gmail.com>
Reply-To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Date: Friday, June 7, 2013 2:11 AM
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: Re: Bulk loader with Cassandra 1.2.5