AWS DynamoDB Error creating local secondary index

Question

I am creating a dynamoDB table with local secondary indexes. If I run below statement, it works fine.

aws dynamodb create-table                        \
    --table-name XYZ                             \
    --attribute-definitions                      \
        AttributeName=Id,AttributeType=N         \
        AttributeName=Name,AttributeType=S       \
    --key-schema                                 \
        AttributeName=Id,KeyType=HASH            \
        AttributeName=Name,KeyType=RANGE         \
    --provisioned-throughput                     \
        ReadCapacityUnits=5,WriteCapacityUnits=5 \
    --local-secondary-indexes                    \
        'IndexName=idx1,
         KeySchema=[{AttributeName=Id,KeyType=HASH},{AttributeName=Name,KeyType=RANGE}],
         Projection={ProjectionType=ALL}'

However, if I try to add additional attribute by using this below statement:

aws dynamodb create-table                        \
    --table-name XYZ                             \
    --attribute-definitions                      \
        AttributeName=Id,AttributeType=N         \
        AttributeName=Name,AttributeType=S       \
        AttributeName=Gender,AttributeType=S     \
    --key-schema                                 \
        AttributeName=Id,KeyType=HASH            \
        AttributeName=Name,KeyType=RANGE         \
    --provisioned-throughput                     \
        ReadCapacityUnits=5,WriteCapacityUnits=5 \
    --local-secondary-indexes                    \
        'IndexName=idx1,
         KeySchema=[{AttributeName=Id,KeyType=HASH},{AttributeName=Name,KeyType=RANGE}],
         Projection={ProjectionType=ALL}'

I receive below error message:

when calling the CreateTable operation: One or more parameter values 
were invalid: Some AttributeDefinitions are not used. 
AttributeDefinitions: [Id, Name, Gender], keys used: [Id, Name]

Any advise on how to resolve it.

velimir · Accepted Answer · 2018-05-11 07:58:40Z

2

Attribute definition can only include list of attributes, that are used for indexes/key schema. If you do not use Gender for indexes or key schemas, there's no need to mention it in attribute definitions section.

answered May 11, 2018 at 7:58

velimir

12912 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AWS DynamoDB Error creating local secondary index

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related