Data warehouse infrastructure that provides data summarization and ad hoc querying.
When using external MySQL do not forget to grant root at metastore:
MariaDB [(none)]> GRANT ALL ON *.* TO 'root'@'metastore_fqdn' identified by 'password' WITH GRANT OPTION;