// 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. >