cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eldad Yamin <elda...@gmail.com>
Subject Re: Schema advice: (Single row or multiple row!?) How do I store millions of columns when I need to read a set of around 500 columns at a single read query using column names ?
Date Mon, 23 Jul 2012 16:37:38 GMT
in addition, if you don't know how many rows will be needed - in each row,
you can store the key of the next one.
Just like in a linked list.

OR

have 1 row that will hold all the keys that combining your other rows.
1st select the main row (with the keys), then select the other rows.



On Mon, Jul 23, 2012 at 3:40 PM, rohit bhatia <rohit2412@gmail.com> wrote:

> You should probably try to break the one row scheme to
> 2*Number_of_nodes rows scheme.. This should ensure proper distribution
> of rows and still allow u to query from a few fixed number of rows.
> How u do it depends on how are u gonna choose ur 200-500 columns
> during reading (try having them in the same row)
>
> Even if u r forced to put them in seperate rows, u can make the row
> key as "some modulus of hash of column name", ensuring symmetry and
> easy access of columns...
>
> On Mon, Jul 23, 2012 at 6:02 PM, Ertio Lew <ertiop93@gmail.com> wrote:
> > Any ideas/suggestions please?
>

Mime
View raw message