http://www.datastax.com/support-forums/topic/does-cassandra-support-index-into-a-subcolumn-in-a-composite-column-if-so-how Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 09:51:58 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/does-cassandra-support-index-into-a-subcolumn-in-a-composite-column-if-so-how#post-8929 Tue, 05 Feb 2013 23:54:31 +0000 stanley@marketo.com 8929@http://www.datastax.com/support-forums/ <p>I have the following use case: assume there is a theater chain with thousands of theaters. Each day there are multiple movies playing in each theater. People go into the theater to see movies. Each viewer has 5 demographic attributes, such as age, income range, etc. </p> <p>I want to find out on each day for each theater, how many viewers are there for each movie, further broken down by one or several of the 5 demographic attributes. </p> <p>I have chosen to store the data as a CF, keyed by theaterId:date:movieId. Each column in the row is a composite column whose key are like attrib1:attrib2:attrib3:attrib4:attrib5:Viewer_i. I used valueless column. Does this design look right?</p> <p>My question is, does Cassandra support secondary index into each of the 5 demographic attributes appearing in the same composite column? That is, if my question is, given a theater, find all viewers whose value for attrib2 matches given value, does Cassandra support indexing on attrib2? If so, what is the syntax (through API or CQL3)?</p> <p>Also, is this Jira <a href="https://issues.apache.org/jira/browse/CASSANDRA-3680" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-3680</a> about the same question I asked here?</p> <p>Thanks, </p>