Reader small image

You're reading from  DynamoDB Applied Design Patterns

Product typeBook
Published inSep 2014
Publisher
ISBN-139781783551897
Edition1st Edition
Right arrow

Querying tables


One of the most efficient ways of retrieving data from a DynamoDB table is by using the query operation on the table. One of the mandatory parameters or conditions to be provided while performing a query operation is performing a comparison operation on the primary key attribute value. The query operation supports the following comparison operations, namely:

  • EQ: This stands for equal to

  • LE: This stands for less than or equal to

  • LT: This stands for less than

  • GE: This stands for greater than or equal to

  • GT: This stands for greater than

  • BETWEEN: This retrieves items whose primary key value is between the specified values

  • BEGINS_WITH: This retrieves items whose primary key begins with the specified value

These seven comparison operations can be performed directly on primary key values, which will retrieve only the necessary items (without even bothering the partitions/items that don't have this value). There are six more comparison operations that can be performed on the items...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
DynamoDB Applied Design Patterns
Published in: Sep 2014Publisher: ISBN-13: 9781783551897