python – DynamoDB : The provided key element does not match the schema

python – DynamoDB : The provided key element does not match the schema

The following applies to the Node.js AWS SDK in the AWS Lambda environment:

This was a rough one for me. I ran into this problem when trying to use the getItem method. No matter what I tried I would continue to receive this error. I finally found a solution on the AWS forum: https://forums.aws.amazon.com/thread.jspa?threadID=208820

Inexplicably, the apparent solution conflicts with all AWS documentation that I can find.

Here is the code which worked for me:

var doc = require(dynamodb-doc);
var dynamo = new doc.DynamoDB();

var params = { }
params.TableName = ExampleTable;
var key = { ExampleHashKey: 1 };
params.Key = key;

dynamo.getItem(params, function(err, data) {
    if (err)
        console.log(err);
    else
        console.log(data)
});

To query on fields which are not the hash key you need to use a Global Secondary Index (GSI). Take a look at this AWS Post for more details on GSIs.

UPDATE Feb 2015: It is now possible to add a GSI to an existing table. See the Amazon Docs for more details.


Sadly you cannot add a GSI to an existing DynamoDB table so youll need to create a new table and port your data if this is something you really need to query on.

From the DynamoDB FAQ:

Q: How do I create a global secondary index for a DynamoDB table?

All GSIs associated with a table must be specified at table creation
time. At this time, it is not possible to add a GSI after the table
has been created. For detailed steps on creating a Table and its
indexes, see here. You can create a maximum of 5 global secondary
indexes
per table.

If you do not want to port your data you could consider creating a second DynamoDB table with the email as a hash key and the hash of the parent record to use as a lookup into your main data table but as you can imagine this isnt exactly an optimal solution and it comes with its own headaches of keeping it in synch with your master table.

python – DynamoDB : The provided key element does not match the schema

I also got this error when I was sending a string instead of an integer.

Of course, this was when I was writing to the database, rather than reading from.

Leave a Reply

Your email address will not be published.