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 [mailto:md

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 H

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 unders

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 @aaronmor

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 > De : mdione@orange.com [mailto:mdione@orange.com] > > [default@avatars] describe HBX_FILE; > > ColumnFamily: HBX_FILE > > Key Validation Class

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 s

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 popu

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 Dave Brosius
S='actif'; Bad Request: No indexed columns present in by-columns clause with "equals" operator A query that works: cqlsh:avatars> SELECT HBX_FIL_STATUS FROM HBX_FILE WHERE KEY=1; HBX_FIL_STATUS Actif Just in case, here's cli's o

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

2012-04-23 Thread mdione.ext
ite=True; CREATE INDEX HBX_FILE_HBX_FIL_STATUS_idx ON HBX_FILE (HBX_FIL_STATUS); The query and the error: cqlsh:avatars> SELECT HBX_FIL_SMALL FROM HBX_FILE WHERE KEY=1 AND HBX_FIL_STATUS='actif'; Bad Request: No indexed columns present in by-columns clause with "equals" operator A query tha