We have same problem. On Friday, August 31, 2012, Jean-Armel Luce <jaluc...@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 <aa...@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 <jaluc...@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
