Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of saint.ack@gmail.com
 designates 209.85.213.41 as permitted sender)
MIME-Version: 1.0
Sender: saint.ack@gmail.com
In-Reply-To: 
 <CAG+ckK8XNd+4-V0BnQ-eZyD9X3hyA3ay7D-iLEknO2GAmTstBg@mail.gmail.com>
References: 
 <CAG+ckK8XNd+4-V0BnQ-eZyD9X3hyA3ay7D-iLEknO2GAmTstBg@mail.gmail.com>
Date: Thu, 26 Jul 2012 23:13:43 +0200
Message-ID: 
 <CADcMMgEJgGZMqb381wzPrLsjHwjOAt7v2yq1y2dgzhmNV0vDng@mail.gmail.com>
Subject: Re: Query a version of a column efficiently
From: Stack <stack@duboce.net>
To: user@hbase.apache.org
Content-Type: text/plain; charset=ISO-8859-1

On Thu, Jul 26, 2012 at 7:43 PM, Jerry Lam <chilinglam@gmail.com> wrote:
> I need some advises on a problem that I'm facing using HBase. How can I
> efficiently query a version of a column when I don't know exactly the
> version I'm looking for?
> For instance, I want to query a column with timestamp that is less or equal
> to N, if version = N is available, return it to me. Otherwise, I want the
> version that is closest to the version N (order by descending of
> timestamp). That is if version = N - 1 exists, I want it to be returned.
>

Have you tried a timerange w/ minStamp of N and maxStamp of
HConstants#LATEST_TIMESTAMP Long.MAX_VALUE) returning one version only
(setMaxVersion(1))?

St.Ack