At start-up, HiveServer2 will do a full DB & Table scan. For large Hive Metastores, this operation could take 10+ minutes to complete. The goal of this task is to make this “verification” optional if possible.
Currently, Hive 2.3.7 has the following in HiveMaterializedViewsRegistry that is causing this behavior.
It seems that <= Hive 2.3.x && >= Hive 3.0 does not have this behavior.