[
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
