Running the Hive Upgrade Check tool
The Hive Strict Metastore Migration uses the public Hive Thrift API to materialize every table to determine if it needs to be upgraded. That process is very time consuming. If you are expediting the Hive upgrade process and modified the upgrade process to skip materialzing every table in the metastore, you need to identify databases and tables that are subject to the upgrade process and run HSMM on them or run provided scripts.
There are many reports from the Hive Upgrade Check process that should be run well in advance of the upgrade and used to clean up the Hive Metastore. Provide adequate time and planning to do this.