[jira] [Resolved] (CASSANDRA-6370) Updating cql created table through cassandra-cli transform it into a compact storage table

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis resolved CASSANDRA-6370.
---------------------------------------

    Resolution: Won't Fix

Why do you think cli does not list cql-created tables?

> 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
>            Priority: Critical
>
> 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)