On Fri, Apr 23, 2010 at 3:32 PM, Robert <keyboard.opera...@gmail.com> wrote: > I am starting out with Cassandra and I had a couple of questions, I read a > lot of the documentation including: > http://arin.me/blog/wtf-is-a-supercolumn-cassandra-data-model > First I wanted to make sure I understand this > bug: http://issues.apache.org/jira/browse/CASSANDRA-598 > Borrowing from the the example provided in that article, would an example > subcolumn be 'friend1' or 'street'?
friend1 is the name a a supercolumn; street is the name of a subcolumn > Second, for a one to many map where ordering is not important what are the > tradeoffs between these two options? > > A. Use a ColumnFamily where the key maps to an item id, and in each row each > column is one of the items it is mapped to? > > B. Use SuperColumnFamily where each key is an item id, and each column (are > these the right terms?) is one of the items it is mapped to, and the value > is essentially empty? I don't see what using supercolumns gives you here, so don't use them. :) -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassandra support http://riptano.com
