Mailing-List: contact hbase-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hbase-user@hadoop.apache.org
Received-SPF: pass (nike.apache.org: domain of saint.ack@gmail.com designates
 74.125.92.27 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type;
        b=gEpHPaWsJrivq8fes0OsbkHbEmPtGjrzBz5DSxY7SaDkJZuJZ1dfyhziMzMx0mcWD8
         pSWiX/wNaHsDVe1p7x+IiwcBftzAuRKcdYpvFtF/y6mXfs9D4kgGXes5u8AoPoxRFQ0I
         2nML9idweJ94iQT3OyGhgPx5CBz0HGRhnIsyo=
MIME-Version: 1.0
Sender: saint.ack@gmail.com
In-Reply-To: <2d789610908281359o77753ff9hd95462991ef8f235@mail.gmail.com>
References: <2d789610908281359o77753ff9hd95462991ef8f235@mail.gmail.com>
Date: Sat, 29 Aug 2009 10:00:25 -0700
Message-ID: <7c962aed0908291000w7d3d19a4taec26e9ee10576c9@mail.gmail.com>
Subject: Re: Getting all the different timestamp values for a column
From: stack <stack@duboce.net>
To: hbase-user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=000e0cd6a918ad40fa04724abcf4

--000e0cd6a918ad40fa04724abcf4
Content-Type: text/plain; charset=ISO-8859-1

You have to be using 0.20.0 RC2 to do the below.  The below also presumes
that each value has a different timestamp; i.e. you don't expect to add
multiple values against same timestamp.

// Presumes you already have a table instance named 'table'.
Scan scan = new Scan(Bytes.toBytes("ID1:ID2"));
scan.addColumn(Bytes.toBytes("family_name"),
Bytes.toBytes("qualifier_term"));
scan.setTimeStamp(ts); // This gets all from the timestamp and older.  Use
setTimeRange if you want to set a range.
// Optionally, if you want to cap versions returned, see setMaxVersions.
ResultScanner scanner = table.getScanner(scan);
.....

The above is how I'd do it.  Elegance is a tag I'm rarely associated with so
there may be a better way...

Hopefuly this helps
St.Ack


On Fri, Aug 28, 2009 at 1:59 PM, Nikhil Gupta <gunchu@gmail.com> wrote:

> Hi,
>
> I am new to HBase, so please forgive if this question is too basic.
>
> We are building a system that stores time series data for different terms
> in
> column qualifiers.
> So, we plan to store data in the form :
> KeyID -> "ID1:ID2"
> Family:Qualifier -> "family_name:qualifier_term"
> Values -> Traffic for that term with different timestamps
>
> We will pull this data to display a trends kind of chart on front end.
> Now if I want to get all the values for different timestamps for a
> particular column while scanning, how can I do that via a scanner in the
> most elegant manner ?
>
> [assuming that I know exact values for id1:id2 but not for qualifier_term.]
>
> Thanks
> -nikhil
> http://stanford.edu/~nikgupta <http://stanford.edu/%7Enikgupta>
>

--000e0cd6a918ad40fa04724abcf4--