question Re: How to find time of last compute stats command on a table in Archives of Support Questions (Read Only)

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

daai_evangelist — Fri, 16 Sep 2022 10:01:52 GMT

Hi,

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

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

jbapple — Wed, 03 Feb 2016 20:32:23 GMT

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

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

daai_evangelist — Wed, 03 Feb 2016 22:36:59 GMT

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.

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

alex.behm — Wed, 03 Feb 2016 23:04:43 GMT

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.

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

daai_evangelist — Wed, 03 Feb 2016 23:12:53 GMT

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?

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

alex.behm — Thu, 04 Feb 2016 00:30:59 GMT

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