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 84E78D24C for ; Fri, 18 Jan 2013 06:31:20 +0000 (UTC) Received: (qmail 1888 invoked by uid 500); 18 Jan 2013 06:31:18 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 1643 invoked by uid 500); 18 Jan 2013 06:31:18 -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 1630 invoked by uid 99); 18 Jan 2013 06:31:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Jan 2013 06:31:17 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mili@microstrategy.com designates 199.255.80.101 as permitted sender) Received: from [199.255.80.101] (HELO mailgate3.microstrategy.com) (199.255.80.101) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Jan 2013 06:31:12 +0000 X-IronPort-AV: E=Sophos;i="4.84,490,1355115600"; d="scan'208";a="8686206" Received: from prod-exch-h1.corp.microstrategy.com ([10.26.4.40]) by mailgate3.microstrategy.com with ESMTP/TLS/AES128-SHA; 18 Jan 2013 01:30:51 -0500 Received: from PROD-EXCH-M3.corp.microstrategy.com ([fe80::6088:403c:10e5:f569]) by PROD-EXCH-H1.corp.microstrategy.com ([fe80::681e:5457:7c96:5e77%20]) with mapi id 14.02.0247.003; Fri, 18 Jan 2013 01:30:51 -0500 From: "Li, Min" To: "user@hbase.apache.org" Subject: RE: ValueFilter and VERSIONS Thread-Topic: ValueFilter and VERSIONS Thread-Index: AQHN9UOLE6i+9lahLECN3p+TO/SS4JhO8yYA//+sqqA= Date: Fri, 18 Jan 2013 06:30:50 +0000 Message-ID: <9ABAF877128BEB4E8E8C7F8ADD9F3097739545@PROD-EXCH-M3.corp.microstrategy.com> References: ,<9ABAF877128BEB4E8E8C7F8ADD9F3097739520@PROD-EXCH-M3.corp.microstrategy.com> <0CE69E9126D0344088798A3B7F7F80863AEBC721@SZXEML553-MBX.china.huawei.com> In-Reply-To: <0CE69E9126D0344088798A3B7F7F80863AEBC721@SZXEML553-MBX.china.huawei.com> Accept-Language: zh-CN, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.197.62.29] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org Hi Anoop, Thanks for your reply. But I have to use value filter here, because in some= of my use case, I can't identify the qualifier. Thanks, Min -----Original Message----- From: Anoop Sam John [mailto:anoopsj@huawei.com]=20 Sent: Friday, January 18, 2013 2:28 PM To: user@hbase.apache.org Subject: RE: ValueFilter and VERSIONS Can you make use of SingleColumnValueFilter. In this you can specify wheth= er the condition to be checked only on the latest version or not. SCVF#setLatestVersionOnly ( true) -Anoop- ________________________________________ From: Li, Min [mili@microstrategy.com] Sent: Friday, January 18, 2013 11:47 AM To: user@hbase.apache.org Subject: ValueFilter and VERSIONS Hi all, As you know, ValueFilter will filter data from all versions, so I create a = table and indicate it has only 1 version. However, the old version record s= till can be gotten by ValueFilter? Does anyone know how to create a table w= ith only one version record? BTW, I am using hbase 0.92.1. Following is my testing commands: hbase(main):016:0> create 'testUser', {NAME =3D> 'F', VERSIONS =3D> 1} 0 row(s) in 1.0630 seconds hbase(main):017:0> put 'testUser', '123, 'F:f', '3' 0 row(s) in 0.0120 seconds hbase(main):018:0> put 'testUser', '123, 'F:f', '1' 0 row(s) in 0.0060 seconds hbase(main):019:0> scan 'testUser' ROW COLUMN+CELL 123 column=3DF:f, timestamp=3D1358489113213, value=3D1 1 row(s) in 0.0110 seconds hbase(main):020:0> scan 'testUser',{FILTER =3D> "(PrefixFilter ('123') AND = ValueFilter (>,'binary:1')"} ROW COLUMN+CELL 123 column=3DF:f, timestamp=3D1358489110172, value=3D3 1 row(s) in 0.1790 seconds Thanks, Min