hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From VanHuy Pham <huy.pham...@gmail.com>
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
wrong!

On Mon, Jul 2, 2012 at 4:46 AM, Stephen R. Scaffidi <
sscaffidi@tripadvisor.com> 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?
>

Mime
View raw message