You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Vijay Kumar Adhikari <vi...@gmail.com> on 2009/07/22 03:21:14 UTC
table gone?
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?
vijaykcm@master:~$
vijaykcm@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
vijaykcm@master:~$
--
Vijay
Re: table gone?
Posted by Raghu Murthy <rm...@facebook.com>.
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" <vi...@gmail.com> 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<rm...@facebook.com> 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" <vi...@gmail.com> 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?
>>>
>>> vijaykcm@master:~$
>>> vijaykcm@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
>>> vijaykcm@master:~$
>>>
>>>
>>> --
>>> Vijay
>>
>>
>
>
>
> --
> Vijay
Re: table gone?
Posted by Vijay Kumar Adhikari <vi...@gmail.com>.
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<rm...@facebook.com> 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" <vi...@gmail.com> 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?
>>
>> vijaykcm@master:~$
>> vijaykcm@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
>> vijaykcm@master:~$
>>
>>
>> --
>> Vijay
>
>
--
Vijay
Re: table gone?
Posted by Raghu Murthy <rm...@facebook.com>.
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" <vi...@gmail.com> 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?
>
> vijaykcm@master:~$
> vijaykcm@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
> vijaykcm@master:~$
>
>
> --
> Vijay