incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Bad Request: No indexed columns present in by-columns clause with "equals" operator
Date Tue, 24 Apr 2012 23:05:00 GMT
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
@aaronmorton
http://www.thelastpickle.com

On 25/04/2012, at 12:06 AM, R. Verlangen wrote:

> 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.ext@orange.com>
> De : mdione.ext@orange.com [mailto:mdione.ext@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 by: org.apache.cassandra.db.marshal.UTF8Type
> >       Row cache size / save period in seconds / keys to save :
> > 0.0/0/all
> >       Row Cache Provider:
> > org.apache.cassandra.cache.ConcurrentLinkedHashCacheProvider
> >       Key cache size / save period in seconds: 200000.0/14400
> >       GC grace seconds: 864000
> >       Compaction min/max thresholds: 4/32
> >       Read repair chance: 1.0
> >       Replicate on write: true
> >       Bloom Filter FP chance: default
> >       Built indexes: []
> >       Column Metadata:
> >         Column Name: HBX_FIL_DATE
> >           Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> >         Column Name: HBX_FIL_LARGE
> >           Validation Class: org.apache.cassandra.db.marshal.AsciiType
> >         Column Name: HBX_FIL_MEDIUM
> >           Validation Class: org.apache.cassandra.db.marshal.AsciiType
> >         Column Name: HBX_FIL_SMALL
> >           Validation Class: org.apache.cassandra.db.marshal.AsciiType
> >         Column Name: HBX_FIL_STATUS
> >           Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> >           Index Name: HBX_FILE_HBX_FIL_STATUS_idx
> >           Index Type: KEYS
> >         Column Name: HBX_FIL_TINY
> >           Validation Class: org.apache.cassandra.db.marshal.AsciiType
> >       Compaction Strategy:
> > org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> 
>  Someone in #cassandra pointed out that the index might be created, but
> it's shown as not built («Built indexes: []»). Is that right? Any idea
> how to build it?
> 
> --
> Marcos Dione
> SysAdmin
> Astek Sud-Est
> pour FT/TGPF/OPF/PORTAIL/DOP/HEBEX @ Marco Polo
> 04 97 12 62 45 - mdione.ext@orange.com
> 
> 
> _________________________________________________________________________________________________________________________
> 
> Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou
privilegiees et ne doivent donc
> pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message
par erreur, veuillez le signaler
> a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques
etant susceptibles d'alteration,
> France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme
ou falsifie. Merci.
> 
> This message and its attachments may contain confidential or privileged information that
may be protected by law;
> they should not be distributed, used or copied without authorisation.
> If you have received this email in error, please notify the sender and delete this message
and its attachments.
> As emails may be altered, France Telecom - Orange is not liable for messages that have
been modified, changed or falsified.
> Thank you.
> 
> 
> 
> 
> -- 
> With kind regards,
> 
> Robin Verlangen
> www.robinverlangen.nl
> 


Mime
View raw message