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
>

Reply via email to