Long compilation time of complex query due to analysis for materialized view rewrite

When compiling query the optimizer tries to rewrite the query plan or subtrees of the plan to use materialized view scans.

If

set hive.materializedview.rewriting.sql.subquery=false;

the compilation succeed in less then 10 sec otherwise it takes several minutes (~ 5min) depending on the hardware.