Indexes are not supported on sub columns. Also, you definition seems to mix standard and sub columns together in the CF. For a super CF all top level columns contain sub columns. Cheers
----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 Jul 2011, at 19:39, Andreas Markauskas wrote: > I couldn't find any schema example for the supercolumn column family > that is strongly typed. For example, > > create column family Super1 with comparator=UTF8Type and > column_type=Super and key_validation_class=UTF8Type and > column_metadata = [ > {column_name: username, validation_class:UTF8Type}, > {column_name: email, validation_class:UTF8Type, index_type: KEYS}, > {column_name: address, validation_class:UTF8Type, subcolumn_metadata = [ > {column_name: street, validation_class:UTF8Type}, > {column_name: state, validation_class:UTF8Type, index_type: KEYS} > ] > } > ]; > > Or does someone know a better method? I like to make it as painless as > possible for developers with a strongly typed schema so as to avoid > orphan data.
