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 <da...@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 <yulin...@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 <jbel...@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 <yulin...@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 <yulin...@gmail.com> >>> wrote: >>> >> >>> >> Done. It is CASSANDRA-2903. >>> >> On Sat, Jul 16, 2011 at 9:44 AM, Jonathan Ellis <jbel...@gmail.com> >>> wrote: >>> >>> >>> >>> Please. >>> >>> >>> >>> On Fri, Jul 15, 2011 at 7:29 PM, Boris Yen <yulin...@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 <jbel...@gmail.com >>> > >>> >>> > wrote: >>> >>> >> >>> >>> >> Sounds reasonable to me. >>> >>> >> >>> >>> >> On Fri, Jul 15, 2011 at 2:55 AM, Boris Yen <yulin...@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 >>> >> >> >
