Dynamodb queries with more than one value for atribute

Question

How can I make a query using more than one value? For example, all users with last_name ["Doggett","Scully","Mulder"]

Example using boto.

    Table.create('users', 
        schema=[
            HashKey('id') # defaults to STRING data_type
        ], throughput={
            'read': 5,
            'write': 15,
        }, global_indexes=[
            GlobalAllIndex('LastnameTimeIndex', parts=[
                HashKey('last_name'),
                RangeKey('creation_date', data_type=NUMBER),
            ],
            throughput={
                'read': 1,
                'write': 1,
            }),
        ],
        connection=conn
   )

something like:

table = Table("users", connections=conn)
table.query_2(last_name__in=["Doggett","Scully","Mulder"], connection=conn)

Johnny Wu · Accepted Answer · 2015-04-01 00:55:06Z

3

Currently, the Query API doesn't support the IN condition as a KeyCondition. As suggested by Max, you'll need to make separate queries. You can also make the queries in parallel to improve performance.

If you want to use IN, you'll need to do a scan (or index scan in your example) instead.

answered Apr 1, 2015 at 0:55

Johnny Wu

8624 silver badges5 bronze badges

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

Comments

Max · Accepted Answer · 2015-03-24 05:55:57Z

1

You have to do three separate Queries. One for each last name.

answered Mar 24, 2015 at 5:55

Max

8,8465 gold badges35 silver badges46 bronze badges

Collectives™ on Stack Overflow

Dynamodb queries with more than one value for atribute

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related