[ https://issues.apache.org/jira/browse/CASSANDRA-4996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shamim Ahmed updated CASSANDRA-4996: ------------------------------------ Description: faced very strange behaviour when changing compression_parameters of exisiting CF. After changing the compaction strategy, compression_strategy returning back to the "SnappyCompressor". Using cassandra version 1.1.5. [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 2.0.0 | Thrift protocol 19.32.0] I have one column family with following paramters: cqlsh > describe columnfamily auditlog_01; CREATE TABLE auditlog_01 ( lid text PRIMARY KEY, dscn text, asid text, soapa text ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb='5' AND compression_parameters:sstable_compression='SnappyCompressor'; Changing compression strategy to 'DeflateCompressor cqlsh> ALTER TABLE auditlog_01 WITH compression_parameters:sstabl e_compression = 'DeflateCompressor' AND compression_parameters:chunk_length_kb = 64; cqlsh> describe columnfamily auditlog_01; CREATE TABLE auditlog_01 ( lid text PRIMARY KEY, dscn text, asid text, soapa text ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb='5' AND compression_parameters:chunk_length_kb='64' AND compression_parameters:sstable_compression='DeflateCompressor'; it's sucessfuly changed the compression strategy to 'DeflateCompressor, after that when i am trying to change the compaction strategy, compression strategy returing back to "SnappyCompressor". cqlsh> alter table auditlog_01 with compaction_strategy_class='Le veledCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb=5; cqlsh> describe columnfamily auditlog_01; CREATE TABLE auditlog_01 ( lid text PRIMARY KEY, dscn text, asid text, soapa text ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb='5' AND compression_parameters:sstable_compression='SnappyCompressor'; was: faced very strange behaviour when changing compression_parameters of exisiting CF. After changing the compaction strategy, compression_strategy returning back to the "SnappyCompressor". Using cassandra version 1.1.5. [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 2.0.0 | Thrift protocol 19.32.0] I have one column family with following paramters: cqlsh > describe columnfamily auditlog_01; CREATE TABLE auditlog_01 ( lid text PRIMARY KEY, dscn text, asid text, soapa text ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb='5' AND compression_parameters:sstable_compression='SnappyCompressor'; Changing compression strategy to 'DeflateCompressor cqlsh:p00smev_archKS> ALTER TABLE auditlog_01 WITH compression_parameters:sstabl e_compression = 'DeflateCompressor' AND compression_parameters:chunk_length_kb = 64; cqlsh:p00smev_archKS> describe columnfamily auditlog_01; CREATE TABLE auditlog_01 ( lid text PRIMARY KEY, dscn text, asid text, soapa text ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb='5' AND compression_parameters:chunk_length_kb='64' AND compression_parameters:sstable_compression='DeflateCompressor'; it's sucessfuly changed the compression strategy to 'DeflateCompressor, after that when i am trying to change the compaction strategy, compression strategy returing back to "SnappyCompressor". cqlsh:p00smev_archKS> alter table auditlog_01 with compaction_strategy_class='Le veledCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb=5; cqlsh:p00smev_archKS> describe columnfamily auditlog_01; CREATE TABLE auditlog_01 ( lid text PRIMARY KEY, dscn text, asid text, soapa text ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb='5' AND compression_parameters:sstable_compression='SnappyCompressor'; > After changing the compaction strategy, compression_strategy always > returning back to the "SnappyCompressor" through CQL 2.2.0 > ------------------------------------------------------------------------------------------------------------------------------- > > Key: CASSANDRA-4996 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4996 > Project: Cassandra > Issue Type: Bug > Components: Core > Affects Versions: 1.1.5 > Reporter: Shamim Ahmed > Priority: Trivial > Fix For: 1.1.7 > > > faced very strange behaviour when changing compression_parameters of > exisiting CF. After changing the compaction strategy, compression_strategy > returning back to the "SnappyCompressor". > Using cassandra version 1.1.5. > [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 2.0.0 | Thrift protocol 19.32.0] > I have one column family with following paramters: > cqlsh > describe columnfamily auditlog_01; > CREATE TABLE auditlog_01 ( > lid text PRIMARY KEY, > dscn text, > asid text, > soapa text > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 AND > gc_grace_seconds=864000 AND > default_validation=text AND > min_compaction_threshold=4 AND > max_compaction_threshold=32 AND > replicate_on_write='true' AND > compaction_strategy_class='SizeTieredCompactionStrategy' AND > compaction_strategy_options:sstable_size_in_mb='5' AND > compression_parameters:sstable_compression='SnappyCompressor'; > Changing compression strategy to 'DeflateCompressor > cqlsh> ALTER TABLE auditlog_01 WITH compression_parameters:sstabl > e_compression = 'DeflateCompressor' AND > compression_parameters:chunk_length_kb = > 64; > cqlsh> describe columnfamily auditlog_01; > CREATE TABLE auditlog_01 ( > lid text PRIMARY KEY, > dscn text, > asid text, > soapa text > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 AND > gc_grace_seconds=864000 AND > default_validation=text AND > min_compaction_threshold=4 AND > max_compaction_threshold=32 AND > replicate_on_write='true' AND > compaction_strategy_class='SizeTieredCompactionStrategy' AND > compaction_strategy_options:sstable_size_in_mb='5' AND > compression_parameters:chunk_length_kb='64' AND > compression_parameters:sstable_compression='DeflateCompressor'; > it's sucessfuly changed the compression strategy to 'DeflateCompressor, after > that when i am trying to change the compaction strategy, compression strategy > returing back to "SnappyCompressor". > cqlsh> alter table auditlog_01 with compaction_strategy_class='Le > veledCompactionStrategy' AND compaction_strategy_options:sstable_size_in_mb=5; > cqlsh> describe columnfamily auditlog_01; > CREATE TABLE auditlog_01 ( > lid text PRIMARY KEY, > dscn text, > asid text, > soapa text > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 AND > gc_grace_seconds=864000 AND > default_validation=text AND > min_compaction_threshold=4 AND > max_compaction_threshold=32 AND > replicate_on_write='true' AND > compaction_strategy_class='SizeTieredCompactionStrategy' AND > compaction_strategy_options:sstable_size_in_mb='5' AND > compression_parameters:sstable_compression='SnappyCompressor'; -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira