incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Added extra column as composite key while creation counter column family
Date Tue, 16 Apr 2013 21:26:32 GMT
What version are you using ? 

WIth 1.2.4 …

cqlsh:dev>  CREATE TABLE counters (
       ...   key text,
       ...   value counter,
       ...   PRIMARY KEY (key)
       ...  ) WITH COMPACT STORAGE;
cqlsh:dev> describe table counters;

CREATE TABLE counters (
  key text PRIMARY KEY,
  value counter
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  read_repair_chance=0.100000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'SnappyCompressor'};

Cheers

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 15/04/2013, at 3:58 PM, Kuldeep Mishra <kuld.cs.mishra@gmail.com> wrote:

> Hi,
>    While I creating counter column family a extra column is being added what I do ?
> Table creation script
>  CREATE TABLE counters (
>   key text,
>   value counter,
>   PRIMARY KEY (key)
>  ) WITH COMPACT STORAGE
> 
> after describing column family I am getting following 
> CREATE TABLE counters (
>   key text,
>   column1 text,
>   value counter,
>   PRIMARY KEY (key, column1)
> ) WITH COMPACT STORAGE AND
>   bloom_filter_fp_chance=0.010000 AND
>   caching='KEYS_ONLY' AND
>   comment='' AND
>   dclocal_read_repair_chance=0.000000 AND
>   gc_grace_seconds=864000 AND
>   read_repair_chance=0.100000 AND
>   replicate_on_write='true' AND
>   compaction={'class': 'SizeTieredCompactionStrategy'} AND
>   compression={'sstable_compression': 'SnappyCompressor'};
> 
> extra column column1 is added 
> 
> Please help
> 
> -- 
> Thanks and Regards
> Kuldeep Kumar Mishra
> +919540965199


Mime
View raw message