Im trying to upgrade from hadoop .18 to .20 as well as upgrade hive from .4 to .5 and switch the metastore from derby to mysql. The hadoop upgrade went smoothly but when i try and connect to it with hive via the .4 version on derby i get the following:
java.sql.SQLSyntaxErrorException: Table/View 'NUCLEUS_TABLES' does not exist.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
What is the best approach for upgrading hive and getting the metastore moved over from derby to mysql?