3
votes

I must change the Key Schema of a DynamoDB table. In in the official documentation it is clearly written that:

You cannot add, modify or delete indexes using UpdateTable. Indexes can only be defined at table creation time.

I was thinking of creating a new table (with the correct indexes) and migrating the data from the existing to the new one. Is there any tool that I can use for that? I have used DynamoDBtoCSV but it only supports export.

1
how much data are we talking here? what's the size of the current table? - Chen Harel
@ChenHarel 2 million records - Adam Siemion

1 Answers

2
votes

You could do this with EMR and Hive.

See the Export, Import, Query, and Join Tables in DynamoDB Using Amazon EMR walk throu from the Amazon EMR Developer Guide.