Re: Table present in HDFS but 'show table' Returns Empty

2013-04-24 Thread Xun TANG
That's exactly why! Thank you so much. Alice On Mon, Apr 22, 2013 at 11:12 PM, Ramki Palle 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 differ

Re: Table present in HDFS but 'show table' Returns Empty

2013-04-22 Thread Ramki Palle
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 confi

Table present in HDFS but 'show table' Returns Empty

2013-04-22 Thread Xun TANG
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