Compare differences between Local Metastore and Remote Metastore

Answer»

Local Metastore	Remote Metastore
Local metastore is a metastore service that RUNS in the same JVM in which the Hive service is running.	Remote Metastore has its own SEPARATE JVM which runs with its own JVM process.
It can ALSO connect to a separate database running in a separate JVM in the same or separate machine.	The MAIN advantage of remote mode over Local mode is that Remote mode does not acquire the administrator to share JDBC login information for the metastore database.

Discussion