// user table: skinny partition
CREATE TABLE user (
user_id uuid,
firstname text,
lastname text,
....
PRIMARY KEY ((user_id))
);
// sensor_data table: wide partition
CREATE TABLE sensor_data (
sensor_id uuid,
date timestamp,
value double,
PRIMARY KEY ((sensor_id), date)
);
On Tue, Oct 18, 2016 at 5:07 PM, S Ahmed <sahmed1...@gmail.com> wrote:
> Hi,
>
> Can someone clarify how you would model a "wide" row cassandra table?
> From what I understand, a wide row table is where you keep appending
> columns to a given row.
>
> The other way to model a table would be the "regular" style where each row
> contains data so you would during a SELECT you would want multiple rows as
> oppose to a wide row where you would get a single row, but a subset of
> columns.
>
> Can someone show a simple data model that compares both styles?
>
> Thanks.
>
