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 BA660109E9 for ; Wed, 9 Jul 2014 15:55:29 +0000 (UTC) Received: (qmail 73051 invoked by uid 500); 9 Jul 2014 15:55:15 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 72982 invoked by uid 500); 9 Jul 2014 15:55: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 72750 invoked by uid 99); 9 Jul 2014 15:55:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jul 2014 15:55:15 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=SPF_SOFTFAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (athena.apache.org: transitioning domain of hao.leng@dish.com does not designate 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jul 2014 15:55:10 +0000 Received: from ben.nabble.com ([192.168.236.152]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1X4uCn-0001iG-QA for user@hbase.apache.org; Wed, 09 Jul 2014 08:54:49 -0700 Date: Wed, 9 Jul 2014 08:54:49 -0700 (PDT) From: Hotec04 To: user@hbase.apache.org Message-ID: <1404921289774-4061159.post@n3.nabble.com> Subject: How to perform fuzzyRowFilter with range search MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi All, I tried to find apis for fuzzyRowFilter with range search but did not find any. Here is what I want to achieve: show the row key in a certain date range. Our row key design is like customer id + timestamp. Example is: 1234567892014-07-09T00:11:22.333-04:00. Input should be the start date and end date and output will be all row keys within that date period. Example: input start date = 2014-07-07 and end date = 2014-07-10 then output will be 1234567892014-07-09T00:11:22.333-04:00 and xxxxxxxxx2014-07-08Txx:xx:xx.xxx-04:00 which means all row keys regardless customer id within that date range should be returned. We are using hbase api 0.94.15-cdh4.6.0.jar and hbase is from cloudera manager. I am not sure whether they support hbase 0.99 api. Any help will be appreciated. Thank you! -- View this message in context: http://apache-hbase.679495.n3.nabble.com/How-to-perform-fuzzyRowFilter-with-range-search-tp4061159.html Sent from the HBase User mailing list archive at Nabble.com.