Hi,

I was successfully running command
SHOW TABLES;
which was viewing tables created @HDFS.
I was doing operations on hive suddenly i lost all tables. But all tables
are showing in warehouse.
It seems some configuration error but exact solution is yet to know.
Any idea?

Regards,
Ashish

Are you using Derby? Did you change directories? By default, Derby drops
the metastore_db in the current directory, but you can specify an absolute
path for it in the hive-site.xml config file, e.g.,:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:derby:;databaseName=/path/to/metastore_db;create=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

On Tue, Jan 22, 2013 at 6:16 AM, ashish negi <[EMAIL PROTECTED]>wrote:

> Hi,
>
> I was successfully running command
> SHOW TABLES;
> which was viewing tables created @HDFS.
> I was doing operations on hive suddenly i lost all tables. But all tables
> are showing in warehouse.
> It seems some configuration error but exact solution is yet to know.
> Any idea?
>
> Regards,
> Ashish
>

--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330