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 11:02:11 GMT
Ah, that's it. I'm on 0.7

On Mon, Jul 18, 2011 at 1:27 PM, Boris Yen <yulinyen@gmail.com> wrote:

> which version of cassandra do you use? What I mentioned here only happens
> on 0.8.1.
>
>
> On Mon, Jul 18, 2011 at 4:44 PM, David Boxenhorn <david@citypath.com>wrote:
>
>> 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