Hi Prem, We have two tables, one with email id as partition key and other with userid(uuid). Please refer to www.killrvideo.com website. It is a great place to understand how a web application is built on Cassandra.
Thanks, Jay On Mon, Nov 23, 2015 at 11:18 AM, Prem Yadav <ipremya...@gmail.com> wrote: > Thanks Jay. Now this is great while creating the user. How does the user > change the details? let's say email id or password? How do you lookup the > user table? > > > On Mon, Nov 23, 2015 at 4:14 PM, Jay Reddy <jayreddy...@gmail.com> wrote: > >> 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 >>> >> >> >
