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

Switch to Plain View
Hive >> mail # user >> Table present in HDFS but 'show table' Returns Empty

Xun TANG 2013-04-23, 04:48
Copy link to this message
Re: Table present in HDFS but 'show table' Returns Empty
May be you are using derby as your metastore. It creates the metastore in
the current directory from where you started your hive session. You may
have started your hive session from a different directory next time.

Please use either mysql as your metastore or set a definite directory in
your config file as your metastore if you continue to use derby as your
meta store.

On Mon, Apr 22, 2013 at 9:48 PM, Xun TANG <[EMAIL PROTECTED]> wrote:

> Hi guys,
> I've created hive tables via 'hive -f' or hive interactive shell. Data are
> loaded to tables right after, so the tables are not empty. However, when I
> log out and log in to hive shell again, 'show tables' return 0 table, while
> 'hadoop list' command shows the hdfs files are still where they were.
> So my questions are,
> 1. What triggered hive to 'forget' the tables?
> 2. How to make hive permanently (or within the lifecycle of hadoop
> daemons) remember the tables until they were dropped?
> This problem has puzzled me for a while, and I could not find similar
> question/answer online... Did I miss some configuration?
> Thanks,
> Alice
Xun TANG 2013-04-24, 16:49