Currently if you want multiple users to access the same metastore simulteneously, you will have to use mysql. See, http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin for details on different metastore configuration parameters.
On 7/21/09 6:29 PM, "Vijay Kumar Adhikari" <[email protected]> wrote: > 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
