From user-return-34523-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Sun Jun 9 01:59:30 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A13ABCC0D for ; Sun, 9 Jun 2013 01:59:30 +0000 (UTC) Received: (qmail 25895 invoked by uid 500); 9 Jun 2013 01:59:28 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 25876 invoked by uid 500); 9 Jun 2013 01:59:28 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 25868 invoked by uid 99); 9 Jun 2013 01:59:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Jun 2013 01:59:28 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of arthur.zubarev@aol.com designates 205.188.109.204 as permitted sender) Received: from [205.188.109.204] (HELO omr-d07.mx.aol.com) (205.188.109.204) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Jun 2013 01:59:22 +0000 Received: from mtaout-ma02.r1000.mx.aol.com (mtaout-ma02.r1000.mx.aol.com [172.29.41.2]) by omr-d07.mx.aol.com (Outbound Mail Relay) with ESMTP id 5EB94700000BB for ; Sat, 8 Jun 2013 21:59:01 -0400 (EDT) Received: from [192.168.0.90] (CPE185933f3db5c-CM185933f3db59.cpe.net.cable.rogers.com [99.238.22.30]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mtaout-ma02.r1000.mx.aol.com (MUA/Third Party Client Interface) with ESMTPSA id 05471E0002F9 for ; Sat, 8 Jun 2013 21:59:00 -0400 (EDT) Message-ID: <51B3E163.4060702@aol.com> Date: Sat, 08 Jun 2013 21:58:59 -0400 From: Arthur Zubarev Reply-To: arthur.zubarev@aol.com User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130510 Thunderbird/17.0.6 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: Bulk loader with Cassandra 1.2.5 References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------040700010305020000070306" x-aol-global-disposition: G DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com; s=20121107; t=1370743141; bh=iUG7gNzD5FT7btmmPdV08IPznP7gGJfouTl8R23AqBo=; h=From:To:Subject:Message-ID:Date:MIME-Version:Content-Type; b=kbXhWJYmD3yx4FHFvk2OdKM0RU51iLA/8kVFBwbhUUbtgwgYdZqq1NYTiPoxPyVqM mmfeEIKgG/rZpHjOhHenRONXAR0vZN7K5knP3tVMm0wfZBCn9dYYc1CXgKmmXJqPoI KYoVARgPD/ZfkqDl2xLSEJXB3QmW8gnw7tO/Srog= X-AOL-SCOLL-SCORE: 0:2:442942784:93952408 X-AOL-SCOLL-URL_COUNT: 0 x-aol-sid: 3039ac1d290251b3e1643f2f X-AOL-IP: 99.238.22.30 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------040700010305020000070306 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 > > Reply-To: "user@cassandra.apache.org > " > > Date: Friday, June 7, 2013 2:11 AM > To: "user@cassandra.apache.org " > > > Subject: Re: Bulk loader with Cassandra 1.2.5 > > AbstractCompositeType.java -- Regards, Arthur --------------040700010305020000070306 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
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.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

AbstractCompositeType.java


-- 

Regards,

Arthur
--------------040700010305020000070306--