[jira] [Commented] (HIVE-2526) "lastAceesTime" is always zero when executed through "describe extended " unlike "show table extende like " where lastAccessTime is updated.

["Namit Jain (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-2526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13166588#comment-13166588 ] 

Namit Jain commented on HIVE-2526:
----------------------------------

If we want to maintain the last access time, it should be at the metadata level (in the metastore),
and not computed dynamically.

Also, if you want to maintain the last access time, it should be done for both hive access and metastore access.
                
> "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: rohithsharma
>            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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira