Use a RDBMS
There is a reason constraints were created and why Cassandra doesn't have it
Sent from my iPhone
> On Mar 2, 2015, at 2:23 AM, Rahul Srivastava
> wrote:
>
> but what if i want to fetch the value using on table then this idea might fail
>
>> On Mon, Mar 2, 2015 at 12:46 PM, Ajaya
Please be clear on questions and spend some time on writing questions so
that other people know what you are trying to ask. I can't read your mind.
:)
Back to your question:
Assuming that you need to search based on the values of the unique column
then invert the index on auxiliary table. So inste
but what if i want to fetch the value using on table then this idea might
fail
On Mon, Mar 2, 2015 at 12:46 PM, Ajaya Agrawal wrote:
> Make a table for each of the unique keys. For e.g.
>
> If primary key for user table is user_id and you want the phone number
> column to be unique then create a
Make a table for each of the unique keys. For e.g.
If primary key for user table is user_id and you want the phone number
column to be unique then create another table wherein the primary key is
(phone_number, user_id). Before inserting to main table try to insert to
this table first with "if not
I want to make unique constraint in cassandra . As i want that all the
value in my column be unique in my column family ex: name-rahul phone-123
address-abc
now i want that in this row no values equal to rahul ,123 and abc get
inserted again on searching on datastax i found that i can achieve it b
