That's exactly why! Thank you so much. Alice
On Mon, Apr 22, 2013 at 11:12 PM, Ramki Palle <ramki.pa...@gmail.com> wrote: > 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 >> > >
