[CASSANDRA-9064] [LeveledCompactionStrategy] cqlsh can't run cql produced by its own describe table statement

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.8, 2.2.0 rc2
• Component/s: Legacy/CQL
• Labels: cqlsh pull-request-available

Environment

cassandra 2.1.3 on mac os x

• Severity: Normal
• Assignee: Benjamin Lerer
• Reporter: Sujeet Gholap

Authors

Benjamin Lerer

Reviewers

T Jake Luciani

• Created: 27/Mar/15 21:12
• Updated: 18/Feb/20 21:11
• Resolved: 30/Jun/15 13:26

Description

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">

Issue Links

• relates to: CASSANDRA-9703 cqlsh on 2.0 adds invalid parameters to LeveledCompactionStrategy DESCRIBE output
• links to: GitHub Pull Request #51
• links to: Python driver branch