Hi all, 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:
http://blog.milford.io/2010/06/installing-apache-hive-with-a-mysql-metastore-in-centos/ 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. Thanks!
