cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Evans <eev...@rackspace.com>
Subject Re: CQL COUNT Not Accurate?
Date Fri, 22 Jul 2011 21:51:46 GMT
On Fri, 2011-07-22 at 14:18 -0700, Hefeng Yuan wrote:
> Hi,
> 
> I just noticed that the count(*) in CQL seems to be having wrong answer, when I have
only one row, the count(*) returns two.
> 
> Below are the commands I tried:
> 
> cqlsh> SELECT COUNT(*) FROM UserProfile USING CONSISTENCY QUORUM WHERE KEY IN ('00D760DB1730482D81BC6845F875A97D');
> (2,)
> cqlsh> select * from UserProfile where key = '00D760DB1730482D81BC6845F875A97D';
> u'00D760DB1730482D81BC6845F875A97D' | u'ScreenName','3D5C78CAE2E143FBBD1F539A8496D472'
> 
> Is this a known bug? Or I did something wrong?

It's the equivalent of get_count(), so it returns a column count instead
of row count.

-- 
Eric Evans
eevans@rackspace.com


Mime
View raw message