cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4597) Impossible to set LeveledCompactionStrategy to a column family.
Date Sun, 02 Sep 2012 08:25:07 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13446895#comment-13446895
] 

jal commented on CASSANDRA-4597:
--------------------------------

I tried to alter the table with the folowing CQL command :
alter table pns_credentials6
WITH compaction_strategy_class='LeveledCompactionStrategy'
AND compaction_strategy_options:sstable_size_in_mb=15;

Using cassandra 1.1.1 : it doesn't work (neither compaction_strategy_class nor compaction_strategy_options
is modified)
Using cassandra 1.1.2 : same as 1.1.1
Using cassandra 1.1.3 : neither compaction_strategy_class is not modified, but compaction_strategy_options
is modified)
Using cassandra 1.1.4 : same as 1.1.3


Below are the details with cassandra 1.1.4 :
At first, I create a table pns_credentials6 (with compaction_strategy_class='SizeTieredCompactionStrategy')
Then, I describe the table
Then, I alter the table
Then, I describe again the table :  the line compaction_strategy_options:sstable_size_in_mb='15'
(since 1.1.3) appears but compaction_strategy_class is still 'SizeTieredCompactionStrategy'

Connected to Test Cluster at localhost:9160.
[cqlsh 2.2.0 | Cassandra 1.1.4 | CQL spec 3.0.0 | Thrift protocol 19.32.0]
Use HELP for help.
cqlsh> use test1;
cqlsh:test1> CREATE TABLE pns_credentials6 (
         ...    ise text PRIMARY KEY,
         ...    isnew int,
         ...    ts timestamp,
         ...    mergestatus int,
         ...    infranetaccount text,
         ...    user_level int,
         ...    msisdn bigint,
         ...    mergeusertype int
         ...  ) WITH
         ...    comment='' AND
         ...    read_repair_chance=0.100000 AND
         ...   gc_grace_seconds=864000 AND
         ...    replicate_on_write='true' AND
         ...    compaction_strategy_class='SizeTieredCompactionStrategy' AND
         ...    compression_parameters:sstable_compression='SnappyCompressor';
cqlsh:test1> describe table pns_credentials6;

CREATE TABLE pns_credentials6 (
  ise text PRIMARY KEY,
  infranetaccount text,
  isnew int,
  mergestatus int,
  mergeusertype int,
  msisdn bigint,
  ts timestamp,
  user_level int
) WITH
  comment='' AND
  caching='KEYS_ONLY' AND
  read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  replicate_on_write='true' AND
  compaction_strategy_class='SizeTieredCompactionStrategy' AND
  compression_parameters:sstable_compression='SnappyCompressor';

cqlsh:test1> alter table pns_credentials6
         ... WITH compaction_strategy_class='LeveledCompactionStrategy'
         ... AND compaction_strategy_options:sstable_size_in_mb=15;
cqlsh:test1> describe table pns_credentials6;

CREATE TABLE pns_credentials6 (
  ise text PRIMARY KEY,
  infranetaccount text,
  isnew int,
  mergestatus int,
  mergeusertype int,
  msisdn bigint,
  ts timestamp,
  user_level int
) WITH
  comment='' AND
  caching='KEYS_ONLY' AND
  read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 AND
  replicate_on_write='true' AND
  compaction_strategy_class='SizeTieredCompactionStrategy' AND
  compaction_strategy_options:sstable_size_in_mb='15' AND
  compression_parameters:sstable_compression='SnappyCompressor';

As you can see, I did the check with a new table (pns_credentials6), created in 1.1.4.
When you say that I need to recreate the schema, is it what you were expecting ?
                
> Impossible to set LeveledCompactionStrategy to a column family. 
> ----------------------------------------------------------------
>
>                 Key: CASSANDRA-4597
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4597
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.1
>         Environment: Ubuntu 12.04
> cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 3.0.0 | Thrift protocol 19.32.0
> Cluster with only 1 node
>            Reporter: jal
>
> CFPropDefs.applyToCFMetadata() does not set the compaction class on CFM
> When altering the compaction strategy of a column family to LeveledCompactionStrategy,
the compaction strategy is not changed (the describe command shows that the SizeTieredCompactionStrategy
is still set to the CF)
> When creating a column family WITH compaction_strategy_class='LeveledCompactionStrategy',
the compaction strategy class used is  SizeTieredCompactionStrategy
> Ex : 
> jal@jal-VirtualBox:~/cassandra/apache-cassandra-1.1.1/bin$ ./cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use test1;
> cqlsh:test1> describe table pns_credentials;
> CREATE TABLE pns_credentials (
>   ise text PRIMARY KEY,
>   isnew int,
>   ts timestamp,
>   mergestatus int,
>   infranetaccount text,
>   user_level int,
>   msisdn bigint,
>   mergeusertype int
> ) 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
>   compression_parameters:sstable_compression='SnappyCompressor';
> I want to set the LeveledCompaction strategy for this table, so I execute the following
ALTER TABLE :
> cqlsh:test1> alter table pns_credentials 
>          ... WITH compaction_strategy_class='LeveledCompactionStrategy'
>          ... AND compaction_strategy_options:sstable_size_in_mb=10;
> In Cassandra logs, I see some informations :
>  INFO 10:23:52,532 Enqueuing flush of Memtable-schema_columnfamilies@965212657(1391/1738
serialized/live bytes, 20 ops)
>  INFO 10:23:52,533 Writing Memtable-schema_columnfamilies@965212657(1391/1738 serialized/live
bytes, 20 ops)
>  INFO 10:23:52,629 Completed flushing /var/lib/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-94-Data.db
(1442 bytes) for commitlog position ReplayPosition(segmentId=3556583843054, position=1987)
> However, when I look at the description of the table, the table is still with the SizeTieredCompactionStrategy
> cqlsh:test1> describe table pns_credentials ;
> CREATE TABLE pns_credentials (
>   ise text PRIMARY KEY,
>   isnew int,
>   ts timestamp,
>   mergestatus int,
>   infranetaccount text,
>   user_level int,
>   msisdn bigint,
>   mergeusertype int
> ) 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
>   compression_parameters:sstable_compression='SnappyCompressor';
>  
> In the schema_columnfamilies table (in system keyspace), the table pns_credentials is
still using the SizeTieredCompactionStrategy
> cqlsh:test1> use system;
> cqlsh:system> select * from schema_columnfamilies ;
> ...
>          test1 |   pns_credentials |                   null | KEYS_ONLY |           
            [] |         | org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
|                          {} |                                                          
                                                                                         
                      org.apache.cassandra.db.marshal.UTF8Type | {"sstable_compression":"org.apache.cassandra.io.compress.SnappyCompressor"}
|          org.apache.cassandra.db.marshal.UTF8Type |           864000 | 1029 |       ise
|     org.apache.cassandra.db.marshal.UTF8Type |                        0 |              
        32 |                        4 |                0.1 |               True |        
 null | Standard |        null
> ... 
> Same behaviour using cqlsh or command-cli.

--
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

Mime
View raw message