incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Boxenhorn <da...@citypath.com>
Subject Re: Default behavior of generate index_name for columns...
Date Mon, 18 Jul 2011 08:44:56 GMT
I have lots of indexes on columns with the same name. Why don't I have this
problem?

For example:

Keyspace: City:
  Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
    Replication Factor: 3
  Column Families:
    ColumnFamily: AttractionCheckins
      Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
      Row cache size / save period: 0.0/0
      Key cache size / save period: 0.1/14400
      Memtable thresholds: 0.3/64/60
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/64
      Read repair chance: 0.01
      Column Metadata:
        Column Name: 09partition (09partition)
          Validation Class: org.apache.cassandra.db.marshal.UTF8Type
          Index Type: KEYS
    ColumnFamily: Attractions
      Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
      Row cache size / save period: 30000.0/14400
      Key cache size / save period: 30000.0/14400
      Memtable thresholds: 0.3/64/60
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/64
      Read repair chance: 0.01
      Column Metadata:
        Column Name: 09partition (09partition)
          Validation Class: org.apache.cassandra.db.marshal.UTF8Type
          Index Type: KEYS
    ColumnFamily: CityResources
      Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
      Row cache size / save period: 5000.0/14400
      Key cache size / save period: 5000.0/14400
      Memtable thresholds: 0.3/64/60
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/64
      Read repair chance: 0.01
      Column Metadata:
        Column Name: 09partition (09partition)
          Validation Class: org.apache.cassandra.db.marshal.UTF8Type
          Index Type: KEYS

On Mon, Jul 18, 2011 at 8:20 AM, Boris Yen <yulinyen@gmail.com> wrote:

> Will this have any side effect when doing a get_indexed_slices or when a
> user wants to drop an index by any means?
>
> Boris
>
>
> On Mon, Jul 18, 2011 at 1:13 PM, Jonathan Ellis <jbellis@gmail.com> wrote:
>
>> 0.8.0 didn't check for name conflicts correctly.  0.8.1 does, but it
>> can't fix the ones 0.8.0 allowed, retroactively.
>>
>> On Sun, Jul 17, 2011 at 11:52 PM, Boris Yen <yulinyen@gmail.com> wrote:
>> > I have tested another case, not sure if this is a bug.
>> > I created a few column families on 0.8.0 each has user_name column, in
>> > addition, I also enabled secondary index on this column.  Then, I
>> upgraded
>> > to 0.8.1, when I used cassandra-cli: show keyspaces, I saw index name
>> > "user_name_idx" appears for different columns families. It seems the
>> > validation rule for index_name on 0.8.1 has been skipped completely.
>> >
>> > Is this a bug? or is it intentional?
>> > Regards
>> > Boris
>> > On Sat, Jul 16, 2011 at 10:38 AM, Boris Yen <yulinyen@gmail.com> wrote:
>> >>
>> >> Done. It is CASSANDRA-2903.
>> >> On Sat, Jul 16, 2011 at 9:44 AM, Jonathan Ellis <jbellis@gmail.com>
>> wrote:
>> >>>
>> >>> Please.
>> >>>
>> >>> On Fri, Jul 15, 2011 at 7:29 PM, Boris Yen <yulinyen@gmail.com>
>> wrote:
>> >>> > Hi Jonathan,
>> >>> > Do I need to open a ticket for this?
>> >>> > Regards
>> >>> > Boris
>> >>> >
>> >>> > On Sat, Jul 16, 2011 at 6:29 AM, Jonathan Ellis <jbellis@gmail.com>
>> >>> > wrote:
>> >>> >>
>> >>> >> Sounds reasonable to me.
>> >>> >>
>> >>> >> On Fri, Jul 15, 2011 at 2:55 AM, Boris Yen <yulinyen@gmail.com>
>> wrote:
>> >>> >> > Hi,
>> >>> >> > I have a few column families, each has a column called
user_name.
>> I
>> >>> >> > tried to
>> >>> >> > use secondary index on user_name column for each of the
column
>> >>> >> > family.
>> >>> >> > However, when creating these column families, cassandra
keeps
>> >>> >> > reporting
>> >>> >> > "Duplicate index name..." exception. I finally figured
out that
>> it
>> >>> >> > seems
>> >>> >> > the
>> >>> >> > default index name is "column name"+"_idx", this make
my column
>> >>> >> > family
>> >>> >> > violate the "uniqueness of index name" rule.
>> >>> >> > I was wondering if the default index_name generating rule
could
>> be
>> >>> >> > like
>> >>> >> > "column name"+"cf name", so the index name would not collide
with
>> >>> >> > each
>> >>> >> > other
>> >>> >> > that easily, if the user do not assign "index_name" when
creating
>> a
>> >>> >> > column
>> >>> >> > family.
>> >>> >> > Regards
>> >>> >> > Boris
>> >>> >> >
>> >>> >>
>> >>> >>
>> >>> >>
>> >>> >> --
>> >>> >> Jonathan Ellis
>> >>> >> Project Chair, Apache Cassandra
>> >>> >> co-founder of DataStax, the source for professional Cassandra
>> support
>> >>> >> http://www.datastax.com
>> >>> >
>> >>> >
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> Jonathan Ellis
>> >>> Project Chair, Apache Cassandra
>> >>> co-founder of DataStax, the source for professional Cassandra support
>> >>> http://www.datastax.com
>> >>
>> >
>> >
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of DataStax, the source for professional Cassandra support
>> http://www.datastax.com
>>
>
>

Mime
View raw message