cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From java8964 <java8...@hotmail.com>
Subject RE: Why and How I didn't get the result back in cqlsh
Date Thu, 26 Feb 2015 03:07:05 GMT
Hi, Duncan:
Thanks for your reply, but it didn't help.
yzhang@yzhangmac1:~/dse/bin$ ./cqlsh hostname 9160 -u user -p passwordConnected to P2 QA Cluster
at xxx:9160.[cqlsh 3.1.2 | Cassandra 1.2.18.1 | CQL spec 3.0.0 | Thrift protocol 19.36.2]Use
HELP for help.cqlsh> use myKeyspace;cqlsh:myKeyspace > consistency all;Consistency level
set to ALL.cqlsh: myKeyspace> select * from "myTable" where "key"=59 and "key2"=336;cqlsh:
myKeyspace > select * from "myTable" where key=59 and key2=336;cqlsh: myKeyspace >
This table in fact was created by old column family way in Cassandra 1.1, using composite
key and composite column names.After we upgrade to Cassandra 1.2, you can see the column name
in CQL comes from the Cassandra. So this table is NOT created in CQL.
I think it maybe due to the column name "key" is a reserved word. But even I quote it like
"key" in the CQL query, it still didn't help.
> Date: Thu, 26 Feb 2015 03:55:04 +0100
> From: duncan.sands@gmail.com
> To: user@cassandra.apache.org
> Subject: Re: Why and How I didn't get the result back in cqlsh
> 
> 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