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