Database Reference
In-Depth Information
Selecting the
BookTitle
attribute as
Hash Key
will populate the necessary
Range Key
at-
tributes. Can you guess why the
Language
range key is not populated? It's because
Lan-
guage
is the range key of the global secondary index, with hash key as
Publisher
. Since
the
Publisher
hash key is not selected (and
BookTitle
is selected), the
Language
attrib-
ute is not loaded.
Additionally we can specify whether the query should return only the projected attributes
or all the attributes of the index using the
Attributes
radio button, as shown in the previ-
ous screenshot.
Selecting
Publisher
from the
Hash Key
dropdown will populate only the
Language
at-
tribute in the
Range Key
dropdown. This is because
Publisher
is a hash key only in the
global index, whereas in the local index and table index
BookTitle
is the hash key. This is
the rule of thumb.
It is also possible for us to specify the sorting order of the query result by using the
Sort
radio button, as shown in the previous screenshot. Clicking on the
Query
radio button
will fetch us the result.
As soon as the result is displayed and if we select an item, the following options will ap-
pear to work on the item. The first button,
New Item
, will help us to put an item into the
