Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Missing tables!


+
ashish negi 2013-01-22, 12:16
Copy link to this message
-
Re: Missing tables!
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