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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 >> >> >> > >> >
