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