Do you know where your metastore_db directory is? You need to launch hive in the directory where you find the metastore_db directory. This is where Hive keeps info about your tables.



On Oct 21, 2009, at 11:26 PM, yan xiaohui <[email protected]> wrote:

hi,I'a a beginner of hive,the problem is when I create a table by cli:
$ hive -e "create table abc(a int)";
I use  $hive -e "show tables;",which will show this table correctlly.

But when I do like following:
$hive
>show tables;
the output is like this:
OK
Time taken: 0.107 seconds


I inspect hdfs,and find /user/hive/warehouse/abc exsit,so why I cannot see it after login hive? (If I create a table after login hive,I cannot get it by hive -e "show tables;" too.)

the hive.log:
2009-10-22 10:50:48,475 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cann
ot be resolved.
2009-10-22 10:50:48,475 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cann
ot be resolved.
...

I use hive-0.4+hadoop-0.20.1,I tried hive-trunk,the problem is the same.
Any suggestions,I would be grateful!

Reply via email to