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

["Sujeet Gholap (JIRA)" <ji...@apache.org>]

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

Sujeet Gholap updated CASSANDRA-9064:
-------------------------------------
    Component/s: Core

> [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
>
> 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)