CODEWITHSUNDEEP
node.jsamazon-web-servicesamazon-dynamodbnosql
Rajan Soni
Rajan Soni

Reputation: 173

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

enter image description here

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

Upvotes: 8

Views: 16259

Answers (3)

kimmiju
kimmiju

Reputation: 161

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.

Upvotes: 14

ketan vijayvargiya
ketan vijayvargiya

Reputation: 5659

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.

Upvotes: 7

Mark B
Mark B

Reputation: 200501

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

Upvotes: 0

Related Questions