boto3 dynamodb IN condition

Question

I am reading official docs http://boto3.readthedocs.io/en/latest/_modules/boto3/dynamodb/conditions.html

You can create a condition like this:

Attr(key).eq(value)

Where you check if value equals to key's value using class Attr() with eq method.

But how do you use a SQL IN operator?

I would like to query if value IN key's value

At the docs it just appear an In class and I dont see any example or how to use it

class In(ComparisonCondition):
    expression_operator = 'IN'
    has_grouped_values = True

notionquest · Accepted Answer · 2017-10-19 12:14:19Z

2

Operator IN cannot be used in KeyConditionExpression i.e. to get multiple hash key values using Query API. DynamoDB doesn't support this feature at the moment.

If you need to retrieve multiple hash key values, please use Batch Get Item api.

Sample code:-

email1 = "[email protected]"
email2 = "[email protected]"

try:
    response = dynamodb.batch_get_item(
    RequestItems={
        'users': {
            'Keys': [
                {
                    'email': email1
                },
                {
                    'email': email2
                },
            ],            
            'ConsistentRead': True            
        }
    },
    ReturnConsumedCapacity='TOTAL'
)
except ClientError as e:
    print(e.response['Error']['Message'])
else:
    item = response['Responses']
    print("BatchGetItem succeeded:")
    print(json.dumps(item, indent=4, cls=DecimalEncoder))

answered Oct 19, 2017 at 12:14

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

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

3 Comments

Dan Over a year ago

Why is in included for boto3.dynamodb.conditions but DynamoDB does not support it yet?

Nadav Har'El Over a year ago

It seems to me, from docs.aws.amazon.com/amazondynamodb/latest/developerguide/…, that the "in" operator is support, and should be supported for example in a Scan (in its FilterExpression, not KeyConditions). If not, why not?

rayepps Over a year ago

@notionquest is saying "Operator IN cannot be used in KeyConditionExpression" - not that it can't be used at all. Dynamo can't use it to find items, however, it can be used to filter items. So, if you wanted, you could use it in FilterExpression or other forms of filtering.

Collectives™ on Stack Overflow

boto3 dynamodb IN condition

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related