find duplicates in gremlin

0
votes

I had data on AWS Neptune GraphDB. Every record in it has KeyId(property) with unique values. Some data got duplicated, which can be found through the KeyId(property) and groupCount() step. My question is, can I filter the values with groupCount() more than one. Or any other best way to find duplicates through key.

gremlin> g.V().has('keyId').groupCount().by('keyId')
==> [HJ001:2, HJ002:1,HJ003:1,HJ004:2,HJ005:3]

I need only the result having groupCount > 1. (but not count=1) could anyone help me with that.

1
gremlinamazon-neptune

1 Answers

3
votes

If you add to your query as follows this should give you what you want.

g.V().has('keyId').groupCount().by('keyId').
      unfold().where(select(values).is(gt(1)))

Cheers Kelvin