Re: Creating a CQL3 storage layout with row key, column key and column value

[Sebastian Schmidt]

And now, when I create an index on column_value. Will the column_value 
still be stored with the column_key or will Cassandra create an extra 
column?
Am 23.04.2014 16:47, schrieb DuyHai Doan:
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 
<mailto: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