DynamoDB : Is it possible to query by hash and range without creating two tables?

Question

If I want to create a DynamoDB table with ItemId and BatchId and I want to be able to query by ItemId and BatchId do I have to create two tables:

Table1: Hash-ItemId Range-BatchId
Table2: Hash-BatchId Range-ItemId

Or is there a way to use secondary indexes to avoid duplication?

A few questions: what exactly do you mean by avoid duplication? Does an ItemId correspond to a bunch of BatchIds? — mkobit
– mkobit, Commented Jan 14, 2015 at 2:36
Yes each itemID will be in multiple batches. And each batchId will have multiple itemIDs — Nickolay Kondratyev
– Nickolay Kondratyev, Commented Jan 14, 2015 at 18:33
you mean that a) a query by itemId should result in multiple item+batch elements. and b) a query by batch should result in multiple batch+item elements? (item+batch=batch+item) — Chen Harel
– Chen Harel, Commented Jan 15, 2015 at 18:21

Erben Mo · Accepted Answer · 2015-01-16 01:03:33Z

1

how about a global secondary index on Table1 with BatchId as hash key?

Reopen because I think this answer is useful. Please correct me instead of closing the answer. @rfornal @Devin.

Hey @Nickolay I saw your comments below. Range key of base table CAN be used as hash key of GSI.

To prove that I created a table like this:

Base table: HashKey: hash + RangeKey:range

GSI table: HashKey: range + Rangekey: hash

Inserted some keys: enter image description here

query base table: enter image description here

query gsi: enter image description here

edited Jan 16, 2015 at 1:03

answered Jan 13, 2015 at 20:35

Erben Mo

3,6643 gold badges24 silver badges34 bronze badges

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

2 Comments

Nickolay Kondratyev Over a year ago

I thought I saw somewhere in the documentation that to perform Query operation you must have range key (struggling to find it right now).Then wouldn't I have to duplicate the ItemId as secondary global index since I can't make the range key a global secondary index? Table1: Hash-BatchId Range-ItemId SecondaryGlobalIndex-ItemId If we can query a table that has a Hash and GlobalSecondary Index (without range key) then this solution would in fact work

bob-fornal Over a year ago

This looks like a comment, rather than an attempt at answering the question.

Collectives™ on Stack Overflow

DynamoDB : Is it possible to query by hash and range without creating two tables?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related