The schema you just showed allows, for one row key (partition key), to have several distinct pairs of column_key/column_value. And that's exactly what you want ...
On Wed, Apr 23, 2014 at 4:44 PM, Sebastian Schmidt <isib...@gmail.com>wrote: > Hi, > > I want to create a storage layout with CQL3 like this: > > row_key should be my row key > column_key should by my column key > column_value should be the value saved for the column key > > How can I achieve this? > > I figured that doing this: > > CREATE TABLE table_name (row_key BLOB, column_key BLOB, column_value BLOB, > PRIMARY KEY (row_key, column_key)); > > would make column value unique for each row key. > > But I want to store multiple key/value pairs per row. How can I do that > with CQL3? > > Kind regards, > Sebastian >