incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Rhoden <jacob.rho...@me.com>
Subject Re: Create an index on CQL table
Date Fri, 08 Nov 2013 02:52:48 GMT


> On 8 Nov 2013, at 12:54 pm, Techy Teck <comptechgeeky@gmail.com> wrote:
> 
> I am using the below table in our use case - 
> 
> create table testing1 (
>     employee_id text,
>     employee_name text,
>     value text,
>     last_modified_date timeuuid,
>     primary key (employee_name,last_modified_date)
>    );

Before considering secondary keys, what's the reason for this primary key?

1. What happens if two employees have the same name?

2. Why is last_modified_date in the primary key?



Mime
View raw message