You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Ted Yu <yu...@gmail.com> on 2010/08/18 01:07:40 UTC
Re: find the date when table is created
Is it possible to get the date/time when a region/table was last accessed ?
Thanks
On Wed, Jul 28, 2010 at 10:04 PM, Stack <st...@duboce.net> wrote:
> Yes. Its time region was created. Here's how to get a date from the
> timestamp inside shell:
>
> hbase(main):021:0> import java.util.Date
> hbase(main):022:0> Date.new(1218920189000).toString() => "Sat Aug 16
> 20:56:29 UTC 2008"
>
> St.Ack
>
>
>
> On Wed, Jul 28, 2010 at 7:30 PM, Ted Yu <yu...@gmail.com> wrote:
> > I assume we can convert the timestamp which is in .META. row:
> > MetaTable-0,,1280224961277 column=info:server, timestamp=1280252831805,
> > value=10.201.8.247:60020
> >
> > This is the last modification time, right ?
> >
> > On Wed, Jul 28, 2010 at 6:47 PM, Todd Lipcon <to...@cloudera.com> wrote:
> >
> >> Hi Ted,
> >>
> >> I don't think this info is recorded anywhere. You can probably check the
> >> FileStatus of its directory in HDFS, but it may not be correct in all
> >> cases.
> >>
> >> -Todd
> >>
> >> On Wed, Jul 28, 2010 at 4:31 PM, Ted Yu <yu...@gmail.com> wrote:
> >>
> >> > Hi,
> >> > I am looking for API that would tell me when a table was created.
> >> > I looked at HTable class but didn't find it.
> >> >
> >> > Thanks
> >> >
> >>
> >>
> >>
> >> --
> >> Todd Lipcon
> >> Software Engineer, Cloudera
> >>
> >
>
Re: find the date when table is created
Posted by Ryan Rawson <ry...@gmail.com>.
In theory maybe, if you mined the hadoop datanode logs and checked for
read on a block that you knew belonged to a specific region.
But generally speaking, no. And unlikely to as well. It's like atime
on filesystems. No one does that anymore.
On Tue, Aug 17, 2010 at 4:07 PM, Ted Yu <yu...@gmail.com> wrote:
> Is it possible to get the date/time when a region/table was last accessed ?
>
> Thanks
>
>
> On Wed, Jul 28, 2010 at 10:04 PM, Stack <st...@duboce.net> wrote:
>
>> Yes. Its time region was created. Here's how to get a date from the
>> timestamp inside shell:
>>
>> hbase(main):021:0> import java.util.Date
>> hbase(main):022:0> Date.new(1218920189000).toString() => "Sat Aug 16
>> 20:56:29 UTC 2008"
>>
>> St.Ack
>>
>>
>>
>> On Wed, Jul 28, 2010 at 7:30 PM, Ted Yu <yu...@gmail.com> wrote:
>> > I assume we can convert the timestamp which is in .META. row:
>> > MetaTable-0,,1280224961277 column=info:server, timestamp=1280252831805,
>> > value=10.201.8.247:60020
>> >
>> > This is the last modification time, right ?
>> >
>> > On Wed, Jul 28, 2010 at 6:47 PM, Todd Lipcon <to...@cloudera.com> wrote:
>> >
>> >> Hi Ted,
>> >>
>> >> I don't think this info is recorded anywhere. You can probably check the
>> >> FileStatus of its directory in HDFS, but it may not be correct in all
>> >> cases.
>> >>
>> >> -Todd
>> >>
>> >> On Wed, Jul 28, 2010 at 4:31 PM, Ted Yu <yu...@gmail.com> wrote:
>> >>
>> >> > Hi,
>> >> > I am looking for API that would tell me when a table was created.
>> >> > I looked at HTable class but didn't find it.
>> >> >
>> >> > Thanks
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> Todd Lipcon
>> >> Software Engineer, Cloudera
>> >>
>> >
>>
>