You need to upgrade your metadata database in order to let the new hive code work.
Here is the link: http://wiki.apache.org/hadoop/Hive/IndexDev#Metastore_Upgrades On Tue, Aug 10, 2010 at 3:51 PM, Leo Alekseyev <[email protected]> wrote: > I built hive from SVN, and am running into the following issue: I > can't seem to access any of my old tables, that is, SHOW TABLES > doesn't return any entries. I can create new tables, and they show up > in HDFS in /user/hive/warehouse alongside the old ones. Likewise, > when I run the old version of hive, it doesn't see the tables created > with the new version. It seems that the new and the old hive binary > are using two separate databases. In hive-default.xml for both > versions I have > <property> > <name>javax.jdo.option.ConnectionURL</name> > <value>jdbc:derby:;databaseName=metastore_db;create=true</value> > > Can anyone tell me how to make the two versions of hive use the same > metastore database?... or at least how to import my old tables into > the metastore db for the new hive version? > > Thanks, > --Leo >
