Unique constraint on field in spring data elasticsearch

Question

It is possible to create unique constraint in Spring Data Elasticsearch which is equal to @Column(unique = true) in RDBMS?

Unfortunately, @Field annotation does not have Unique param. Perhaps I could use @Id but what if there are other fields like username, email, ...?

Abacus · Accepted Answer · 2020-09-21 15:24:06Z

2

Their is no unique constraint in Elasticsearch. You can use your field as an _id like explained in this post : How to create unique constraint in Elasticsearch database?

Or you'll have to create a validator by yourself to test if the value exist with some term query.

Addition: Although the op_type parameter sent to Elasticsearch would provide this feature, there is currently no support for this flag in Spring Data Elasticsearch. There is an issue in Jira which you could upvote.

edited Sep 21, 2020 at 15:24

Abacus

19.6k7 gold badges54 silver badges71 bronze badges

answered Sep 21, 2020 at 13:41

Jaycreation

2,0891 gold badge15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unique constraint on field in spring data elasticsearch

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related