Hi,

On 26/02/15 01:24, java8964 wrote:
...
select * from "myTable";
   59 |  336 | 1100390163336 | A |
[{"updated_at":1424844362530,"ids":"668e5520-bb71-11e4-aecd-00163e56be7c"}]
   59 |  336 | 1100390163336 | D |
[{"updated_at":1424844365062,"ids":"668e5520-bb71-11e4-aecd-00163e56be7c"}]

Obviously, the table has lots of data. Now the problem is I cannot get any data
back in my query using key of existing data. Why?

cqlsh:mykeyspace> select * from "myTable" where key=59 and key2=336;
cqlsh:mykeyspace> select * from "myTable" where "key"=59 and "key2"=336;

try at a higher consistency level, eg first do this in cqlsh:
  CONSISTENCY ALL;
then try your queries. If that works then the issue is that some replicas are missing data. The default cqlsh consistency level is ONE.

Best wishes, Duncan.

Reply via email to