title: Query dynamoDB with non hash key field (with boto / python)
body: <p>I'm using dynamoDB with boto, and having a bit of a problem in the design/query of my table.</p>
  
  <p>I'd like my data to look something like</p>
  
  <pre><code>+---------------------------------------+
  hash_key    account_id    mykey
  -----------------------------------------
  1           12345         myvalue1
  2           12345         myvalue2
  3           12345         myvalue3
  4           123456        myvalue4
  +---------------------------------------+
  </code></pre>
  
  <p>And then retrieve all data for account 12345. Looking at the boto docs, I always need to have the hash_key available. I know how I would query this standard SQL / MongoDB, but I can't find a solution for boto. I assume this is possible? Thanks!</p>
  
  <p><strong>EDIT: This seems to work</strong></p>
  
  <pre><code>+---------------------------------------+
  hash_key    range_key    mykey
  -----------------------------------------
  12345       12568        myvalue1
  12345       53890        myvalue2
  12345       12322        myvalue3
  123456      23432        myvalue4
  +---------------------------------------+
  </code></pre>
  
  <p>Followed by </p>
  
  <pre><code>&gt; res = table.query(hash_key='12345')
  &gt; for item in res:
  &gt;    print i
  </code></pre>
  
  <p>Since I want to grab all the entries with account # 12345, regardless of the range_key, I need to <strong>query</strong> instead of <strong>get_item</strong></p>