[
https://issues.apache.org/jira/browse/CASSANDRA-9064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592777#comment-14592777
]
Eugene commented on CASSANDRA-9064:
-----------------------------------
It would be nice to get this fixed.
For anyone looking for a work around, just strip out the min_threshold and
max_threshold fields on the describe keyspace output.
This might work in some situations:
{code} sed -i -e "s/{.*LeveledCompactionStrategy.*}/{'class':
'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}/" tables.txt
{code}
Before using that verify that the compaction configuration for those tables
don't have anything other than *min_threshold*, *max_threshold*, and *class*
parameters defined.
> [LeveledCompactionStrategy] cqlsh can't run cql produced by its own describe
> table statement
> --------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-9064
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9064
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: cassandra 2.1.3 on mac os x
> Reporter: Sujeet Gholap
> Assignee: Benjamin Lerer
> Labels: cqlsh
> Fix For: 2.1.x
>
>
> Here's how to reproduce:
> 1) Create a table with LeveledCompactionStrategy
> CREATE keyspace foo WITH REPLICATION = {'class': 'SimpleStrategy',
> 'replication_factor' : 3};
> CREATE TABLE foo.bar (
> spam text PRIMARY KEY
> ) WITH compaction = {'class': 'LeveledCompactionStrategy'};
> 2) Describe the table and save the output
> cqlsh -e "describe table foo.bar"
> Output should be something like
> CREATE TABLE foo.bar (
> spam text PRIMARY KEY
> ) WITH bloom_filter_fp_chance = 0.1
> AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
> AND comment = ''
> AND compaction = {'min_threshold': '4', 'class':
> 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy',
> 'max_threshold': '32'}
> AND compression = {'sstable_compression':
> 'org.apache.cassandra.io.compress.LZ4Compressor'}
> AND dclocal_read_repair_chance = 0.1
> AND default_time_to_live = 0
> AND gc_grace_seconds = 864000
> AND max_index_interval = 2048
> AND memtable_flush_period_in_ms = 0
> AND min_index_interval = 128
> AND read_repair_chance = 0.0
> AND speculative_retry = '99.0PERCENTILE';
> 3) Save the output to repro.cql
> 4) Drop the table foo.bar
> cqlsh -e "drop table foo.bar"
> 5) Run the create table statement we saved
> cqlsh -f "repro.cql"
> 6) Expected: normal execution without an error
> 7) Reality:
> ConfigurationException: <ErrorMessage code=2300 [Query invalid because of
> configuration issue] message="Properties specified [min_threshold,
> max_threshold] are not understood by LeveledCompactionStrategy">
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
