[
https://issues.apache.org/jira/browse/HIVE-2526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146944#comment-16146944
]
Dmytro Sen commented on HIVE-2526:
----------------------------------
I you want lastAccessTime updated, just set
{code}
set hive.exec.pre.hooks =
org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec;
{code}
The hook will update LAST_ACCESS_TIME on every query as it was initially
implemented in HIVE-1819, so both commands will return non-zero lastAccessTime.
> "lastAceesTime" is always zero when executed through "describe extended
> <table_name>" unlike "show table extende like <table_name>" where
> lastAccessTime is updated.
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-2526
> URL: https://issues.apache.org/jira/browse/HIVE-2526
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.9.0
> Environment: Linux : SuSE 11 SP1
> Reporter: Rohith Sharma K S
> Assignee: Priyadarshini
> Priority: Minor
> Attachments: HIVE-2526.patch
>
>
> When the table is accessed(load),lastAccessTime is displaying updated
> accessTime in
> "show table extended like <table_name>".But "describe extended <table_name>"
> is always displaying zero.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
