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 4C2784F59 for ; Fri, 27 May 2011 15:14:24 +0000 (UTC) Received: (qmail 90574 invoked by uid 500); 27 May 2011 15:14:21 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 90550 invoked by uid 500); 27 May 2011 15:14:21 -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 90542 invoked by uid 99); 27 May 2011 15:14:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 May 2011 15:14:21 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,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 74.125.82.44 as permitted sender) Received: from [74.125.82.44] (HELO mail-ww0-f44.google.com) (74.125.82.44) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 May 2011 15:14:15 +0000 Received: by wwa36 with SMTP id 36so1664631wwa.25 for ; Fri, 27 May 2011 08:13:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type:content-transfer-encoding; bh=6e2g8b5qq00sTPSKMFaw12WF941055JVXF85z0JfZPE=; b=i3wX/Ss2tOEEdNeSOePZ+irAS+C7KQa3ORI8q21ANN3OMSpVLjDKm/kFBDZhi4XYyb 19lm0MoYlUmh3hfRtiN1m0z3dKZQ2bvBczyvXMJ3PPDIz/YmZDVfmHWd7SbUAsgXZ1p/ yKLb1M/YxRjJu/pZe9BUJWYXs+L1sLX/AISao= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; b=Nh8gHpy3CZYwsadFvxeje1QVxCyn4j5Sc8F009RNOq066wbH9TaY57lODCRwvEF58k 92sqfjh7uT5vjdDVRS5/zuW6C2L/Sl+VCpO/vqpv6j0mXlxFisFN0wnuOlWhqKwY2bMC ISazLIdTokb8BF+syfh5o2h2caa0Dl+syFKx8= Received: by 10.216.235.33 with SMTP id t33mr2168572weq.6.1306509235095; Fri, 27 May 2011 08:13:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.17.15 with HTTP; Fri, 27 May 2011 08:13:35 -0700 (PDT) In-Reply-To: References: <4DDF6C7C.6020400@ihep.ac.cn> From: Jonathan Ellis Date: Fri, 27 May 2011 10:13:35 -0500 Message-ID: Subject: Re: python cql driver select count(*) failed To: user@cassandra.apache.org, zangds@ihep.ac.cn Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org (and if it did, it would be the SQL row count, which is different than the column count from pycassa.) On Fri, May 27, 2011 at 10:13 AM, Jonathan Ellis wrote: > CQL does not support count(). > > On Fri, May 27, 2011 at 4:18 AM, Donal Zang wrote: >> Hi, >> =A0I'm using the jar from the trunk source code . >> I tried the following select cql, but it get the wrong result.(I can get= the >> right result using pycassa's get_count()) >> cqlsh> select count(1) from t_container where KEY =3D '2011041210' ; >> (0,) >> cqlsh> select count(*) from t_container where KEY =3D '2011041210' ; >> (0,) >> Any ideas? Should the KEY be converted to bytes? >> >> Thanks! >> Donal >> > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com > --=20 Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com