Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 3B33EDEAB for ; Thu, 27 Dec 2012 08:42:18 +0000 (UTC) Received: (qmail 23272 invoked by uid 500); 27 Dec 2012 08:42:16 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 22516 invoked by uid 500); 27 Dec 2012 08:42:15 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 22471 invoked by uid 99); 27 Dec 2012 08:42:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Dec 2012 08:42:13 +0000 X-ASF-Spam-Status: No, hits=1.0 required=5.0 tests=MSGID_MULTIPLE_AT,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [159.226.251.15] (HELO cstnet.cn) (159.226.251.15) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Dec 2012 08:42:06 +0000 Received: from tianguanhua (unknown [159.226.20.193]) by app6 (Coremail) with SMTP id UgCowJBb6gbGCdxQrY0GAA--.9085S2; Thu, 27 Dec 2012 16:41:42 +0800 (CST) From: "tgh" To: References: <31xar39e5nuqcq1rc87vv1ic.1356564829273@email.android.com> ,<000601cde3d8$d6695200$833bf600$@tian@ia.ac.cn> <0CE69E9126D0344088798A3B7F7F80863AEA95D0@SZXEML553-MBX.china.huawei.com> <002301cde402$dad7b690$908723b0$@tian@ia.ac.cn>,<002a01cde40a$5876a9b0$0963fd10$@tian@ia.ac.cn> <0CE69E9126D0344088798A3B7F7F80863AEAAA69@SZXEML553-MBX.china.huawei.com> In-Reply-To: <0CE69E9126D0344088798A3B7F7F80863AEAAA69@SZXEML553-MBX.china.huawei.com> Subject: =?gb2312?B?tPC4tDogd2hpY2ggQVBJIGlzIHRvIGdldCB0YWJsZSBtZXRhIGRhdA==?= =?gb2312?B?YSBpbiBoYmFzZQ==?= Date: Thu, 27 Dec 2012 16:41:42 +0800 Message-ID: <003101cde40d$ff3b5a40$fdb20ec0$@tian@ia.ac.cn> MIME-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AQHN5ApvDDdqISf5bEOkx6ac5IlqBpgsTeB2gAAEkbA= Content-Language: zh-cn X-CM-TRANSID: UgCowJBb6gbGCdxQrY0GAA--.9085S2 X-Coremail-Antispam: 1UD129KBjvJXoW7WFy3tw13Cry7uFyxKw4xCrg_yoW8uFy3pr Waqry7Kwn0yw1kJw1xCr4Utryqk3s5K345Jr1rGay8ArZxCryxWF4ktrZaqFy5GF98Jryq qw4jgFn8Ga98Z3DanT9S1TB71UUUUUUqnTZGkaVYY2UrUUUUjbIjqfuFe4nvWSU5nxnvy2 9KBjDU0xBIdaVrnRJUUUkKb7Iv0xC_Cr1lb4IE77IF4wAFF20E14v26r1j6r4UM7CY07I2 0VC2zVCF04k26cxKx2IYs7xG6rWj6s0DM7CIcVAFz4kK6r1j6r18M28lY4IEw2IIxxk0rw A2z4x0Y4vE2Ix0cI8IcVAFwI0_Gr0_Xr1l84ACjcxK6xIIjxv20xvEc7CjxVAFwI0_Gr0_ Cr1l84ACjcxK6I8E87Iv67AKxVW8Jr0_Cr1UM28EF7xvwVC2z280aVCY1x0267AKxVWxJr 0_GcWle2I262IYc4CY6c8Ij28IcVAaY2xG8wAqx4xG64xvF2IEw4CE5I8CrVC2j2WlYx0E 2Ix0cI8IcVAFwI0_Jw0_WrylYx0Ex4A2jsIE14v26F4UJVW0owAm72CE4IkC6x0Yz7v_Jr 0_Gr1lF7xvr2IYc2Ij64vIr41lF7xvr2IYc2Ij64vIr40E4x8a64kEw24lF7xvrVCFI7AF 6II2Y40_Zr0_Gr1UMxkIecxEwVAFwVW8ZwCF04k20xvY0x0EwIxGrwC20s026c02F40E14 v26r1j6r18MI8I3I0E7480Y4vE14v26r106r1rMI8E67AF67kF1VAFwI0_Jr0_JrylIxkG c2Ij64vIr41lIxAIcVC0I7IYx2IY67AKxVWUJVWUCwCI42IY6xIIjxv20xvEc7CjxVAFwI 0_Jr0_Gr1lIxAIcVCF04k26cxKx2IYs7xG6rWUJVWrZr1UMIIF0xvEx4A2jsIE14v26r1j 6r4UMIIF0xvEx4A2jsIEc7CjxVAFwI0_Jr0_GrUvcSsGvfC2KfnxnUUI43ZEXa7IU5c6pJ UUUUU== X-CM-SenderInfo: hjxd0xtxdo3x1dq6xtwodfhubq/ X-Virus-Checked: Checked by ClamAV on apache.org Thank you for your reply I try to use AggregationClient API , but as you know ,I want to know how many rows there, scanner will scan whole table one by one row, is it,=20 And It is not slow for a big table , is it, And you say make a record when we insert message in the table, it is a = good idea, but we have store the record there, and want to statistic the = number of record , And there is some speed up method for the scan, Could you help me Thank you --------------------- Tian Guanhua -----=D3=CA=BC=FE=D4=AD=BC=FE----- =B7=A2=BC=FE=C8=CB: = user-return-32787-guanhua.tian=3Dia.ac.cn@hbase.apache.org [mailto:user-return-32787-guanhua.tian=3Dia.ac.cn@hbase.apache.org] = =B4=FA=B1=ED Anoop Sam John =B7=A2=CB=CD=CA=B1=BC=E4: 2012=C4=EA12=D4=C227=C8=D5 16:23 =CA=D5=BC=FE=C8=CB: user@hbase.apache.org =D6=F7=CC=E2: RE: which API is to get table meta data in hbase > But I say, there need some meta data which record how many row number in the give table, I say , hbase has this meta data, is it, And which API is to get it, and how to use API, There is no such meta data for a table. You can check whether you can do this work on your own using co = processors. There were some discussion on this in the mailing list. Sorry I am not = able find the links for that now. You can create another table and store the stats there in the second table. But see whether you can make use of the AggregationClient API. U have = some column for which every row will have a not null value?? -Anoop- ________________________________________ From: tgh [guanhua.tian@ia.ac.cn] Sent: Thursday, December 27, 2012 1:45 PM To: user@hbase.apache.org Subject: which API is to get table meta data in hbase Hi I try to use API of hbase, and I store a big table in hbase, But I have not find how to get the row number of this big table, I say , AggregationClient#rowCount() is to statistic the Number of given Family and given col in a table, and it scan the related region to = satistic the Number, that is, some colume can be null, is it, But I say, there need some meta data which record how many row number in the give table, I say , hbase has this meta data, is it, And which API is to get it, and how to use API, Could you help me Thank you --------------------- Tian Guanhua=3D