Better process or tools to deploy large number of Hive tables

Solution 1:

CREATE EXTERNAL TABLE and MSCK REPAIR/RECOVER PARTITIONS can be extremely slow because basic stats are gathered.

Try to disable statistics auto gathering before creating tables:

set hive.stats.autogather=false;