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.