Re: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-29 Thread aaron morton
Check there is a single schema version on the cluster, in the cassandra-cli use describe cluster; Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/04/2012, at 3:33 AM, mdione@orange.com wrote: De : mdione@orange.com

RE: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-25 Thread mdione.ext
De : aaron morton [mailto:aa...@thelastpickle.com] The secondary index will be build using the compaction features, you can check the progress with nodetool compactionstats When they are build the output from describe. will list the build indexes.  Built indexes: [] Should I understand

RE: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-25 Thread mdione.ext
De : mdione@orange.com [mailto:mdione@orange.com] Should I understand that when the indexes are finished being built a) the «Built indexes» list should be empty and b) there should be no pending compactions? Because that's exactly what I have now but I still can't use the column

RE: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-24 Thread mdione.ext
De : mdione@orange.com [mailto:mdione@orange.com] [default@avatars] describe HBX_FILE; ColumnFamily: HBX_FILE Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted

Re: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-24 Thread R. Verlangen
I read a while ago that a compaction would rebuild the index. You can trigger this by running repair with the nodetool. 2012/4/24 mdione@orange.com De : mdione@orange.com [mailto:mdione@orange.com] [default@avatars] describe HBX_FILE; ColumnFamily: HBX_FILE Key

Re: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-24 Thread aaron morton
The secondary index will be build using the compaction features, you can check the progress with nodetool compactionstats When they are build the output from describe… will list the build indexes… Built indexes: [] Hope that helps. - Aaron Morton Freelance Developer

Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-23 Thread mdione.ext
I understand the error message, but I don't understand why I get it. Here's the CF: cqlsh:avatars describe columnfamily HBX_FILE; CREATE COLUMNFAMILY HBX_FILE ( KEY blob PRIMARY KEY, HBX_FIL_DATE text, HBX_FIL_LARGE ascii, HBX_FIL_MEDIUM ascii, HBX_FIL_SMALL ascii, HBX_FIL_STATUS

Re: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-23 Thread Dave Brosius
Works for me on trunk... what version are you using? On 04/23/2012 08:39 AM, mdione@orange.com wrote: I understand the error message, but I don't understand why I get it. Here's the CF: cqlsh:avatars describe columnfamily HBX_FILE; CREATE COLUMNFAMILY HBX_FILE ( KEY blob PRIMARY

RE: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-23 Thread mdione.ext
De : Dave Brosius [mailto:dbros...@mebigfatguy.com] Works for me on trunk... what version are you using? Beh, I forgot that detail: 1.0.9. -- Marcos Dione SysAdmin Astek Sud-Est pour FT/TGPF/OPF/PORTAIL/DOP/HEBEX @ Marco Polo 04 97 12 62 45 - mdione@orange.com

RE: Bad Request: No indexed columns present in by-columns clause with equals operator

2012-04-23 Thread mdione.ext
De : mdione@orange.com [mailto:mdione@orange.com] De : Dave Brosius [mailto:dbros...@mebigfatguy.com] Works for me on trunk... what version are you using? Beh, I forgot that detail: 1.0.9. I also forgot to mention: the index was recently created, after the database was