Here is one use case .. We are designing a web application using Cassandra. When a user signs on we create user info in user table with userid (uuid) is primary and is responded back to UI.
UI uses this UUID for any future communications. UI can also get user id when searched for an user detail in "search" (achieved by Solr). Thanks, Jay On Mon, Nov 23, 2015 at 11:08 AM, Prem Yadav <ipremya...@gmail.com> wrote: > Hi, > > I am trying to understand different use cases related to using UUID as the > partition key. I am sure I am missing something trivial and will be > grateful and you can help me understand this. > > When do you use the UUID as the primary key? What can be a use case? > Since it is unique, how do you query it? > > Let's take a user table with UUID as primary key. > > create table user (id uuid primary key, name varchar,company > varchar,country varchar); > > Now I can write to the table using the uuid() function to generate the > uid. But how do you query it? > The only use case I see is create a secondary index and use that for > querying. > > Am I missing something here? > > Thanks, > Prem >
