What do you mean by "index on column_value" ? Do you mean secondary index ?
On Wed, Apr 23, 2014 at 4:52 PM, Sebastian Schmidt <isib...@gmail.com>wrote: > 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>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 >> > > >
