Problem with Upgrading hive

[pradeep T <it...@gmail.com>]

Hi ,

we are currently using hive Version 0.7.

our current Hadoop Version is .20.2 (CDH 3). We have successfully upgraded
the hadoop version from .20.2 to hadoop 1.1.2.

But after upgrading hadoop, our hive 0.7 had some compatibility problem
with the latest hadoop 1.1.2.

So thought of upgrading hive. After a few research in the net I could only
find this document to Upgrade from .7 to .8.

http://docs.aws.amazon.com/ElasticMapReduce/latest/DeveloperGuide/emr-hive-upgrade-metastore-mysql.html

The procedure for upgrade is to run few SQL scripts on the mysql metastore
DB. We are using mysql to store our metadata.

I have ran the script to upgrade from version .7 to .8.

Then from .8 to .9

Then from .9 to .10

After that took the upgraded sql dump and loaded to a new db created and
pointed that as the metastore location.

And restarted hive server and client. But after restarting when I give
"show tables;" command, I could see none of my old tables.

But when I create a new table it is getting created in the mentioned HDFS
path. But I was not able to see that new table in the Mysql metastore's
db's "TBLS" table too.

Just by logging to the Mysql, after selecting the required DB and If I give
mysql> select * from TBLS;. I am seeing all my old tables but not the new
one which I created after upgrade.

My questions are :

1) What should I do to make all my old tables to get reflected in hive ?

2) Where is my new table getting created and which metastore it is taking
to store the new tables ?


Thanks,
Pradeep