cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roland Mechler <rmech...@sencha.com>
Subject Composite keys question
Date Thu, 24 May 2012 17:54:30 GMT
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

Mime
View raw message