Return-Path: Delivered-To: apmail-hadoop-hbase-user-archive@minotaur.apache.org Received: (qmail 88968 invoked from network); 2 Feb 2010 22:01:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Feb 2010 22:01:30 -0000 Received: (qmail 8848 invoked by uid 500); 2 Feb 2010 22:01:29 -0000 Delivered-To: apmail-hadoop-hbase-user-archive@hadoop.apache.org Received: (qmail 8762 invoked by uid 500); 2 Feb 2010 22:01:29 -0000 Mailing-List: contact hbase-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hbase-user@hadoop.apache.org Delivered-To: mailing list hbase-user@hadoop.apache.org Received: (qmail 8752 invoked by uid 99); 2 Feb 2010 22:01:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 22:01:29 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of baleksan@gmail.com designates 209.85.217.215 as permitted sender) Received: from [209.85.217.215] (HELO mail-gx0-f215.google.com) (209.85.217.215) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Feb 2010 22:01:19 +0000 Received: by gxk7 with SMTP id 7so666544gxk.12 for ; Tue, 02 Feb 2010 14:00:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=qgXKpbvyHA2b3M+pU4Ubb4jlF50xFieMD+5vqayH6YA=; b=aCQ4m+debBdYvbcbLEx0vA2fPFXyI/ms6I5NEyIx1/AGS2R64pUdsmLGol89Vw/FPa wIHFPE2Ui+VXezIHriA00I1LHE1tk0cZ0d03QlKNs6NZL6hWJWtdOe+zIINt0l14c0nK roNeOe2DqJc9kx4PATeiXIs7NwPvWWy9wscw8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=LpjOJBq6rxUZXQhmy1lX5gcCiNk6ep+eBzh8/IefAIW1FA6fOq/RgqePnBfb6ZOIsJ PlkrUeQqbSc2BrOhe63gCZFK9HcMS1Zj5Efg4ZPaUGkWhTWQjR86vYt7NNgTv4ZizPsk GPwvI0jf71o32Pyd7HJVgeeCL5QDt1UHMSWeY= MIME-Version: 1.0 Received: by 10.101.133.31 with SMTP id k31mr8795681ann.25.1265148058355; Tue, 02 Feb 2010 14:00:58 -0800 (PST) In-Reply-To: <31a243e71002021359s2c3c1633ocb9214dad5483e6c@mail.gmail.com> References: <97aa8b3e1002021354h534ed63bue9723eef396d40e6@mail.gmail.com> <31a243e71002021359s2c3c1633ocb9214dad5483e6c@mail.gmail.com> Date: Tue, 2 Feb 2010 14:00:58 -0800 Message-ID: <97aa8b3e1002021400wc637571t511cde4741a87e22@mail.gmail.com> Subject: Re: quick get of number of rows in the table From: Boris Aleksandrovsky To: hbase-user@hadoop.apache.org Content-Type: multipart/alternative; boundary=0016e68ee2449b47cf047ea53ce8 --0016e68ee2449b47cf047ea53ce8 Content-Type: text/plain; charset=ISO-8859-1 Thanks, Jean-Daniel! On Tue, Feb 2, 2010 at 1:59 PM, Jean-Daniel Cryans wrote: > Boris, > > There is a quicker way but since we currently don't keep a count > somewhere, it's always about doing a full table scan. > > See how the count is implemented in the shell to learn of the quicker > way. Specifically, look at bin/HBase.rb > > J-D > > On Tue, Feb 2, 2010 at 1:54 PM, Boris Aleksandrovsky > wrote: > > Hi, > > > > Is there a way to retrieving the number of rows in the table without > doing a > > complete scan and counting the number of returned results (via next())? > > > > -- > > Thanks, > > > > Boris > > > -- Thanks, Boris http://twitter.com/baleksan http://www.linkedin.com/in/baleksan --0016e68ee2449b47cf047ea53ce8--