incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "R. Verlangen" <ro...@us2.nl>
Subject Re: Bad Request: No indexed columns present in by-columns clause with "equals" operator
Date Tue, 24 Apr 2012 12:06:51 GMT
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