AWS Dynamodb: Is it possible to make a query only using sort key

Question

Hi dynamodb community,

So the table in question is MLA_USER_AUTH. As you see it has as partition key and as sort key. I want to be able to query the database using both user_id and email.

Sometimes I need to find the user associated with the email and sometimes the userid. Both email and userid attributes are unique for every visitor. is there any way it can be done?

This is my current query. This obviously doesnt work. As it throws the error: ValidationException: Query condition missed key schema element: UserID

var params = {
        TableName : 'MLA_USER_AUTH',
        KeyConditionExpression: "Email = :email",
        ExpressionAttributeValues:{
            ":email": { "S" : email } 
        }
    };
    dynamodb.query(params, function(err, data) {

Are GSIs my only option. Any help appreciated

Thanks, Ninjasoar

kimmiju · Accepted Answer · 2016-08-07 12:53:28Z

14

A Secondary Index would do want you want.

// definition
{
    TableName: "MLA_USER_AUTH",
    AttributeDefinitions:[
    {
        AttributeName: "Email",
        AttributeType: "S"
    }
    ],
    GlobalSecondaryIndexUpdates: [
    {
        Create: {
            IndexName: "emailIndex",
            KeySchema: [
                {AttributeName: "Email", KeyType: "HASH"}
            ]
        }
    }
    ]
}

// Query
{
    TableName : "MLA_USER_AUTH",
    IndexName: "emailIndex",
    KeyConditionExpression: "Email = :email",
    ExpressionAttributeValues:{
        ":email": { "S" : email } 
    }
}

See http://docs.aws.amazon.com/amazondynamodb/latest/gettingstartedguide/GettingStarted.JsShell.06.html for more information on creating them.

answered Aug 7, 2016 at 12:53

kimmiju

1611 silver badge3 bronze badges

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

Comments

ketan vijayvargiya · Accepted Answer · 2016-06-03 15:41:14Z

7

As Mark B said, you need partition-key to query- you can't do it using sort-key alone.

So, the only way out for you is to create a GSI with email as the partition-key.

answered Jun 3, 2016 at 15:41

ketan vijayvargiya

5,6591 gold badge24 silver badges35 bronze badges

1 Comment

Kannaiyan Over a year ago

One can scan with those. I have not seen it scanned more than one record. I would recommend scanning with sort key and checkout performance.

Mark B · Accepted Answer · 2016-06-03 14:43:48Z

0

You can't query without the partition key, but you can scan. http://docs.aws.amazon.com/amazondynamodb/latest/gettingstartedguide/GettingStarted.NodeJs.04.html#GettingStarted.NodeJs.04.Scan

answered Jun 3, 2016 at 14:43

Mark B

203k27 gold badges339 silver badges332 bronze badges

Collectives™ on Stack Overflow

AWS Dynamodb: Is it possible to make a query only using sort key

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related