Global secondary indexes null partition key

Question

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

Answer

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:

Global secondary indexes null partition key

Contenuto pertinente