I'm not much advanced in cassandra, but seeing the pycassa doc
http://pycassa.github.com/pycassa/assorted/composite_types.html, for
composites you can't even search for the second term, you need a first
term, the second will filter, you just do range slices on the composite
columns
it's totally different from secondary indexes for the rows
also CQL can't do everything as much as the other clients
2012/5/24 Roland Mechler <rmech...@sencha.com>
> Suppose I have a table in CQL3 with a 2 part composite, and I do a select
> that specifies just the second part of the key (not the partition key),
> will this result in a full table scan, or is the second part of the key
> indexed?
>
> Example:
>
> cqlsh:"Keyspace1"> CREATE TABLE test_table (part1 text, part2 text, data
> text, PRIMARY KEY (part1, part2));
> cqlsh:"Keyspace1"> INSERT INTO test_table (part1, part2, data) VALUES
> ('1','1','a');
> cqlsh:"Keyspace1"> SELECT * FROM test_table WHERE part2 = '1';
> part1 | part2 | data
> -------+-------+------
> 1 | 1 | a
>
> -Roland
>
>
>
