Re: Modeling Master Tables in Cassandra

2016-02-12 Thread Carlos Alonso
Hi Hari. I'd suggest having a customers table like this: CREATE TABLE customers ( customerid UUID, name VARCHAR, email VARCHAR, phonenr VARCHAR, PRIMARY KEY(name, email, phonenr) ). This way your inserts could be INSERT INTO customers (customerid, ...) VALUES (...) IF NOT EXISTS;

Re: Modeling Master Tables in Cassandra

2016-02-12 Thread Harikrishnan A
Thanks Carlos...This certainly helps.. Sent from Yahoo Mail on Android On Fri, Feb 12, 2016 at 2:02 AM, Carlos Alonso wrote: Hi Hari. I'd suggest having a customers table like this: CREATE TABLE customers (  customerid UUID,  name VARCHAR,  email VARCHAR,  phonenr