Thanks. That was exactly the problem. How do I NOT use the local metastore? I want this table to be available when I am in other directories and also want it to be available to other users of the system.
On Tue, Jul 21, 2009 at 8:24 PM, Raghu Murthy<[email protected]> wrote: > 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 > > -- Vijay
