hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <dean.wamp...@thinkbiganalytics.com>
Subject Re: Missing tables!
Date Tue, 22 Jan 2013 13:56:00 GMT
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 <ashishnegioffice@gmail.com>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

Mime
View raw message