[CASSANDRA-3304] Missing fields in show schema output

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Legacy/Tools
• Severity: Low
• Assignee: Pavel Yaskevich
• Reporter: Radim Kolar

Authors

Pavel Yaskevich

Reviewers

Jonathan Ellis

• Created: 04/Oct/11 12:52
• Updated: 16/Apr/19 09:32
• Resolved: 04/Oct/11 15:58

Description

if you compare output of these 2 commands:

show keyspaces
Keyspace: test:
Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
Durable Writes: true
Options: [replication_factor:1]
Column Families:
ColumnFamily: sipdb
"phone calls routing information"
Key Validation Class: org.apache.cassandra.db.marshal.IntegerType
Default column value validator: org.apache.cassandra.db.marshal.BytesType
Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
Row cache size / save period in seconds / keys to save : 0.0/0/all
Key cache size / save period in seconds: 0.0/0
GC grace seconds: 0
Compaction min/max thresholds: 4/32
Read repair chance: 0.0
Replicate on write: false
Built indexes: []
Column Metadata:
Column Name: kam
Validation Class: org.apache.cassandra.db.marshal.AsciiType
Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompacti

show schema
create column family sipdb
with column_type = 'Standard'
and comparator = 'AsciiType'
and default_validation_class = 'BytesType'
and key_validation_class = 'IntegerType'
and rows_cached = 0.0
and row_cache_save_period = 0
and keys_cached = 0.0
and key_cache_save_period = 0
and read_repair_chance = 0.0
and gc_grace = 0
and min_compaction_threshold = 4
and max_compaction_threshold = 32
and replicate_on_write = false
and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
and comment = 'phone calls routing information'
and column_metadata = [

{column_name : 'kam', validation_class : AsciiType}

];

You will discover that show schema is missing: 1. compaction strategy. 2. how many keys to save