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
