I think I've dropped all the indexes on a CF, but I see traces of them in
the CLI output of show keyspaces. I see a few validators left behind, and
one "built index". (output below)
1. Is there a better way to check schema for indexes?
2. I can't drop the "built" one so I assume they're all gone? If so, what
is the remaining index listing?
3. Do validators incur any performance penalties? They're no longer
necessary (the named columns are not even written anymore).
ColumnFamily: MyCF
Key Validation Class: org.apache.cassandra.db.marshal.BytesType
Default column value validator:
org.apache.cassandra.db.marshal.BytesType
Columns sorted by: org.apache.cassandra.db.marshal.BytesType
Row cache size / save period in seconds: 2000.0/0
Key cache size / save period in seconds: 200000.0/14400
Memtable thresholds: 1.1203125/1440/239 (millions of ops/minutes/MB)
GC grace seconds: 864000
Compaction min/max thresholds: 4/32
Read repair chance: 1.0
Replicate on write: false
Built indexes: [MyCF.MyCF_617070_idx]
Column Metadata:
Column Name: col1 (6167656e74)
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: col2 (617070)
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Index Name: MyCF_617070_idx
Index Type: KEYS
Column Name: col3 (686f7374)
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: col4 (686f73745f6964)
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: col5 (696d706c)
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: col6 (706572696f64)
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
