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)
WITH COMPACT STORAGE
and compaction = {'class' : 'LeveledCompactionStrategy' }
From: Davide Anastasia <davide.anasta...@gmail.com
<mailto:davide.anasta...@gmail.com>>
Reply-To: "user@cassandra.apache.org
<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org
<mailto:user@cassandra.apache.org>>
Date: Friday, June 7, 2013 2:11 AM
To: "user@cassandra.apache.org <mailto:user@cassandra.apache.org>"
<user@cassandra.apache.org <mailto:user@cassandra.apache.org>>
Subject: Re: Bulk loader with Cassandra 1.2.5
AbstractCompositeType.java
--
Regards,
Arthur
