Created on 08-29-2018 03:51 PM - edited 09-16-2022 06:39 AM
I want to generate 'compute statistics <table_name>' commands for all non-partitoned tables that have not been analyzed for at least 1 month. If that information was available I would imagine it would be in the hive metastore database which the rest of the table metadata... however I cant find anything.
Thanks
Steve.
Created 08-31-2018 07:20 PM
Created 09-06-2018 01:27 PM
Thanks. Well yes I think it is what I need however.... it seems some of my tables have that date changing multiple times during a day. I looked at navigator to try and track down who may have been issuing 'COMPUTE STATS' commands but found nothing.
To make the whole picture even stranger is the fact that the table is replicated at the database level using BDR. But the master metadata is different from the target metadata. The target table is the one I am looking at, this is the one getting update multiple times a day.
Any suggestions on how to find what is making this LAST_ANALYZED timestamp to increment all the time ?