Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of database.craftsman@gmail.com
 designates 209.85.212.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAEFZHGPZynirMDG2KqoPTiN8aN1Q4O0hYLN56n3_ucDd-C_MZg@mail.gmail.com>
References: 
 <CAEFZHGPZynirMDG2KqoPTiN8aN1Q4O0hYLN56n3_ucDd-C_MZg@mail.gmail.com>
Date: Fri, 3 Aug 2012 13:31:14 -0700
Message-ID: 
 <CAEFZHGPXnnjBrh-RL5ngkqDA1FjJA5HCnAamsWH9kwMjy0Qtpw@mail.gmail.com>
Subject: Re: How to create a COLUMNFAMILY with Leveled Compaction?
From: =?UTF-8?B?RGF0YSBDcmFmdHNtYW4g5pyo5Yyg?= <database.craftsman@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Nobody use Leveled Compaction with CQL 3.0 ?

-Z

On Tue, Jul 31, 2012 at 11:17 AM, Data Craftsman =E6=9C=A8=E5=8C=A0
<database.craftsman@gmail.com> wrote:
> Sorry for my stupid simple question. How to create a COLUMNFAMILY with
> Leveled Compaction?
>
> There is no example in documentation:
> http://www.datastax.com/docs/1.1/configuration/storage_configuration#comp=
action-strategy
>
> I try it on Cassandra 1.1.0 and 1.1.2, both failed. The COLUMNFAMILY
> is still 'SizeTieredCompactionStrategy'.  :(
>
> Here is my test and output:
>
> @host01:/usr/share/cassandra>cqlsh host01 --cql3
> Connected to BookCluster at host01:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0=
]
> Use HELP for help.
> cqlsh>
> cqlsh> use demo;
>
> cqlsh:demo> CREATE COLUMNFAMILY book
>         ... (isbn varchar,
>         ...  book_id bigint,
>         ...  price int,
>         ...  obj varchar,
>         ...  PRIMARY KEY (isbn, book_id)
>         ... )
>         ... WITH compaction_strategy_class=3D'LeveledCompactionStrategy';
> cqlsh:demo>
> cqlsh:demo> describe COLUMNFAMILY book;
>
> CREATE COLUMNFAMILY book (
>   isbn text PRIMARY KEY
> ) WITH
>   comment=3D'' AND
>   comparator=3D'CompositeType(org.apache.cassandra.db.marshal.LongType,or=
g.apache.cassandra.db.marshal.UTF8Type)'
> AND
>   read_repair_chance=3D0.100000 AND
>   gc_grace_seconds=3D864000 AND
>   default_validation=3Dtext AND
>   min_compaction_threshold=3D4 AND
>   max_compaction_threshold=3D32 AND
>   replicate_on_write=3DTrue AND
>   compaction_strategy_class=3D'SizeTieredCompactionStrategy' AND
>   compression_parameters:sstable_compression=3D'org.apache.cassandra.io.c=
ompress.SnappyCompressor';
>
> cqlsh:demo>
>
> Thanks,
> Charlie (@mujiang) =E4=B8=80=E4=B8=AA =E6=9C=A8=E5=8C=A0
> =3D=3D=3D=3D=3D=3D=3D
> Data Architect Developer
> http://mujiang.blogspot.com