Ah, that's it. I'm on 0.7 On Mon, Jul 18, 2011 at 1:27 PM, Boris Yen <yulin...@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 <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 >>>> >>> >>> >> >
