title: com.datastax.driver.core.exceptions.InvalidQueryException: Invalid operator IN for PRIMARY KEY part
body: <p>I have cassandra 2.1.15. 
  I have this table </p>
  
  <pre><code>CREATE TABLE ks_mobapp.messages (
      pair_id text,
      belong_to text,
      message_id timeuuid,
      cli_time bigint,
      sender text,
      text text,
      time bigint,
      PRIMARY KEY ((pair_id, belong_to), message_id)
  ) WITH CLUSTERING ORDER BY (message_id DESC)
  </code></pre>
  
  <p>I was trying to delete multiple record as</p>
  
  <pre><code>        instances.getCqlSession().execute(QueryBuilder.delete()
                  .from(AppConstants.KEYSPACE, "messages")
                  .where(QueryBuilder.eq("pair_id", pairId))
                  .and(QueryBuilder.eq("belong_to", currentUser.value("userId")))
                  .and(QueryBuilder.in("message_id", msgId)));
  </code></pre>
  
  <p>I am getting error:</p>
  
  <pre><code>Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: Invalid operator IN for PRIMARY KEY part message_id
  </code></pre>
  
  <p>Then I tried:</p>
  
  <pre><code>        Session session = instances.getCqlSession();
          PreparedStatement statement = session.prepare("DELETE FROM ks_mobApp.messages WHERE pair_id = ? AND belong_to = ? AND message_id = ?;");
          Iterator&lt;String&gt; iterator = msgId.iterator();
          while(iterator.hasNext()) {
              try {
                  session.executeAsync(statement.bind(pairId, currentUser.value("userId"), UUID.fromString(iterator.next())));
              } catch(Exception ex) {
  
              }
          }
  </code></pre>
  
  <p>Its working nice. Is this the correct way? I can't use IN for same partition key ?</p>