...
In local metastore setup, each Hive Client will open a connection to the datastore and make SQL queries against it. See Hive, Map-Reduce and Local-Mode for general information about using the metastore in local mode.
The following configuration will set up a metastore in a MySQL server. Make sure that the server is accessible from the machines where Hive queries are executed since this is a local store. Also make sure the JDBC client library is in the classpath of Hive Client.
...