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 5149FD780 for ; Mon, 3 Sep 2012 06:40:49 +0000 (UTC) Received: (qmail 98329 invoked by uid 500); 3 Sep 2012 06:40:46 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 97709 invoked by uid 500); 3 Sep 2012 06:40:41 -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 97655 invoked by uid 99); 3 Sep 2012 06:40:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Sep 2012 06:40:39 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of database.craftsman@gmail.com designates 209.85.212.44 as permitted sender) Received: from [209.85.212.44] (HELO mail-vb0-f44.google.com) (209.85.212.44) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Sep 2012 06:40:32 +0000 Received: by vbbez10 with SMTP id ez10so5811421vbb.31 for ; Sun, 02 Sep 2012 23:40:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=QhyXy76d0/fqwFvV6nTAsY/gDxHVIdX0FqhYV3ql31g=; b=mSGgEPEH+pfsxZZ579hauQjNjWeCGmt+TXa6QPYsW3bhDISjoRtiaqgWACJOc+80DG +EMJtbBJIDaXUgXUeLMHku4/UZKMGe3Q21BoNWhqb3KSppgOEqI6CEdL+ldcCboM1dUI qDHnmKwwilv0f+qb44vpVeMT/MuixWqcFfxeesOEzBwjEESNdJ/jD2PhN0beihjImkwV kZxCTU7kURjGm25WCDOxO+yujf6xXy7cddfh0M0fOC35c504R+NGws38NIxz+LAnK6Jj /HMnJQj+1kQm3AE1sJp9HyjaC4Rmdyy83oqGuWzXUkCRlJULU3pt4eox6l6jahr0hyal AeFw== MIME-Version: 1.0 Received: by 10.220.153.7 with SMTP id i7mr11330313vcw.34.1346654411705; Sun, 02 Sep 2012 23:40:11 -0700 (PDT) Received: by 10.58.102.51 with HTTP; Sun, 2 Sep 2012 23:40:11 -0700 (PDT) In-Reply-To: References: <876597B4-2DD4-46B5-9CB5-18E2E1FB4A48@thelastpickle.com> Date: Sun, 2 Sep 2012 23:40:11 -0700 Message-ID: Subject: Re: How to set LeveledCompactionStrategy for an existing table From: =?UTF-8?B?RGF0YSBDcmFmdHNtYW4g5pyo5Yyg?= To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=f46d043c7c7cd84b9b04c8c669d0 --f46d043c7c7cd84b9b04c8c669d0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable We have same problem. On Friday, August 31, 2012, Jean-Armel Luce wrote: > Hello Aaron. > > Thanks for your answer > > Jira ticket 4597 created : https://issues.apache.org/jira/browse/CASSANDRA-4597 > > Jean-Armel > > 2012/8/31 aaron morton > > Looks like a bug. > Can you please create a ticket on https://issues.apache.org/jira/browse/CASSANDRA and update the email thread ? > Can you include this: CFPropDefs.applyToCFMetadata() does not set the compaction class on CFM > Thanks > > ----------------- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > On 31/08/2012, at 7:05 AM, Jean-Armel Luce wrote: > > I tried as you said with cassandra-cli, and still unsuccessfully > > [default@unknown] use test1; > Authenticated to keyspace: test1 > [default@test1] UPDATE COLUMN FAMILY pns_credentials with compaction_strategy=3D'LeveledCompactionStrategy'; > 8ed12919-ef2b-327f-8f57-4c2de26c9d51 > Waiting for schema agreement... > ... schemas agree across the cluster > > And then, when I check the compaction strategy, it is still SizeTieredCompactionStrategy > [default@test1] describe pns_credentials; > ColumnFamily: pns_credentials > Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type > Default column value validator: org.apache.cassandra.db.marshal.UTF8Type > Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type > GC grace seconds: 864000 > Compaction min/max thresholds: 4/32 > Read repair chance: 0.1 > DC Local Read repair chance: 0.0 > Replicate on write: true > Caching: KEYS_ONLY > Bloom Filter FP chance: default > Built indexes: [] > Column Metadata: > Column Name: isnew > Validation Class: org.apache.cassandra.db.marshal.Int32Type > Column Name: ts > Validation Class: org.apache.cassandra.db.marshal.DateType > Column Name: mergestatus > Validation Class: org.apache.cassandra.db.marshal.Int32Type > Column Name: infranetaccount > Validation Class: org.apache.cassandra.db.marshal.UTF8Type > Column Name: user_level > Validation Class: org.apache.cassandra.db.marshal.Int32Type > Column Name: msisdn > Validation Class: org.apache.cassandra.db.marshal.LongType > Column Name: mergeusertype > Validation Class: org.apache.cassandra.db.marshal.Int32Type > Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy > Compression Options: > sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor > > > > I tried also to create a new table with LeveledCompactionStrategy (using cqlsh), and when I check the compaction strategy, the SizeTieredCompactionStrategy is set for this table. > > cqlsh:test1> CREATE TABLE pns_credentials3 ( > ... ise text PRIMARY KEY, > ... isnew int, > ... ts timestamp, > ... mergestatus int, > ... infranetaccount text, > ... user_level int, > ... msisdn bigint, > ... mergeusertype int > ... ) WITH > ... comment=3D'' AND > --=20 Thanks, Charlie (@mujiang) =E6=9C=A8=E5=8C=A0 =3D=3D=3D=3D=3D=3D=3D Data Architect Developer http://mujiang.blogspot.com --f46d043c7c7cd84b9b04c8c669d0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable We have same problem.

