Query is pretty simple CREATE TABLE SRC(ID INT, NAME STRING);
Yes HADOOP_HOME is set From: Nitin Pawar <nitinpawar...@gmail.com<mailto:nitinpawar...@gmail.com>> Date: Friday, August 16, 2013 12:49 PM To: Ankit Bhatnagar <ank...@yahoo-inc.com<mailto:ank...@yahoo-inc.com>> Cc: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto: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<mailto:ank...@yahoo-inc.com>> wrote: Creating new table From: Nitin Pawar <nitinpawar...@gmail.com<mailto:nitinpawar...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Friday, August 16, 2013 12:17 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto: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<mailto: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