By using AWS re:Post, you agree to the AWS re:Post Terms of Use

Global secondary indexes null partition key

0

Hi,
I've been digging around but I don't seem to find anything that could help me.
Basically, I created an index for my table and I'd like to keep adding objects to the original table even if the index partition key (let's call it index_id) is not specified. It does not seem possible, yet when I created the index, some of the previous items did not have index_ids and they were just ignored by the index. Is there a way to do this for future items added to the table ?

Thanks

asked 7 years ago4.1K views
1 Answer
0

Hi mszniber,

"For any item in a table, DynamoDB will only write a corresponding entry to a global secondary index if the index key value is present in the item. For global secondary indexes, this is the index partition key and its sort key (if present). If the index key value(s) do not appear in every table item, the index is said to be sparse."

That is to say, if the item does not have the attribute which you choose to be the partition key of your GSI, it will not show in your GSI table.

Please refer to the following link regarding this for more details:
http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GuidelinesForGSI.html#GuidelinesForGSI.SparseIndexes

AWS
answered 7 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions