How to use hive with multiple users

Question

I have several users use the same hive.

Now i want each user to have a private metadata in hive.

example:

user a call show table : a1 , a2, a3 ...

user b call show table : b1 , b2 ,b3 ...

Of course when user run query they can not access table of other user.

thanks.

Answer 1

In order to make setup easy for new users, Hive's Metastore is configured to store metadata locally in an embedded Apache Derby database. Unfortunately, this configuration only allows a single user to access the Metastore at a time. Cloudera strongly encourages users to use a MySQL database instead. This section describes how to configure Hive to use a remote MySQL database, which allows Hive to support multiple users. See the Hive Metastore documentation for additional information.

For more details see the part with heading 'Configuring the Hive Metastore' here.