FAQ
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!

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
groupuser @
categorieshive, hadoop
postedJan 5, '11 at 10:32p
activeJan 6, '11 at 6:48p
posts2
users2
websitehive.apache.org

2 users in discussion

David Burley: 1 post Chris Bates: 1 post

People

Translate

site design / logo © 2021 Grokbase