I don't know whether I'm wrong or not (I'm also new to Cassandra). But looks like we only can query a single Super Column at a single query since these values are specified in the ColumnParent parameter. Which means that you only can query a single week or month (as your super column).
From: Philippe [mailto:watche...@gmail.com] Sent: Monday, April 12, 2010 7:31 AM To: user@cassandra.apache.org Subject: Two dimensional matrices Hello, I would like to know if the following is indeed possible with Cassandra, from my understanding of key & column slices it is but I am just beggining to get my head around Cassandra... I have data that is two dimensional, time varying (think of a grid). At each cell of this grid,I store a binary array. My data model will be * single keyspace * key = {Y dimension} * super column family = {type of data represented in each cell} * super column = {time = week or month} * column ={X dimension} * value = { binary} Will I be able to retrieve all values from a rectangle from this grid in a single call to cassandra for given SCF and SC ? Will the result associate each value with its key and column ? Does it matter if it's a single call performance wise ? Thanks Philippe
