Hive multiple users on same tables

Question

is that possible to have tables that are shared in hive. I mean a user creates a hive table. Later multiple users can work on that same table simultaneously.

I heard about derby and individual metastore for each users. But individual metastore option does not allow users to work simultaneously on same set of tables right?

Is there any other way to work on this?

Because when we try to access hive at the same time, we get the following error-

Caused by: ERROR XSDB6: Another instance of Derby may have already booted the da tabase /root/metastore_db.

Answer 1

ERROR XSDB6: Another instance of Derby may have already booted the da tabase /root/metastore_db.

This error can occur when you are trying to start more than one instance of hive shell. The lock may sustain in background (due to improper disconnection) even after closing tab/terminal.

Solution is to find the process using grep

ps aux | grep hive

Now, kill the process using,

kill -9 hive_process_id (ex: kill -9 21765)

Restart the hive shell. It works fine.

Answer 2

I use Ubuntu and this error occurred when i opened hive from same location in two separate terminal windows. This would be interpreted as multiple users by the system. Close one of the terminal windows/tabs and that should do the trick.