title: DynamoDB query with Comparison Operators
body: <p>Amazon AWS DynamoDB question.</p>
  
  <p>Are there any examples of using RangeKeyCondition and ComparisonOperators such as CONTAINS, IN, BETWEEN. I am trying to retrieve data based on a composite RangeKey (concatenated and delimited). For example date +author+keywords for books table. Assume the HashValue is "book" in this case (it can be book,dvd,video,link etc). I would like to select all books that contain a the keyword "magic" or all books by author "John Doe". A sample record/item would look like this:</p>
  
  <p>Hash------Range----------------------------------------------------------------- attribute1 ... attributex</p>
  
  <p>book------2012-1-20~john doe~adventure~magic~travel----------------description ... some stuff</p>
  
  <p>In trying to use the conditional operator IN or CONTAINS , I get the following error:
  object(CFSimpleXML)20
  public '__type' => string 'com.amazon.coral.validate#ValidationException' (length=45)
  public 'message' => string 'Attempted conditional constraint is not an indexable operation'</p>
  
  <p>Couldn't find any examples using these ComparisonOperators. Any help would be greatly appreciated.</p>
  
  <p>Thanks.</p>