One CQL row per user, keyed off of the UUID. Another table keyed off of email, with another column containing the UUID for lookups in the first table. Only registration will require a lightweight transaction, and only for the purpose of avoiding duplicate email registration race conditions.
-Tupshin On Jan 21, 2014 9:17 AM, "Drew Kutcharian" <d...@venarc.com> wrote: > A shameful bump ;) > > > On Jan 20, 2014, at 2:14 PM, Drew Kutcharian <d...@venarc.com> wrote: > > > > Hey Guys, > > > > I’m new to CQL (but have been using C* for a while now). What would be > the best way to model a users table using CQL/Cassandra 2.0 Lightweight > Transactions where we would like to have: > > - A unique TimeUUID as the primary key of the user > > - A unique email address used for logging in > > > > In the past I would use Zookeeper and/or Astyanax’s "Uniqueness > Constraint” but I want to see how can this be handled natively. > > > > Cheers, > > > > Drew > > >