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 jdcryans@gmail.com designates
 209.85.128.170 as permitted sender)
MIME-Version: 1.0
Sender: jdcryans@gmail.com
In-Reply-To: 
 <CAHZWmqrkQNSsy90B=1VyUQ4E683ooVC7vsvN1mG+=3jh_DOyRA@mail.gmail.com>
References: 
 <CAHZWmqrkQNSsy90B=1VyUQ4E683ooVC7vsvN1mG+=3jh_DOyRA@mail.gmail.com>
Date: Mon, 6 May 2013 10:33:55 -0700
Message-ID: 
 <CAGpTDNdWMRou+op6dZiPKmmS2sCVdA9j5zgDGJmbPTzAnB6kEg@mail.gmail.com>
Subject: Re: Extract a whole table for a given time(stamp)
From: Jean-Daniel Cryans <jdcryans@apache.org>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=bcaec5015d0fe95c7904dc101a53

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

You can use the Export MR job provided with HBase, it lets you set a time
range: http://hbase.apache.org/book.html#export

J-D


On Mon, May 6, 2013 at 10:27 AM, Gaurav Pandit <pandit.gaurav@gmail.com>wrote:

> Hi Hbase users,
>
> We have a use case where we need to know how data looked at a given time in
> past.
>
> The data is stored in HBase of course, with multiple versions. And, the
> goal is to be able to extractall records (rowkey, columns) as of a given
> timestamp, to a file.
>
>
> I am trying to figure out the best way to achieve this.
>
> The options I know are:
> 1. Write a *Java* client using HBase Java API, and scan the hbase table.
> 2. Do the same, but over *Thrift* HBase API using Perl (since
> our environment is mostly Perl).
> 3. Use *Hive *to point to HBase table, and use Sqoop to extract data from
> the Hive table and onto client / RDBMS.
> 4. Use *Pig *to extract data from HBase table and dump it on HDFS and move
> the file over to the client.
>
> So far, I have successfully implemented option (2). I am still running some
> tests to see how it performs, but it works fine as such.
>
> My questions are:
> 1. Is option (3) or (4) even possible? I am not sure if we can access the
> table for a given timestamp over Pig or Hive.
> 2. Is there any other better way of achieving this?
>
>
> Thanks!
> Gaurav
>

--bcaec5015d0fe95c7904dc101a53--