title: Cassandra Hector -- In query not working
body: <p>I am exploring a bit on cassandra cql queries . I have cassandra 1.0 installed and using hector java api . 
  I get an exception like this :-</p>
  
  <pre><code>me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(why:line 1:99 extraneous input ')' expecting EOF)
      at me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(ExceptionsTranslatorImpl.java:50)
      at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:127)
      at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:94)
      at me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.java:101)
      at me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:232)
      at me.prettyprint.cassandra.model.ExecutingKeyspace.doExecuteOperation(ExecutingKeyspace.java:97)
      at me.prettyprint.cassandra.model.CqlQuery.execute(CqlQuery.java:93)
      at CassandraBulkUpload.inComplexQuery(CassandraBulkUpload.java:80)
      at CassandraBulkUpload.&lt;init&gt;(CassandraBulkUpload.java:60)
      at BulkDataLoadExample.main(BulkDataLoadExample.java:22)
  Caused by: InvalidRequestException(why:line 1:99 extraneous input ')' expecting EOF)
      at org.apache.cassandra.thrift.Cassandra$execute_cql_query_result.read(Cassandra.java:30983)
      at org.apache.cassandra.thrift.Cassandra$Client.recv_execute_cql_query(Cassandra.java:1708)
      at org.apache.cassandra.thrift.Cassandra$Client.execute_cql_query(Cassandra.java:1682)
      at me.prettyprint.cassandra.model.CqlQuery$1.execute(CqlQuery.java:100)
  </code></pre>
  
  <p>I am trying to run this query:-</p>
  
  <pre><code>CqlQuery&lt;String, String, String&gt; cqlQuery = new CqlQuery&lt;String, String, String&gt;(HFactory.createKeyspace("largedata",cluster),stringSerializer,stringSerializer,stringSerializer);
              String  cql= "SELECT BookTitle FROM book WHERE isbn in((SELECT id FROM book b where year_of_publication='\"1999\"'))";
      cqlQuery.setQuery(cql);
          QueryResult&lt;CqlRows&lt;String, String, String&gt;&gt; result = cqlQuery.execute();
  </code></pre>
  
  <p>I have also created a secondary index on year_of_publication .
  Can anyone please tell if cql cassandra queries does not support the above mentioned one ?</p>