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 AD31817FE6 for ; Fri, 3 Oct 2014 15:10:27 +0000 (UTC) Received: (qmail 67829 invoked by uid 500); 3 Oct 2014 15:10:25 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 67759 invoked by uid 500); 3 Oct 2014 15:10:25 -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 67747 invoked by uid 99); 3 Oct 2014 15:10:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Oct 2014 15:10:25 +0000 X-ASF-Spam-Status: No, hits=2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of yuzhihong@gmail.com designates 209.85.160.176 as permitted sender) Received: from [209.85.160.176] (HELO mail-yk0-f176.google.com) (209.85.160.176) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Oct 2014 15:10:21 +0000 Received: by mail-yk0-f176.google.com with SMTP id 9so400305ykp.21 for ; Fri, 03 Oct 2014 08:10:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=zVtxNYSMvlv+2PXpZbq/TVJKBYDGIw+wG8gDU1l84sw=; b=HuGfbzj0hEgOl8W0qL4UK1hnGmPlF36Rhi6H7saBGMNWgcLmtaBlqmmlDjSrujvFSM pIOOWtrcw01Oq70nn0QhnqvsB41RUo+8J0L5HdW+GKOEGs1JhgYOiCd5/XFWQgrttFoG KfsyxlZJq3phkmmMTIVtS7nR1hEow+ORfzw89M+9huJ99mIMBqozQCfNnfvnKQ7Tdrx9 +PC3te9Ngvxr3BGjJvNfEf6peqDUPUSiVt1HbeLxKkf+/dq5VNfiv/dXuvlaP0Shcxcq HKGr8vB/aLYYhicj8zq8rXxTqVqsIBUlrTbZZ9lMIkNm6nmqQDdliMR5YxKj64XhOzb+ GR6g== MIME-Version: 1.0 X-Received: by 10.236.13.38 with SMTP id a26mr8860765yha.23.1412349000742; Fri, 03 Oct 2014 08:10:00 -0700 (PDT) Received: by 10.170.163.70 with HTTP; Fri, 3 Oct 2014 08:10:00 -0700 (PDT) In-Reply-To: <1412336136166-4064684.post@n3.nabble.com> References: <1412336136166-4064684.post@n3.nabble.com> Date: Fri, 3 Oct 2014 08:10:00 -0700 Message-ID: Subject: Re: single column value filter to find rows greater than a certain date not working From: Ted Yu To: "user@hbase.apache.org" Content-Type: multipart/alternative; boundary=001a1133d3907cff1005048620ae X-Virus-Checked: Checked by ClamAV on apache.org --001a1133d3907cff1005048620ae Content-Type: text/plain; charset=UTF-8 Which release of hbase are you using ? Can you come up with unit test that shows this problem ? BTW Your use case is covered by TestSingleColumnValueFilter.java On Fri, Oct 3, 2014 at 4:35 AM, aaaa342156 wrote: > I am storing date in a column in Hbase table. I am using below syntax to > find > dates greater than 20110810 but the resultset is bringing back all the > rows. > Any thoughts. > > Filter filter = new SingleColumnValueFilter(Bytes.toBytes("cf"), > Bytes.toBytes("d"), CompareOp.GREATER_OR_EQUAL, Bytes.toBytes("20110810")); > scan.setFilter(filter); > ResultScanner rs = table.getScanner(scan); > > > > -- > View this message in context: > http://apache-hbase.679495.n3.nabble.com/single-column-value-filter-to-find-rows-greater-than-a-certain-date-not-working-tp4064684.html > Sent from the HBase User mailing list archive at Nabble.com. > --001a1133d3907cff1005048620ae--