Hi Jonathan, Thanks for the hint. I've tried it but it throws an error like this:
[defa...@keyspace1] update column family Standard1 with column_metadata=[{ column_name:user, index_type:0, validation_class:UTF8Type, index_name:Standard1Idx }] and rows_cached=100; Internal error processing system_update_column_family Is there anything wrong with the syntax? I can not figure out what is wrong with it using the error message. Thanks for your help. Kind regards, Joshua. On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jbel...@gmail.com> wrote: > It's part of "update column family:" > > [defa...@unknown] help update column family; > ... > - column_metadata: Metadata which describes columns of column family. > Supported format is [{ k:v, k:v, ... }, { ... }, ...] > Valid attributes: column_name, validation_class (see comparator), > index_type (integer), index_name. > > example: > update column family Foo with column_metadata=[{ column_name:Test, > validation_class:IntegerType, index_type:0, index_name:IdxName}] and > rows_cached=100 and comment='this is helpful comment.'; > > > On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jpart...@scrum8.com> > wrote: > > Hi there, > > > > How do I set an index on a column in cassandra 0.7? > > > > This is what I am trying to do: > > [defa...@keyspace1] get Standard1 where user = 'jpartogi'; > > No indexed columns present in index clause with operator EQ > > > > > > I can not find this in the CLI help nor the wiki. Maybe I am not looking > > hard enough? > > > > Thanks heaps for your help > > > > -- > > http://twitter.com/jpartogi > > > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of Riptano, the source for professional Cassandra support > http://riptano.com > -- http://twitter.com/jpartogi