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 <ashishnegioff...@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
