Reverse engineering from Hive database processing is slow due to the absence of system
tables. The required information is retrieved by manual parsing methods instead of a query language.
Our suggestion is you run the reverse engineer over a weekend. Please also see additional suggestions below (scroll down).
Figure 1
Some other things that can help the reverse engineer speed may be to filter on databases rather than reverse engineering ALL the databases (figure 2).
Figure 2.
Also, one customer reported that when they checked off partition and partition element, the process went through much faster for them (figure 3).
Figure 3.
