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