Hi Jonathan,

Thanks for the hint. I've tried it but it throws an error like this:

[default@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,

On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jbellis@gmail.com> wrote:
It's part of "update column family:"

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

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 <jpartogi@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:
> [default@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