From user-return-10367-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Mon Nov 08 19:40:11 2010 Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 23024 invoked from network); 8 Nov 2010 19:40:11 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 8 Nov 2010 19:40:11 -0000 Received: (qmail 44543 invoked by uid 500); 8 Nov 2010 19:40:40 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 44524 invoked by uid 500); 8 Nov 2010 19:40:40 -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 44516 invoked by uid 99); 8 Nov 2010 19:40:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Nov 2010 19:40:40 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,MIME_QP_LONG_LINE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a57.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Nov 2010 19:40:32 +0000 Received: from homiemail-a57.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a57.g.dreamhost.com (Postfix) with ESMTP id 2808E208081 for ; Mon, 8 Nov 2010 11:40:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=to:from :subject:date:message-id:content-type:mime-version:in-reply-to; q=dns; s=thelastpickle.com; b=1lIFUU7jS/o1eCeBbpeEW8VXfnnZXZDQQ 1xm4Owkg3U31kKWuWCnanbEwf1NCH3pritaE8c10E9hPpA+49XKamo2SUVIRwwku M4X/EAqSWiOqTJZp24AUhjHy3Qy7QlhIphq0lpOJsF3Bd3KXScUGLOZMBz+gUu7C 9MZLy+a9z4= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=to :from:subject:date:message-id:content-type:mime-version: in-reply-to; s=thelastpickle.com; bh=/fmewhwzYSakK6bnX8kYvEFAHMk =; b=F+DLmYAKzbSLATjfG0y3NkixjG48YIvb+YwcVOXYIx+Az5YP1zyjJm4L/c2 d2LZJLwCNK7N6+LLHWyNdfHB41mw0mQnAKNUcoWCYcT+Gfx/4MRDjge5Y4kmgYgG aoOdqZunBet8NN3G7AlhvirfXjQabyz+4FQKvj4FjGoYD2IU= Received: from localhost (webms.mac.com [17.148.16.116]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a57.g.dreamhost.com (Postfix) with ESMTPSA id A9CB020807E for ; Mon, 8 Nov 2010 11:40:05 -0800 (PST) To: user@cassandra.apache.org From: Aaron Morton Subject: Re: Describe keyspace output Date: Mon, 08 Nov 2010 19:40:04 GMT X-Mailer: MobileMe Mail (1C3207) Message-id: Content-Type: multipart/alternative; boundary=Apple-Webmail-42--85a5cfd1-7348-e815-dff1-f92965600266 MIME-Version: 1.0 In-Reply-To: <4CD84DD6.2010706@netflix.com> X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Webmail-42--85a5cfd1-7348-e815-dff1-f92965600266 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=ISO-8859-1; format=flowed Dmitri,=0ANot exactly sure which two lines you are referring to to but...=0A= =0A"Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType" - mean= s the column name on the second level of columns in your Super Column Fami= ly will be sorted as Long integers.=A0=0A=0Aand "A long is exactly 8 bytes= :" Looks like an error thrown when the LongType is trying to convert a val= ue toString(), in this case the value is only 4 bytes long.=A0=0A=0A=0AWer= e there any error log messages in the server when you ran this?=0A=0AAaron= =0A=0AOn 09 Nov, 2010,at 08:21 AM, Dmitri Smirnov w= rote:=0A=0AI have created a CF with the following:=0A=0Acreate column fami= ly CFam with column_type =3D 'Super' and comparator =3D =0A'LongType' and = subcomparator =3D 'UTF8Type' and comment =3D 'List of Tests =0ASuper Famil= y' and column_metadata=3D[{ column_name:cell, =0Avalidation_class:IntegerT= ype}, { column_name:'created_by', =0Avalidation_class:UTF8Type },{ column_= name:'creation_ts', =0Avalidation_class : LongType }, { column_name:'enabl= ed', validation_class =0A: UTF8Type }, { column_name :'subcategory_id', va= lidation_class : =0ALongType }, { column_name : 'update_ts', validation_cl= ass : LongType }]=0A=0AWhat is the meaning of 2 lines below:=0A=0A- Subcol= umns sorted by: org.apache.cassandra.db.marshal.LongType=0A=0A- A long is = exactly 8 bytes: 4=0A> describe keyspace Kspace=0AKeyspace: Kspace:=0ARepl= ication Factor: 4=0AColumn Families:=0AColumnFamily: CFam (Super)=0A"List = of Tests Super Family"=0AColumns sorted by: =0Aorg.apache.cassandra.db.mar= shal.LongType/org.apache.cassandra.db.marshal.UTF8Type=0ASubcolumns sorted= by: org.apache.cassandra.db.marshal.LongType=0ARow cache size / save peri= od: 0.0/0=0AKey cache size / save period: 200000.0/3600=0AMemtable thresho= lds: 1.1203125/239/60=0AGC grace seconds: 864000=0ACompaction min/max thre= sholds: 4/32=0AColumn Metadata:=0AA long is exactly 8 bytes: 4=0A=0A-- =0A= Dmitri Smirnov=0AY!IM: ia_slepukhin=0A=0A --Apple-Webmail-42--85a5cfd1-7348-e815-dff1-f92965600266 Content-Type: multipart/related; type="text/html"; boundary=Apple-Webmail-86--85a5cfd1-7348-e815-dff1-f92965600266 --Apple-Webmail-86--85a5cfd1-7348-e815-dff1-f92965600266 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1;
Dmitri,
Not exactly sure which two lines you are referring = to to but...

"Subcolumns so= rted by: org.apache.cassandra.db.marshal.LongType" - means the column name= on the second level of columns in your Super Column Family will be sorted= as Long integers. 

and "A long is exactly 8 bytes:" Looks l= ike an error thrown when the LongType is trying to convert a value toStrin= g(), in this case the value is only 4 bytes long. 
<= font class=3D"Apple-style-span" face=3D"Helvetica, Arial, Verdana, sans-se= rif">

Were there an= y error log messages in the server when you ran this?

Aaron

On = 09 Nov, 2010,at 08:21 AM, Dmitri Smirnov <dsmirnov@netflix.com> wrot= e:

I have created a CF with the following:
=0A
=0Acreate column famil= y CFam with column_type =3D 'Super' and comparator =3D
=0A'LongType' a= nd subcomparator =3D 'UTF8Type' and comment =3D 'List of Tests
=0ASupe= r Family' and column_metadata=3D[{ column_name:cell,
=0Avalidation_cla= ss:IntegerType}, { column_name:'created_by',
=0Avalidation_class:UTF8T= ype },{ column_name:'creation_ts',
=0Avalidation_class : LongType }, {= column_name:'enabled', validation_class
=0A: UTF8Type }, { column_nam= e :'subcategory_id', validation_class :
=0ALongType }, { column_name := 'update_ts', validation_class : LongType }]
=0A
=0A What is the me= aning of 2 lines below:
=0A
=0A- Subcolumns sorted by: org.apache.c= assandra.db.marshal.LongType
=0A
=0A- A long is exactly 8 bytes: 4=0A > describe keyspace Kspace
=0AKeyspace: Kspace:
=0A Repli= cation Factor: 4
=0A Column Families:
=0A ColumnFamily: CFam (= Super)
=0A "List of Tests Super Family"
=0A Columns sorted= by:
=0Aorg.apache.cassandra.db.marshal.LongType/org.apache.cassandra.= db.marshal.UTF8Type
=0A Subcolumns sorted by: org.apache.cassandr= a.db.marshal.LongType
=0A Row cache size / save period: 0.0/0
= =0A Key cache size / save period: 200000.0/3600
=0A Memtabl= e thresholds: 1.1203125/239/60
=0A GC grace seconds: 864000
=0A= Compaction min/max thresholds: 4/32
=0A Column Metadata:=0AA long is exactly 8 bytes: 4
=0A
=0A--
=0ADmitri Smirnov=0AY!IM: ia_slepukhin
=0A
=0A
--Apple-Webmail-86--85a5cfd1-7348-e815-dff1-f92965600266-- --Apple-Webmail-42--85a5cfd1-7348-e815-dff1-f92965600266--