You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by yongqiang he <he...@gmail.com> on 2010/08/11 01:03:42 UTC

Re: Lost old tables in hive metastore after installing a new version of hive

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 <dn...@gmail.com> 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
>