> 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) What process did you use to drop the indexes ? You need to use update column family and not include the column meta data.
> 1. Is there a better way to check schema for indexes? Thats the way. You can also look in JConsole. If you see things that seem odd check the cluster agrees on the schema using describe cluster in the CLI. > 3. Do validators incur any performance penalties? They're no longer > necessary (the named columns are not even written anymore). There is a minor over head, but only if the named column is updated. Cheers ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 17/08/2011, at 2:12 AM, Dan Kuebrich wrote: > 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
