[CASSANDRA-5749] DESC TABLE omits some column family settings

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0 beta 2
• Labels: cqlsh
• Severity: Low
• Assignee: Aleksey Yeschenko
• Reporter: Ryan McGuire

Authors

Aleksey Yeschenko

Reviewers

Brandon Williams

• Created: 12/Jul/13 16:00
• Updated: 16/Apr/19 09:32
• Resolved: 15/Jul/13 10:49

Description

In CQL I can create a table with settings introduced in 2.0:

cqlsh:Keyspace1> CREATE TABLE r1 ( key int PRIMARY KEY, value varchar) WITH speculative_retry='ALWAYS';

But the settings don't show up when I DESC TABLE:

cqlsh:Keyspace1> DESC TABLE r1;

CREATE TABLE r1 (
  key int PRIMARY KEY,
  value text
) 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
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'LZ4Compressor'};

For comparison, here is the same table viewed from cassandra-cli:

[default@Keyspace1] describe r1;

WARNING: CQL3 tables are intentionally omitted from 'describe' output.
See https://issues.apache.org/jira/browse/CASSANDRA-4377 for details.

WARNING: Could not connect to the JMX on 127.0.0.1:7199 - some information won't be shown.

    ColumnFamily: r1
      Key Validation Class: org.apache.cassandra.db.marshal.Int32Type
      Default column value validator: org.apache.cassandra.db.marshal.BytesType
      Cells sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
      GC grace seconds: 0
      Compaction min/max thresholds: 0/0
      Read repair chance: 0.0
      DC Local Read repair chance: 0.0
      Populate IO Cache on flush: false
      Replicate on write: false
      Caching: keys_only
      Default time to live: 0
      Bloom Filter FP chance: default
      Index interval: default
      Speculative Retry: NONE
      Compaction Strategy: null

Ideally, all of these values that cli shows would be shown by cqlsh.