Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CD5A88439 for ; Tue, 23 Aug 2011 01:57:15 +0000 (UTC) Received: (qmail 42431 invoked by uid 500); 23 Aug 2011 01:57:13 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 42198 invoked by uid 500); 23 Aug 2011 01:57:12 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 42189 invoked by uid 99); 23 Aug 2011 01:57:12 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Aug 2011 01:57:12 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates 209.85.215.44 as permitted sender) Received: from [209.85.215.44] (HELO mail-ew0-f44.google.com) (209.85.215.44) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Aug 2011 01:57:06 +0000 Received: by ewy19 with SMTP id 19so2128917ewy.31 for ; Mon, 22 Aug 2011 18:56:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=syUEfI953Q11fz1/g3/sZj4ZU/5jl9GhByUsg2ITlcw=; b=CuRRtoK9eHjJL2cWp9WY97Mp3trtfAPHuuNIFV9PycXjoQjJUUVjKHl7DOd1CJTAv6 +/0hg879qb2vFQ6MhbLWneIPWzR3egxW9j9Sy0fHXl1tOrjXDzSXTogwRq+uc9B8lTdZ pVcjsgDVdFFi3kN8oiVWmWxLkw+Rp/hbGpdkM= Received: by 10.213.106.2 with SMTP id v2mr796305ebo.33.1314064605225; Mon, 22 Aug 2011 18:56:45 -0700 (PDT) MIME-Version: 1.0 Received: by 10.213.10.18 with HTTP; Mon, 22 Aug 2011 18:56:25 -0700 (PDT) In-Reply-To: <13731A62-6AA4-478D-889C-DC2C1FEC803E@rhapsody.com> References: <13731A62-6AA4-478D-889C-DC2C1FEC803E@rhapsody.com> From: Jonathan Ellis Date: Mon, 22 Aug 2011 20:56:25 -0500 Message-ID: Subject: Re: CQL count(*) counts deleted records? To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Yes. On Mon, Aug 22, 2011 at 6:58 PM, Hefeng Yuan wrote: > We're using 0.8.1, and found the CQL count(*) is counting deleted columns, CLI doesn't have this issue. Is it a bug? > > cqlsh> select * from CF where key = 'foo'; > u'foo' > > cqlsh> select count(*) from CF where key = 'foo'; > (3,) -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com