Question

我有以下关于DynamoDb表的全球二级指数,该表在使用表时显示:

 "GlobalSecondaryIndexes": [
        {
            "IndexSizeBytes": 14339252, 
            "IndexName": "Id-AddedOn-index", 
            "Projection": {
                "ProjectionType": "INCLUDE", 
                "NonKeyAttributes": [
                    "AgentId, TicketId, TotalSecondsSinceOpen"
                ]
            },

然而,当我使用这一指数执行“财富”时,我提出了以下例外:

 (One or more parameter values were invalid: Global secondary index Id-AddedOn-index does not project [TicketId, AgentId, TotalSecondsSinceOpen])

很显然,描述表显示它们,但有一个问题未能收回。我做了什么错误?

而且,当我问一下AWS表格中使用该指数标出的项目时,这些田地也不存在。

Answer 1

"NonKeyAttributes" must be given a list of strings. Change your definition to the following and your GSI will project those attributes properly.

"GlobalSecondaryIndexes": [
    {
        "IndexSizeBytes": 14339252, 
        "IndexName": "Id-AddedOn-index", 
        "Projection": {
            "ProjectionType": "INCLUDE", 
            "NonKeyAttributes": [
                "AgentId", "TicketId", "TotalSecondsSinceOpen"
            ]
        },

Answer 2

使用“投影器”: 全球二级指数中的“所有”

友情链接