Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

Hi,

 

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

1 ACCEPTED SOLUTION

avatar

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

 

 

 

View solution in original post

5 REPLIES 5

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

avatar
Contributor

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.

avatar

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.

avatar
Contributor

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?

avatar

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