Why does inserting a vertex with the same property not throw an error in DSE Graph?

Question

I am using Dse graph version 5.x.

I have created a schema using Dse studio which uses gremlin query.

What I am trying to do is:

I want to index my graph based on vertex property called 'name'

Here is what I get when I do schema.describe()

Here is what I get when I do g.V()

As you can clearly see, I have index my vertex label type with property name.

But when I insert multiple vertex (of label type) with same name it accept it without error.

Ideally because of indexing it should show error on inserting vertex with same property `name'.

score 3 · Accepted Answer · answered Jan 12 '17 at 20:19

3

indexing in DSE Graph is a performance optimization operation not a Referential Integrity operation. Currently there is no mechanism that will "reject" creating a new index if one exists with the same property. We have this feature request on our roadmap. In the interim, it is possible to achieve "upsert" style semantics with DSE Graph by leveraging Custom IDs as described here - http://docs.datastax.com/en/latest-dse/datastax_enterprise/graph/using/createCustVertexId.html?hl=custom%2Cid

answered Jan 12 '17 at 20:19

jlacefie

614
3
5

when we can expect this feature – Prakash P Jan 13 '17 at 05:52
There is no timeline tied to this feature at this date. Note, you can achieve this behavior using the Graph Loader tool when executing bulk loading job.s – jlacefie Jan 24 '17 at 12:32

Why does inserting a vertex with the same property not throw an error in DSE Graph?

1 Answers1