I haven't tried this, but it should work in theory... Keep the wrongly named index for now. Create the rightly named index, then bring down the node and swap file names for the indexes. After that, you can safely drop the wrongly named index. Unfortunately, you need to do this for each node.
Gary. On Wed, Feb 16, 2011 at 11:15, Roland Gude <roland.g...@yoochoose.com> wrote: > Hi, > > unfortiunately i made a copy paste error and created two indexes called > “myindex” on different columnfamilies. > > What can I do to fix this? > > > > Below the output from describe keyspace > > > > ColumnFamily: A > > Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType > > Row cache size / save period: 0.0/0 > > Key cache size / save period: 200000.0/14400 > > Memtable thresholds: 1.1203125/239/60 > > GC grace seconds: 864000 > > Compaction min/max thresholds: 4/32 > > Read repair chance: 1.0 > > Column Metadata: > > Column Name: 00000000-0000-1000-0000-000000000000 > > Validation Class: org.apache.cassandra.db.marshal.UTF8Type > > Index Name: MyIndex > > Index Type: KEYS > > ColumnFamily: B > > Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType > > Row cache size / save period: 0.0/0 > > Key cache size / save period: 200000.0/14400 > > Memtable thresholds: 1.1203125/239/60 > > GC grace seconds: 864000 > > Compaction min/max thresholds: 4/32 > > Read repair chance: 1.0 > > Column Metadata: > > Column Name: 00000000-0000-1000-0000-000000000000 > > Validation Class: org.apache.cassandra.db.marshal.UTF8Type > > Index Name: MyIndex > > Index Type: KEYS > > > > -- > > YOOCHOOSE GmbH > > > > Roland Gude > > Software Engineer > > > > Im Mediapark 8, 50670 Köln > > > > +49 221 4544151 (Tel) > > +49 221 4544159 (Fax) > > +49 171 7894057 (Mobil) > > > > > > Email: roland.g...@yoochoose.com > > WWW: www.yoochoose.com > > > > YOOCHOOSE GmbH > > Geschäftsführer: Dr. Uwe Alkemper, Michael Friedmann > > Handelsregister: Amtsgericht Köln HRB 65275 > > Ust-Ident-Nr: DE 264 773 520 > > Sitz der Gesellschaft: Köln > >
