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 21943175BF for ; Wed, 22 Apr 2015 13:16:24 +0000 (UTC) Received: (qmail 40698 invoked by uid 500); 22 Apr 2015 13:16:22 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 40630 invoked by uid 500); 22 Apr 2015 13:16:22 -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 40613 invoked by uid 99); 22 Apr 2015 13:16:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Apr 2015 13:16:21 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: message received from 54.76.25.247 which is an MX secondary for user@hbase.apache.org) Received: from [54.76.25.247] (HELO mx1-eu-west.apache.org) (54.76.25.247) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Apr 2015 13:15:54 +0000 Received: from mail-pd0-f180.google.com (mail-pd0-f180.google.com [209.85.192.180]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id EB2FF203A5 for ; Wed, 22 Apr 2015 13:15:52 +0000 (UTC) Received: by pdbqa5 with SMTP id qa5so273703879pdb.1 for ; Wed, 22 Apr 2015 06:15:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:content-transfer-encoding:mime-version:subject :message-id:date:references:in-reply-to:to; bh=K2efb/pz+jEQmhSDZ/O7uJkaG+jgZFOWlPnQnFbaCZc=; b=rrkUPfyTBFbpE6mtO3T1ulqXo0OkAtRPGglqgU1ua3TS15hrnGgYwboFyWV/iPMLk0 w5jSO6zXfYCXtzqCeYrXvG2/cjW3DOn+G2704rGKX85NLyk8h4CcBAwbw/JyoG/9yS/w VLy1aVil4jeS+ZVkFLpCWhUW+rhhm3MXBa/LqVH7nZYS0a7295xj5Fwsaa5Z/FTfIEvn Qw7gX8eiLKCeI0C9GzQGV1ernDAIqFil7E97TG7JYm4NRcY0a2QOgLXT3fJr0oZFNUo8 3y5wyN7innlc03wMjvn9o8WxFKezS94xJyaT7mL0ICUxW3GXlLKY7ySjK2yqvN/mIQDO Vfsg== X-Received: by 10.66.192.1 with SMTP id hc1mr47145232pac.38.1429708545677; Wed, 22 Apr 2015 06:15:45 -0700 (PDT) Received: from [192.168.0.16] (c-24-130-236-83.hsd1.ca.comcast.net. [24.130.236.83]) by mx.google.com with ESMTPSA id jd5sm5073678pbd.35.2015.04.22.06.15.44 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 22 Apr 2015 06:15:44 -0700 (PDT) From: Ted Yu Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Subject: Re: scan startrow and stoprow Message-Id: <5A4BA566-707E-402E-A60D-150854EC03E0@gmail.com> Date: Wed, 22 Apr 2015 06:15:43 -0700 References: In-Reply-To: To: "user@hbase.apache.org" X-Mailer: iPhone Mail (12D508) X-Virus-Checked: Checked by ClamAV on apache.org Character '*' precedes character '0' Probably that was why some rows were not returned.=20 How long is the third component (number) normally ? Cheers > On Apr 22, 2015, at 3:56 AM, Sachin wrote: >=20 > My rowkey format is uniqueid|timestamp|randomnumber. >=20 > I want to retrieve data from hbase by using scanner with java api where my= =20 > startRow : aabb|timeStamp1|=20 >=20 > stopRow is : aabb|timeStamp2|*any_number >=20 > timeStamp1 and timeStamp2 are time ranges. So I want to fetch all values i= n=20 > between above timestamp where my *any_number can be anything it's * in=20 > regular expression. So my start and stop rows become : >=20 > startRow : aabb|timeStamp1|=20 >=20 > stopRow is : aabb|timeStamp2|* >=20 > I set these param to scan object but its not fetching data from hbase. Can= =20 > anyone tell me how to do that? >=20