Dynamodb query - OR condition in KeyConditionExpression

Question

I have a DynamoDB table with feed_guid as the global secondary index. I want to query with a set of feed_guid in that table. Since feed_guid is not my primary keys, I can't use getBatchItem. When I tried the following method, I got this error:

Invalid operator used in KeyConditionExpression: OR

    $options = array(
                'TableName' => 'feed',
                    'IndexName' => 'GuidIndex',
                    'KeyConditionExpression' => 'feed_guid = :v_guid1 or feed_guid = :v_guid2',

                    'ExpressionAttributeValues' =>  array (
                        ':v_guid1' => array('S' => '8a8106e48bdbe81bf88d611f4b2104b5'),
                        ':v_guid2' => array('S' => '19cab76242a6d85717de64fe4f8acbd4')
                    ),
                    'Select' => 'ALL_ATTRIBUTES',
                );
                $response = $dynamodbClient->query($options);

score 11 · Answer 1 · edited Apr 19 '20 at 16:41

11

You can't use OR condition. You should use

rangeAttributeName BETWEEN :rangeval1 AND :rangeval2

if possible or

feed_guid IN (:v_guid1, :v_guid2)

See ExpressionAttributeValues and KeyConditionExpression

edited Apr 19 '20 at 16:41

skwidbreth

7,888
11
58
105

answered Aug 19 '15 at 15:50

user1697575

2,830
1
24
37

20

This is not working. It shows "Invalid operator used in KeyConditionExpression: IN" error. – Arun SS Aug 19 '15 at 15:56
Try using between. IN is used for ExpressionAttributeValues – user1697575 Aug 19 '15 at 15:57
Just read the definition first. http://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Query.html#DDB-Query-request-KeyConditionExpression – Arun SS Aug 19 '15 at 16:51
Yes. documentation says only AND supported for ranges. There is no OR. Also you could try using begins_with – user1697575 Aug 19 '15 at 16:58
2

As far as I can tell, there's no support for either `OR` or `IN` when using `KeyConditionExpression` -- not when using the Query API, anyway. – Mass Dot Net Sep 11 '20 at 14:52
What if instead of 2 values you have 20? How would you use between for 20 values? – Kappacake Feb 02 '23 at 17:08
@Kappacake feed_guid IN (:v_guid1, :v_guid2, :v_guid3 ...) – user1697575 Feb 02 '23 at 21:44
@user1697575 IN is not supported in KeyConditionExpression – Kappacake Feb 03 '23 at 08:43

score 8 · Answer 2 · answered Aug 20 '15 at 00:51

8

In order to achieve what you want here, you'll need to take the union of two separate queries.

Currently, DynamoDB's Query API only supports having one condition on Hash AND Range Keys in only the KeyConditionExpression because this limits the items you search and ultimately reduces cost of say a more complex query like what you've described here.

answered Aug 20 '15 at 00:51

Raymond Lin

491
2
5

12

Can you please give an example "How to use union of queries?" Every where in Amazon documentation they have described theoretically. – TheTiger May 12 '16 at 09:40
2

They wrote "union of two **separate** queries" (my emphasis) I.e. you should make two separate queries and combine the results – chrisbunney Jun 26 '20 at 12:28

Dynamodb query - OR condition in KeyConditionExpression

2 Answers2

Linked