HEX
Server: LiteSpeed
System: Linux ip-172-31-76-142.ec2.internal 4.14.158-129.185.amzn2.x86_64 #1 SMP Tue Dec 24 03:15:32 UTC 2019 x86_64
User: 69b4844ae61d4e92bf26ad98af552775 (1065)
PHP: 7.2.27
Disabled: exec,passthru,shell_exec,system,eval
Upload Files
File: //proc/thread-self/root/lib/python2.7/site-packages/awscli/examples/dynamodb/query.rst
**To query an item**

This example queries items in the *MusicCollection* table. The table has a hash-and-range primary key (*Artist* and *SongTitle*), but this query only specifies the hash key value. It returns song titles by the artist named "No One You Know".

Command::

  aws dynamodb query --table-name MusicCollection --projection-expression "SongTitle" --key-condition-expression "Artist = :v1" --expression-attribute-values file://expression-attributes.json


The arguments for ``--expression-attribute-values`` are stored in a JSON file named ``expression-attributes.json``::

  {
    ":v1": {"S": "No One You Know"}
  }

Output::

  {
      "Count": 2,
      "Items": [
          {
              "SongTitle": {
                  "S": "Call Me Today"
              },
              "SongTitle": {
                  "S": "Scared of My Shadow"
              }
          }
      ],
      "ScannedCount": 2,
      "ConsumedCapacity": null
  }