Hi, I am using Cassandra 0.8.5, Hector 0.8.0-2 and cqlsh (cql 1.0.3). If I define a CF with comparator LongType like this:
BasicColumnFamilyDefinition columnFamilyDefinition = new BasicColumnFamilyDefinition(); columnFamilyDefinition.setKeyspaceName("XXX"); columnFamilyDefinition.setName("YYY"); columnFamilyDefinition.setDefaultValidationClass(_BYTESTYPE); columnFamilyDefinition.setMemtableOperationsInMillions(0.1); columnFamilyDefinition.setMemtableThroughputInMb(40); columnFamilyDefinition.setComparatorType(ComparatorType.LONGTYPE); try { cluster.addColumnFamily(new ThriftCfDef(columnFamilyDefinition)); } catch(HectorException e) { throw e; } Then I put some data in the CF. The I try to do the following queries in cqlsh: use XXX; select * from YYY where KEY='aaa'; nothing is returned! If I however do: select * from YYY; all the results are returned propperly! So I have 2 questios: 1) Can I read with CQL if CFs were defined using the basic API? (the fact that select * from YYY; works suggests that this is possible) 2) If yes, what is the correct query to use to read data with CQL? (I suspect KEY is wrong...is there a default?) Cheers, Alex