DynamoDB: Two document paths overlap with each other; must remove or rewrite one of these paths

Question

I have this update expression :

{
  "UpdateExpression": "SET #location = :location, #edited = :edited, #coordinates = :coordinates, #city = :city, #country = :country, #zipCode = :zipCode, #street = :street, coordinates = :coordinates",
  "ExpressionAttributeValues": {
    ":location": "Reston, VA",
    ":edited": true,
    ":coordinates": {
      "lat": 38.9586307,
      "lng": -77.35700279999999
    },
    ":city": "Reston",
    ":country": "US",
    ":zipCode": "20190",
    ":street": "11910 Market St"
  },
  "ExpressionAttributeNames": {
    "#location": "location",
    "#edited": "edited",
    "#coordinates": "coordinates",
    "#city": "city",
    "#country": "country",
    "#zipCode": "zipCode",
    "#street": "street"
  }
}

and I am getting this weird error

ERROR: ValidationException: Invalid UpdateExpression: Two document paths overlap with each other; must remove or rewrite one of these paths; path one: [coordinates], path two: [zipCode]

I couldn't find any information online and I can not see where the overlap. Any help will be appreciated.

score 10 · Accepted Answer · answered Feb 03 '20 at 16:09

10

coordinates is effectively in your expression twice.

answered Feb 03 '20 at 16:09

Jason Wadsworth

8,059
19
32

3

It is so obvious that I missed it. The error is misleading, as it mentions [zipCode] which made me look at the wrong cause. Thanks – super7egazi Feb 03 '20 at 16:17
I agree, it is misleading. Not sure why the `zipCode` thing is in there. – Jason Wadsworth Feb 03 '20 at 16:41
In my case it also barked about the wrong attrib on path two and path one was the duplicate. – MandoMando Mar 05 '21 at 17:04

DynamoDB: Two document paths overlap with each other; must remove or rewrite one of these paths

1 Answers1

Linked