hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From VanHuy Pham <>
Subject Re: getting Hive table access times
Date Mon, 02 Jul 2012 18:24:33 GMT
I think it only makes sense to use getLastAccessTime() when you have
already used setLastAccessTime() MANUALLY, otherwise hive does not
automatically set the access time in its metastore. Correct me if I am

On Mon, Jul 2, 2012 at 4:46 AM, Stephen R. Scaffidi <> wrote:

> On 06/28/2012 09:28 AM, Stephen R. Scaffidi wrote:
>> I've written some code where I am trying to get the atime of my tables in
>> Hive. It's fairly simple - the method call in question is simply:
>>   int atime = htable.getLastAccessTime();
>> Where htable is an otherwise normal org.apache.hadoop.hive.**metastore.api.Table
>> object.
>> The question is this: does hive or hadoop store the atime of the table in
>> some metadata or does it rely on the filesystem?
>> I ask this because I am getting 0 as the value for every table in my
>> cluster, and have just realized that the filesystem is mounted with noatime!
>> A secondary question is - if I can not get the atime using this API call,
>> is there another way to find out when a table was last accessed? How?
> Bump - should I be asking this on a different list?

View raw message