I tried to create a super column family with second index.
create column family messages with column_type=Super and comparator=TimeUUIDType and subcomparator=UTF8Type and key_validation_class=UTF8Type and default_validation_class=UTF8Type
and column_metadata=[
{column_name : message, validation_class : UTF8Type},
{column_name : message_type, validation_class : UTF8Type, index_type : KEYS}
];
However, cassandra always complains "internal-system-column-family" error.
I tried to create a column family (not super) with secondary index, it is fine.
So, Does it mean secondary index is not support in super column family?
My cassandra version is: 0.8.1