I wonder if the message is misleading. Could there be a problem with the 
metastore. 

1. MySQL isn't running or the JDBC connection is wrong. 
2. You upgraded to a newer Hive and didn't migrate the metadata
3. ...?

I'm speculating here. Perhaps the logs have useful info. 

Dean

Sent from my rotary phone. 


On Aug 16, 2013, at 3:38 PM, Ankit Bhatnagar <ank...@yahoo-inc.com> wrote:

> 
> Query is pretty simple 
> 
> CREATE TABLE SRC(ID INT, NAME STRING);
> 
> Yes HADOOP_HOME is set
> 
> 
> From: Nitin Pawar <nitinpawar...@gmail.com>
> Date: Friday, August 16, 2013 12:49 PM
> To: Ankit Bhatnagar <ank...@yahoo-inc.com>
> Cc: "user@hive.apache.org" <user@hive.apache.org>
> Subject: Re: FAILED: Error in metadata: MetaException
> 
> Not sure what's wrong in your query but have you set variable "HADOOP_HOME" ? 
> 
> its deprecated in hadoop but needed in hive (as per my understanding) 
> 
> 
> On Sat, Aug 17, 2013 at 12:55 AM, Ankit Bhatnagar <ank...@yahoo-inc.com> 
> wrote:
>> Creating new table
>> 
>> From: Nitin Pawar <nitinpawar...@gmail.com>
>> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
>> Date: Friday, August 16, 2013 12:17 PM
>> To: "user@hive.apache.org" <user@hive.apache.org>
>> Subject: Re: FAILED: Error in metadata: MetaException
>> 
>> Can you tell us what  were you trying to do? 
>> create table? or executing a query on a table someone already created ? 
>> 
>> 
>> On Sat, Aug 17, 2013 at 12:32 AM, Ankit Bhatnagar <ank...@yahoo-inc.com> 
>> wrote:
>>> Hi folks,
>>> 
>>> 
>>> FAILED: Error in metadata: 
>>> MetaException(message:file:/user/hive/warehouse/src is not a directory or 
>>> unable to create one)
>>> 
>>> 
>>> drwxrwxrwx   - hadoop supergroup          0 2013-08-16 18:31 
>>> /user/hive/warehouse/src
>>> 
>>> 
>>> Is it some permission issue?
>>> 
>>> Ankit
>> 
>> 
>> 
>> -- 
>> Nitin Pawar
> 
> 
> 
> -- 
> Nitin Pawar

Reply via email to