return item with maximum sort-key in dynamodb

Question

I'm using a python script to access a dynamodb database in AWS.

I have a table with a hash key and sort key.

For a given hash key, I want to find the item with the largest sort key that is less than a certain value. How can I do that?

Alternatively, is there a way to find the previous item from a given key?

I am not trying to find the item with the largest attribute value (an expensive task in dynamodb), I want the largest key value.

falsePockets · Accepted Answer · 2017-02-28 23:54:09Z

12

I found the answer,

import boto3
import botocore
from boto3.dynamodb.conditions import Key, Attr


dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table(table_name)

response = table.query(
              Limit = 1,
              ScanIndexForward = False,
              KeyConditionExpression=Key('device').eq(device) & Key('epoch').lte(threshold)
           )

Where:

'device' is my hash key
'epoch' is my sort key
threshold is the value I want to search below

answered Feb 28, 2017 at 23:54

falsePockets

4,4237 gold badges26 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

return item with maximum sort-key in dynamodb

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related