cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Data Craftsman 木匠 <database.crafts...@gmail.com>
Subject Re: How to set LeveledCompactionStrategy for an existing table
Date Mon, 03 Sep 2012 06:40:11 GMT
We have same problem.

On Friday, August 31, 2012, Jean-Armel Luce <jaluce06@gmail.com> 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 <aaron@thelastpickle.com>
>
> 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 <jaluce06@gmail.com> 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='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='' AND
>

-- 
Thanks,

Charlie (@mujiang) 木匠
=======
Data Architect Developer
http://mujiang.blogspot.com

Mime
View raw message