How to allow apache hive to handle multiple client

Question

I have created an external table via hive from hbase. When someone loged in to shell and deploy some queries , no one else can run any query. when someone try to run a quesry it gives following error.

FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

when first shell exits then queries can be run easily. So it means that my hive a cannot handle multiple clients. How to enables it to handle multiple clients

Answer 1

If you have not configured your Hive Metastore, its not possible for more than one user to access the Hive Server.

Embedded Metastore An embedded metastore is mainly used for unit tests. Only one process can connect to the metastore at a time, so it is not really a practical solution but works well for unit tests

Check this link for more information.