We've been running hive in the default derby single user mode for a while.
Now we've got more users interested in Hive and so would like to change the
metastore to run off of mysql. I was able to find a pretty easy tutorial
for doing this at this blog:
Before we pull the trigger...we have a couple concerns that are not clear
from the documentation
1) Since we already have a lot of tables in hive, if we switch to server
mode using mysql, will hive automatically rebuild the metadata?
2) If not, how do we rebuild the metadata from derby in mysql? Is there a
script we can use?
3) Any other gotchas we should be aware about?
I believe we are running 0.5.