Feature Request - Last Access Time

[devlucasc]

Is it possible to add a last access time property to identify the last time a table was accessed?

The advantage here is to identify and move a table for cold storage or to delete unused tables

[zsxwing]

This is a great feature. But the cost would be huge. We would need to store it in transaction logs. This means we would need to make a commit when a table is accessed. Alternatively, we can try to store the access time into Hive Metastore. But it won't work for people who access tables using a file path.

Do you have access logs for the storage? You can also use these logs to figure out the unused tables as well.

[devlucasc]

Hi @zsxwing Generally I use hive tables, I was thinking of use Hive metastore, because it already have this metadata field.