cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Duncan Sands <duncan.sa...@gmail.com>
Subject Re: Why and How I didn't get the result back in cqlsh
Date Thu, 26 Feb 2015 02:55:04 GMT
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.

Mime
View raw message