cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-6370) Updating cql created table through cassandra-cli transform it into a compact storage table
Date Mon, 18 Nov 2013 15:53:26 GMT

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

Jonathan Ellis commented on CASSANDRA-6370:
-------------------------------------------

+1

> Updating cql created table through cassandra-cli transform it into a compact storage
table
> ------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6370
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6370
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Alain RODRIGUEZ
>            Assignee: Sylvain Lebresne
>            Priority: Critical
>             Fix For: 1.2.12
>
>         Attachments: 6370.txt
>
>
> To reproduce :
> echo "CREATE TABLE test (aid int, period text, event text, viewer text, PRIMARY KEY (aid,
period, event, viewer) );" | cqlsh -kmykeyspace;
> echo "describe table test;" | cqlsh -kmykeyspace;
> Output >
> CREATE TABLE test (
>   aid int,
>   period text,
>   event text,
>   viewer text,
>   PRIMARY KEY (aid, period, event, viewer)
> ) WITH
>   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'};
> Then do :
> echo "update column family test with dclocal_read_repair_chance = 0.1;" | cassandra-cli
-kmykeyspace
> And finally again : echo "describe table test;" | cqlsh -kmykeyspace;
> Output >
> CREATE TABLE test (
>   aid int,
>   column1 text,
>   column2 text,
>   column3 text,
>   column4 text,
>   value blob,
>   PRIMARY KEY (aid, column1, column2, column3, column4)
> ) WITH COMPACT STORAGE AND
>   bloom_filter_fp_chance=0.010000 AND
>   caching='KEYS_ONLY' AND
>   comment='' AND
>   dclocal_read_repair_chance=0.100000 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'};
> This is quite annoying in production. If it is happening to you: 
> UPDATE system.schema_columnfamilies SET column_aliases = '["period","event","viewer"]'
WHERE keyspace_name='mykeyspace' AND columnfamily_name='test'; should help restoring the table.
(Thanks Sylvain for this information.)



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message