Return-Path: Delivered-To: apmail-hadoop-hbase-user-archive@minotaur.apache.org Received: (qmail 89986 invoked from network); 15 Sep 2009 22:10:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 15 Sep 2009 22:10:17 -0000 Received: (qmail 79831 invoked by uid 500); 15 Sep 2009 22:10:16 -0000 Delivered-To: apmail-hadoop-hbase-user-archive@hadoop.apache.org Received: (qmail 79778 invoked by uid 500); 15 Sep 2009 22:10:16 -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 79766 invoked by uid 99); 15 Sep 2009 22:10:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Sep 2009 22:10:16 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Sep 2009 22:10:05 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1MngDY-0005gD-Vx for hbase-user@hadoop.apache.org; Tue, 15 Sep 2009 15:09:44 -0700 Message-ID: <25462736.post@talk.nabble.com> Date: Tue, 15 Sep 2009 15:09:44 -0700 (PDT) From: check_writer To: hbase-user@hadoop.apache.org Subject: Re: SingleColumnValueFilter doesn't seem to work In-Reply-To: <4AAFCCA3.2040808@streamy.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: tuyo@masaitechnologies.com References: <25448971.post@talk.nabble.com> <4AAFCCA3.2040808@streamy.com> X-Virus-Checked: Checked by ClamAV on apache.org Thanks for the quick response, I got the latest branch and it works now. Jonathan Gray-2 wrote: > > I just committed fixes to 0.20.1 branch for SingleColumnValueFilter. > > You can grab the latest 0.20 branch from SVN, or you can apply the fix > yourself from HBASE-1821. > > https://issues.apache.org/jira/browse/HBASE-1821 > > There was also another filter patch that went in, HBASE-1828. > > Please check out the patch and let me know if it fixes your issue. > > Thanks! > > JG > > check_writer wrote: >> I'm a newbie to HBase and using 0.20.0 (from Sept 8th) I think my issue >> may >> be similar to the one posted earlier, however I seem to be getting all >> rows >> regardless of my filter settings. >> >> Scan scan = new Scan(); >> scan.addFamily("fam1".getBytes()); >> scan.addFamily("fam2".getBytes()); >> >> scan.setFilter(new >> SingleColumnValueFilter("fam1".getBytes(),"c1".getBytes(),CompareOp.EQUAL,"somenonexistingvalue".getBytes())); >> ResultScanner rs = mytable.getScanner(scan); >> for(Result r : rs) >> { >> // I get all rows from the my table!!! >> >> // also r.getValue("fam1","c1") is NULL for some reason. >> } >> rs.close(); >> >> I assume what I'm trying to do is fairly common so maybe I'm missing >> something. However all I want to do is filter rows IN based on a column >> value. >> >> Any help would be appreciated. > > -- View this message in context: http://www.nabble.com/SingleColumnValueFilter-doesn%27t-seem-to-work-tp25448971p25462736.html Sent from the HBase User mailing list archive at Nabble.com.