cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Kuebrich <dan.kuebr...@gmail.com>
Subject dropping secondary indexes
Date Tue, 16 Aug 2011 14:12:53 GMT
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

Mime
View raw message