How to find time of last compute stats command on a table

[#1]

Hi,

Is there a way to find the time for last compute stats command on a given table in Impala?

[#2]

The client itself should tell you, ("Fetched 1 row(s) in 0.31s") or your can run "profile".

[#3]

I am not asking how to get total execution time. I want to know how to get the time when last compute stat was run. I tried describe formatted table but it doesn't show when was compute stat run on the table.

[#4]

I'm afraid it is currently not possible to determine the last time compute stats was run.

One possible workaround is to count(*) the current table and compare it with the numRows recorded in the stats. That does not yield the last time stats were computed, but it shows by how many rows the table has grown.

Depending on the ingest pattern, you might also use the lastDdlTime in the table and/or partition properties to get an estimate.

[#5]

Ok. We do have a workaround where we store the load job and its execution time in a table. Just wanted to know if something available out of the box.

Can you submit a feature request for the same?

[#6 · Accepted solution]

I agree that it is an important usability concern. I apologize for the inconvenience of having to track that information manually.

We filed the following JIRA to track progress on the issue. Thanks for your feedback!

https://issues.cloudera.org/browse/IMPALA-2942