You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Hansi Klose <ha...@web.de> on 2014/05/13 10:58:16 UTC
hbase shell - how to get the key with oldest timestamp
Hi because of the Issue
https://issues.apache.org/jira/browse/HBASE-10395
i want to start my verification job with a starttime.
To verify the whole time range i need the oldest timestamp in that table.
I it possible with the hbase shell to get the key with the oldest timestamp?
So that i can use this timestamp as starttime in my verifyrep job.
Regards Hansi
Aw: Re: hbase shell - how to get the key with oldest timestamp
Posted by Hansi Klose <ha...@web.de>.
Thank you John,
i will use a very old timestamp for the job.
Regards Hansi
> Gesendet: Dienstag, 13. Mai 2014 um 13:59 Uhr
> Von: "john guthrie" <gr...@gmail.com>
> An: user@hbase.apache.org
> Betreff: Re: hbase shell - how to get the key with oldest timestamp
>
> can't you just pick an old date - January 1, 1970 maybe?
>
>
> On Tue, May 13, 2014 at 4:58 AM, Hansi Klose <ha...@web.de> wrote:
>
> > Hi because of the Issue
> >
> > https://issues.apache.org/jira/browse/HBASE-10395
> >
> > i want to start my verification job with a starttime.
> >
> > To verify the whole time range i need the oldest timestamp in that table.
> >
> > I it possible with the hbase shell to get the key with the oldest
> > timestamp?
> >
> > So that i can use this timestamp as starttime in my verifyrep job.
> >
> > Regards Hansi
> >
>
Re: hbase shell - how to get the key with oldest timestamp
Posted by Jean-Marc Spaggiari <je...@spaggiari.org>.
Have you tried something like this?
get 't1', 'r1', {COLUMN => 'c1', TIMERANGE => [ts1, ts2], VERSIONS => 1}
Where ts1 is a very old date and ts2 is today?
does it gives you the most recent one? Or the oldest one? I did not tried...
2014-05-13 7:59 GMT-04:00 john guthrie <gr...@gmail.com>:
> can't you just pick an old date - January 1, 1970 maybe?
>
>
> On Tue, May 13, 2014 at 4:58 AM, Hansi Klose <ha...@web.de> wrote:
>
> > Hi because of the Issue
> >
> > https://issues.apache.org/jira/browse/HBASE-10395
> >
> > i want to start my verification job with a starttime.
> >
> > To verify the whole time range i need the oldest timestamp in that table.
> >
> > I it possible with the hbase shell to get the key with the oldest
> > timestamp?
> >
> > So that i can use this timestamp as starttime in my verifyrep job.
> >
> > Regards Hansi
> >
>
Re: hbase shell - how to get the key with oldest timestamp
Posted by Ted Yu <yu...@gmail.com>.
Hansi:
HBASE-10395 is fixed in 0.98.0
Have you considered upgrading to 0.98.x ?
Cheers
On Tue, May 13, 2014 at 4:59 AM, john guthrie <gr...@gmail.com> wrote:
> can't you just pick an old date - January 1, 1970 maybe?
>
>
> On Tue, May 13, 2014 at 4:58 AM, Hansi Klose <ha...@web.de> wrote:
>
> > Hi because of the Issue
> >
> > https://issues.apache.org/jira/browse/HBASE-10395
> >
> > i want to start my verification job with a starttime.
> >
> > To verify the whole time range i need the oldest timestamp in that table.
> >
> > I it possible with the hbase shell to get the key with the oldest
> > timestamp?
> >
> > So that i can use this timestamp as starttime in my verifyrep job.
> >
> > Regards Hansi
> >
>
Re: hbase shell - how to get the key with oldest timestamp
Posted by john guthrie <gr...@gmail.com>.
can't you just pick an old date - January 1, 1970 maybe?
On Tue, May 13, 2014 at 4:58 AM, Hansi Klose <ha...@web.de> wrote:
> Hi because of the Issue
>
> https://issues.apache.org/jira/browse/HBASE-10395
>
> i want to start my verification job with a starttime.
>
> To verify the whole time range i need the oldest timestamp in that table.
>
> I it possible with the hbase shell to get the key with the oldest
> timestamp?
>
> So that i can use this timestamp as starttime in my verifyrep job.
>
> Regards Hansi
>