no viable alternative at character ']' when updating columnfamily

Question

I'm new to Cassandra, but am trying to update a column family to have secondary indexes on some of the columns. After creating my column family, I run the following line of code:

db.ExecuteNonQuery("UPDATE COLUMN FAMILY Targets with comparator = UTF8Type and column_metadata=[{column_name: Age, validation_class: UTF8Type, index_type: KEYS}];");

The problem is I get the following error:
line 1:141 no viable alternative at character ']'

I can run that exact statement using the CLI without any issues.

Suggestions?

score 3 · Accepted Answer · answered Jul 25 '12 at 19:41

3

Looks like I need to use CQL when running ExecuteNonQuery: http://www.datastax.com/docs/0.8/dml/using_cql

answered Jul 25 '12 at 19:41

Ryan Caskey

607
8
20

no viable alternative at character ']' when updating columnfamily

1 Answers1