[
https://issues.apache.org/jira/browse/CASSANDRA-6370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne updated CASSANDRA-6370:
----------------------------------------
Attachment: 6370.txt
Let's keep it simple, attaching a patch that just refuse modifications to CQL3
tables from thrift. We don't allow to create them or list them so there's no
good reason to allow modifying them and that way we make sure to avoid subtle
screw-ups. And if you really want to shoot yourself in the foot by messing up
with the underlying schema layout, that's what the System tables are for.
> 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)
