cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikhail Stepura (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-6898) describing a table with compression should expand the compression options
Date Thu, 20 Mar 2014 19:02:50 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-6898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13942140#comment-13942140
] 

Mikhail Stepura commented on CASSANDRA-6898:
--------------------------------------------

That's not the case for 2.1 branch, where we use python-driver to display that information

{code}
cqlsh:test> DESC TABLE foo ;

CREATE TABLE test.foo (
    key int PRIMARY KEY,
    fdate timestamp,
    fooset set<text>
) WITH bloom_filter_fp_chance = 0.01
    AND caching = '{"keys":"NONE", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32'}
    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 populate_io_cache_on_flush = false
    AND read_repair_chance = 0.1
    AND rows_per_partition_to_cache = '100'
    AND speculative_retry = '99.0PERCENTILE';

cqlsh:test> alter TABLE  foo WITH compression = {'sstable_compression': 'LZ4Compressor'};
cqlsh:test> DESC TABLE foo ;

CREATE TABLE test.foo (
    key int PRIMARY KEY,
    fdate timestamp,
    fooset set<text>
) WITH bloom_filter_fp_chance = 0.01
    AND caching = '{"keys":"NONE", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32'}
    AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    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 populate_io_cache_on_flush = false
    AND read_repair_chance = 0.1
    AND rows_per_partition_to_cache = '100'
    AND speculative_retry = '99.0PERCENTILE';
{code}


> describing a table with compression should expand the compression options
> -------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6898
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6898
>             Project: Cassandra
>          Issue Type: Bug
>          Components: API
>            Reporter: Brandon Williams
>            Priority: Minor
>             Fix For: 2.0.7
>
>
> {noformat}
> cqlsh:foo> CREATE TABLE baz ( foo text, bar text, primary KEY (foo)) WITH compression
= {};
> cqlsh:foo> DESCRIBE TABLE baz;
> CREATE TABLE baz (
>   foo text,
>   bar text,
>   PRIMARY KEY (foo)
> ) 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
>   index_interval=128 AND
>   read_repair_chance=0.100000 AND
>   replicate_on_write='true' AND
>   populate_io_cache_on_flush='false' AND
>   default_time_to_live=0 AND
>   speculative_retry='99.0PERCENTILE' AND
>   memtable_flush_period_in_ms=0 AND
>   compaction={'class': 'SizeTieredCompactionStrategy'} AND
>   compression={};
> cqlsh:foo>
> {noformat}
> From this, you can't tell that LZ4 compression is enabled, even though it is.  It would
be more friendly to expand the option to show the defaults.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message