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 F25F29683 for ; Tue, 14 Feb 2012 17:46:16 +0000 (UTC) Received: (qmail 87759 invoked by uid 500); 14 Feb 2012 17:46:15 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 87717 invoked by uid 500); 14 Feb 2012 17:46: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 87708 invoked by uid 99); 14 Feb 2012 17:46:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Feb 2012 17:46:15 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of breathing@gmail.com designates 209.85.214.169 as permitted sender) Received: from [209.85.214.169] (HELO mail-tul01m020-f169.google.com) (209.85.214.169) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Feb 2012 17:46:07 +0000 Received: by obbta7 with SMTP id ta7so326247obb.14 for ; Tue, 14 Feb 2012 09:45:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=JhqF9an5z/+pQRXsNzJFoGipmKLHDR/WM2xXJO5pXgc=; b=Otc3wmv0CDUNgygvrgAhkIxN5KXkwrqc43Vz7UyHWDiCXT+quDj2qvBmo/safenNlf r9yYn1aCDHwRxH8nSJkl+YNkkUtY5tygLlSG+OCgJpva1fKwmelerWC7eGzlZogqYbby RaBJJsWoCE3NvP5PJ58dDLZ3TrHkxj+ff+g+c= MIME-Version: 1.0 Received: by 10.182.89.7 with SMTP id bk7mr16277822obb.15.1329241546928; Tue, 14 Feb 2012 09:45:46 -0800 (PST) Received: by 10.60.22.99 with HTTP; Tue, 14 Feb 2012 09:45:46 -0800 (PST) Date: Wed, 15 Feb 2012 01:45:46 +0800 Message-ID: Subject: multiple partial scans in the row From: James Young To: user@hbase.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi there, I am pretty new to HBase and i am trying to understand the best practice to do the scan based on two/multiple partial scans for the row key. For example, I have a row key like: orderId-timeStamp-item. The orderId has nothing to with the timeStamp and i have a requirement to scan rows for certain orderIds ( a range of orderIds) within certain time period. I am not sure if it is possible to perform two partial scan: one is for orderId and another one is for the timeStamp. Also, doing regular expression on the row key might work out. But it is more expensive. so I am wondering what would be the best practice for solving such a problem. Thanks in advance, James