Metastore deployment modes:
There are three mode for metastore deployment in Hive Metastore.
– Local Mode:
Basically, as the main HiveServer process, the Hive metastore service runs in the same process, but make sure Hive metastore database runs in a separate process, as well as it can be on a separate host, in Local mode.
– Remote Mode:
Whereas, the Hive metastore service runs in its own JVM process. Some processes(HiveServer2, HCatalog, Cloudera Impala™,) communicate with it with the help of the Thrift network API, in Remote mode.
In comparison with the Local mode, there is one benefit of using the Remote mode, that is Remote mode does not need the administrator to share JDBC login information for the metastore database along with each Hive user, but local mode does.
To learn about Hive metastore modes in detail, follow the link: Hive Metastore – Different Ways to Configure Hive Metastore