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. Regards, Ramki. On Mon, Apr 22, 2013 at 9:48 PM, Xun TANG <tangxun.al...@gmail.com> 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 >
