Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

Hi,

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

Master Collaborator

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

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

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

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

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.

Highlighted

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

Master Collaborator

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.

Highlighted

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

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?

Highlighted

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

Master Collaborator

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

Don't have an account?
Coming from Hortonworks? Activate your account here