Sophie

Sophie

distrib > Mageia > 7 > i586 > by-pkgid > dd7204292d310452063d09b5de9c13b7 > files > 622

aws-cli-docs-1.16.163-1.mga7.noarch.rpm

**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
  }