We currently run hive and store all our data in a warehouse on /user/hive/warehouse. Now we want to move the original warehouse from /user/hive/warehouse to new /user/hive/$USER/warehouse and retain all the data in the original warehouse. Is there a good way to do it?
Here is the background: We want multiple users to be able to create tables of same names. The use case is we have a development environment where multiple developers would use to access hive, but they would all use the same table namespace for testing/developing, etc. And we are overwriting hiveconf for both the warehouse root dir and the database name via the connection string. Thanks, Eva.
