How to query for an entry that falls between start and end date - DynamoDB -
i new dynamodb, , had question how can find of live entries in dynamodb table. each entry in table has start , end date. confused on how can query entries current date falls between start , end date. ideas how can this?
i understand can have primary , range key. possible query other columns in entry?
each entry looks this:
id: xxxxxx startdate: 123456 // epoch time enddate: 334243 // epoch time
if not know hashkey of item(looks 'id' in case) way query dynamodb using full table scan.
you can table scan using multiple conditions, inefficient.
Comments
Post a Comment