You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Roland Gude <ro...@yoochoose.com> on 2011/02/16 18:15:14 UTC

rename index

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.gude@yoochoose.com
WWW: www.yoochoose.com<http://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

AW: rename index

Posted by Roland Gude <ro...@yoochoose.com>.

Thanks,
Up to now i could not see any problems with the index names
For now I will not touch it. If I encounter something I’ll let you know

Von: Aaron Morton [mailto:aaron@thelastpickle.com]
Gesendet: Mittwoch, 16. Februar 2011 21:00
An: user@cassandra.apache.org
Betreff: Re: rename index

There is no rename, but update column family though the cli or api with just the renamed index should work.

The code says it will remove old and add new indexes based on their name.

I'm not sure if the name is used for anything other than identifying the index inside the CF. Are the duplicate names causing a problem?

Aaron

On 17/02/2011, at 6:15 AM, Roland Gude <ro...@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.gude@yoochoose.com<ma...@yoochoose.com>
WWW: www.yoochoose.com<http://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

Re: rename index

Posted by Aaron Morton <aa...@thelastpickle.com>.

There is no rename, but update column family though the cli or api with just the renamed index should work.

The code says it will remove old and add new indexes based on their name.

I'm not sure if the name is used for anything other than identifying the index inside the CF. Are the duplicate names causing a problem?

Aaron

On 17/02/2011, at 6:15 AM, Roland Gude <ro...@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.gude@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
> 
>

Re: rename index

Posted by Gary Dusbabek <gd...@gmail.com>.

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 <ro...@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.gude@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
>
>