You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Shravya Nethula <sh...@aline-consulting.com> on 2019/11/21 06:10:08 UTC
Support for Unique columns in Ignite
Hi,
I want to create a unique column in a table. Whenever an insert happens into that unique column, it should check for uniqueness and then insert accordingly.
So is there support for unique columns in Ignite?
Is there a direct support or atleast any work around through which I can achieve this functionality?
Regards,
Shravya Nethula,
BigData Developer,
[cid:e19953a7-275a-42e4-a694-dfb4eda34dbb]
Hyderabad.
Re: Support for Unique columns in Ignite
Posted by Shravya Nethula <sh...@aline-consulting.com>.
Hi Anton,
Thank you for the information.
Regards,
Shravya Nethula,
BigData Developer,
[cid:6447e351-fbb4-44f3-94f2-94b638753545]
Hyderabad.
________________________________
From: akurbanov <an...@gmail.com>
Sent: Thursday, November 21, 2019 5:23 PM
To: user@ignite.apache.org <us...@ignite.apache.org>
Subject: Re: Support for Unique columns in Ignite
Hello,
Unique constraints are not yet implemented in Ignite and I would assume they
won't be generally available soon enough.
The reasoning behind that is in general each put/insert is a distributed
insert/put. There are some circumstances under which this operation might
happen to be local: if cache is replicated or the constrained field is an
affinity key for a cache. Otherwise it is a cluster-wide constraint check
operation for each put/insert and might dramatically affect the overall
performance depending on cache size and cluster size which means that the
scalability is affected too.
Unique field might just be a part of primary key.
Best regards,
Anton
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Support for Unique columns in Ignite
Posted by akurbanov <an...@gmail.com>.
Hello,
Unique constraints are not yet implemented in Ignite and I would assume they
won't be generally available soon enough.
The reasoning behind that is in general each put/insert is a distributed
insert/put. There are some circumstances under which this operation might
happen to be local: if cache is replicated or the constrained field is an
affinity key for a cache. Otherwise it is a cluster-wide constraint check
operation for each put/insert and might dramatically affect the overall
performance depending on cache size and cluster size which means that the
scalability is affected too.
Unique field might just be a part of primary key.
Best regards,
Anton
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/