It looks like you are using a local metastore and you started hive from a different location when you created the table vs when you are trying to query the table. Look for the directory metastore_db and start hive from its parent directory. That might fix the problem.
On 7/21/09 6:21 PM, "Vijay Kumar Adhikari" <[email protected]> wrote: > I had create a tables using hive and also uploaded some data using > 'data load infile'. I also queried that table and everything looked > fine at that point. I exited hive and logged in after some time and > the table is gone. My table is called 'netflow'. Here is what I get, > > hive> select distinct minute from netflow; > FAILED: Error in semantic analysis: line 1:28 Table not found netflow > hive> show tables; > OK > Time taken: 0.754 seconds > hive> > > I checked the /user/hive/warehouse/netflow folder and the files > uploaded using 'load data infile' are still there. What's wrong? How > do I get back that table? > > vijay...@master:~$ > vijay...@master:~$ bin/hadoop dfs -ls /user/hive/warehouse/netflow > Found 4 items > -rw-r--r-- 2 viadhi supergroup 36665382163 2009-07-17 18:52 > /user/hive/warehouse/netflow/09-00.txt > -rw-r--r-- 2 viadhi supergroup 35821700130 2009-07-18 08:25 > /user/hive/warehouse/netflow/09-01.txt > -rw-r--r-- 2 viadhi supergroup 34926258587 2009-07-18 19:34 > /user/hive/warehouse/netflow/09-02.txt > -rw-r--r-- 2 viadhi supergroup 33727615560 2009-07-19 09:15 > /user/hive/warehouse/netflow/09-03.txt > vijay...@master:~$ > > > -- > Vijay