On Friday, August 31, 2012, Jean-Armel Luce &= lt;jaluce06@gmail.com> wrote:<= br>> Hello Aaron.
>
> Thanks for your answer
>
>= Jira ticket 4597 created : https://issues.apache.org/jira/browse/CASSANDRA-4597<= br> >
> Jean-Armel
>
> 2012/8/31 aaron morton <aaron@thelastpickle.com>
>=
> Looks like a bug.=C2=A0
> Can you please create a ticket on= =C2=A0https://i= ssues.apache.org/jira/browse/CASSANDRA and update the email thread ? > Can you include this: CFPropDefs.applyToCFMetadata() does not set the = compaction class on CFM
> Thanks
>
> -----------------> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com<= /a>
> On 31/08/2012, at 7:05 AM, Jean-Armel Luce <jaluce06@gmail.com> wrote:
>
> I t= ried as you said with cassandra-cli, and still unsuccessfully
>
> [default@unknown] use test1;
> Authenticated to keyspace= : test1
> [default@test1] UPDATE COLUMN FAMILY pns_credentials with c= ompaction_strategy=3D'LeveledCompactionStrategy';
> 8ed12919-= ef2b-327f-8f57-4c2de26c9d51
> Waiting for schema agreement...
> ... schemas agree across the c= luster
>
> And then, when I check the compaction strategy, it i= s still=C2=A0 SizeTieredCompactionStrategy
> [default@test1] describe= pns_credentials;
> =C2=A0=C2=A0=C2=A0 ColumnFamily: pns_credentials
> =C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 Key Validation Class: org.apache.cassandra.db.marshal.UT= F8Type
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Default column value validato= r: org.apache.cassandra.db.marshal.UTF8Type
> =C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 GC grace seconds: 864000
> =C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 Compaction min/max thresholds: 4/32
> =C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 Read repair chance: 0.1
> =C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 DC Local Read repair chance: 0.0
> =C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 Replicate on write: true
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 C= aching: KEYS_ONLY
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Bloom Filter FP chance: default
>= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Built indexes: []
> =C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 Column Metadata:
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 Column Name: isnew
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 Validation Class: org.apache.cassandra.db.marshal.Int32T= ype
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Column Name: ts
> =C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Validation Class: org.a= pache.cassandra.db.marshal.DateType
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 Column Name: mergestatus
> =C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 Validation Class: org.apache.cassandra.db.marsh= al.Int32Type
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Column Name: infranetaccoun= t
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Validation= Class: org.apache.cassandra.db.marshal.UTF8Type
> =C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 Column Name: user_level
> =C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Validation Class: org.apache.cassandra= .db.marshal.Int32Type
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Column Name: msisdn
>= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Validation Class: o= rg.apache.cassandra.db.marshal.LongType
> =C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 Column Name: mergeusertype
> =C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Validation Class: org.apache.cassandra.db.ma= rshal.Int32Type
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Compaction Strategy: org.apache.cassand= ra.db.compaction.SizeTieredCompactionStrategy
> =C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 Compression Options:
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 sstable_compression: org.apache.cassandra.io.compress.SnappyCompress= or
>
>
>
> I tried also to create a new table with Levele= dCompactionStrategy (using cqlsh), and when I check the compaction strategy= , the SizeTieredCompactionStrategy is set for this table.
>
> c= qlsh:test1> CREATE TABLE pns_credentials3 (
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ...=C2=A0=C2=A0 ise t= ext PRIMARY KEY,
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 .= ..=C2=A0=C2=A0 isnew int,
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 ...=C2=A0=C2=A0 ts timestamp,
> =C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 ...=C2=A0=C2=A0 mergestatus int,
> =C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ...=C2=A0=C2=A0 infranetaccount text,<= br>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ...=C2=A0=C2=A0 us= er_level int,
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ...=C2=A0=C2=A0 msisd= n bigint,
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ...=C2= =A0=C2=A0 mergeusertype int
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 ... ) WITH
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 ...=C2=A0=C2=A0 comment=3D'' AND
> =C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0

--
Thanks,

Charlie (@mujiang) =E6= =9C=A8=E5=8C=A0
=3D=3D=3D=3D=3D=3D=3D
Data Architect Developer
http://mujiang.blogspot.com

--f46d043c7c7cd84b9b04c8c669d0--