incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DuyHai Doan <doanduy...@gmail.com>
Subject Re: Creating a CQL3 storage layout with row key, column key and column value
Date Wed, 23 Apr 2014 14:47:17 GMT
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 <isibboi@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
>

Mime
View raw message