incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andy Ballingall TF <balling...@thefoundry.co.uk>
Subject Re: How to create a COLUMNFAMILY with Leveled Compaction?
Date Fri, 10 Aug 2012 15:55:55 GMT
On 3 August 2012 21:31, Data Craftsman 木匠 <database.craftsman@gmail.com> wrote:
>
> Nobody use Leveled Compaction with CQL 3.0 ?



I tried this, and I can't get it to work either.

I'm using:

[cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0]


Here's what my create table looks like:

CREATE TABLE php_sessions(
    domain_name text,
    session_id text,
    session_data text,
    PRIMARY KEY (domain_name, session_id)
)
WITH COMPACT STORAGE ' AND
COMPACTION_STRATEGY_CLASS='LeveledCompactionStrategy';

It does create the table, but if you do DESCRIBE TABLE php_sessions it displays:

CREATE TABLE php_sessions (
  domain_name text,
  session_id text,
  session_data text,
  PRIMARY KEY (domain_name, session_id)
) WITH COMPACT STORAGE AND
  caching='KEYS_ONLY' AND
  read_repair_chance=0.100000 AND
  gc_grace_seconds=864000 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';


This table is created in a keyspace declared as follows:

CREATE KEYSPACE testkeyspace WITH
        strategy_class = 'NetworkTopologyStrategy'
        AND strategy_options:dc1=3;



I'd definitely like to use this new compaction type. Help!

Andy





>
>
> -Z
>
> On Tue, Jul 31, 2012 at 11:17 AM, Data Craftsman 木匠
> <database.craftsman@gmail.com> wrote:
> > Sorry for my stupid simple question. How to create a COLUMNFAMILY with
> > Leveled Compaction?
> >
> > There is no example in documentation:
> > http://www.datastax.com/docs/1.1/configuration/storage_configuration#compaction-strategy
> >
> > I try it on Cassandra 1.1.0 and 1.1.2, both failed. The COLUMNFAMILY
> > is still 'SizeTieredCompactionStrategy'.  :(
> >
> > Here is my test and output:
> >
> > @host01:/usr/share/cassandra>cqlsh host01 --cql3
> > Connected to BookCluster at host01:9160.
> > [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0]
> > Use HELP for help.
> > cqlsh>
> > cqlsh> use demo;
> >
> > cqlsh:demo> CREATE COLUMNFAMILY book
> >         ... (isbn varchar,
> >         ...  book_id bigint,
> >         ...  price int,
> >         ...  obj varchar,
> >         ...  PRIMARY KEY (isbn, book_id)
> >         ... )
> >         ... WITH compaction_strategy_class='LeveledCompactionStrategy';
> > cqlsh:demo>
> > cqlsh:demo> describe COLUMNFAMILY book;
> >
> > CREATE COLUMNFAMILY book (
> >   isbn text PRIMARY KEY
> > ) WITH
> >   comment='' AND
> >   comparator='CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.UTF8Type)'
> > 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='org.apache.cassandra.io.compress.SnappyCompressor';
> >
> > cqlsh:demo>
> >
> > Thanks,
> > Charlie (@mujiang) 一个 木匠
> > =======
> > Data Architect Developer
> > http://mujiang.blogspot.com




--
Andy Ballingall
Senior Software Engineer

The Foundry
6th Floor, The Communications Building,
48, Leicester Square,
London, WC2H 7LT, UK
Tel: +44 (0)20 7968 6828 - Fax: +44 (0)20 7930 8906
Web: http://www.thefoundry.co.uk/

The Foundry Visionmongers Ltd.
Registered in England and Wales No: 4642027

Mime
View raw message