Thanks man. I added hive site and it worked. Thanks, Manickam P ________________________________ From: Nitin Pawar<mailto:[email protected]> Sent: 30-09-2013 05:35 PM To: [email protected]<mailto:[email protected]> Subject: Re: unable to create a table in hive
hive-site.xml will be placed under your hive conf directory. anyway, try using location flag to your ddl like below CREATE TABLE TABLE_A (EMPLOYEE_ID INT, EMPLOYEE_NAME STRING, EMPLOYEE_LOCATION STRING, EMPLOYEE_DEPT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE LOCATION '/home/storage/user/hive/ warehouse/TABLE_A' On Mon, Sep 30, 2013 at 5:17 PM, Manickam P <[email protected]> wrote: > Hi, > > I have given below the script i used. I've not used any hive site xml > here. > > CREATE TABLE TABLE_A (EMPLOYEE_ID INT, EMPLOYEE_NAME STRING, > EMPLOYEE_LOCATION STRING, EMPLOYEE_DEPT STRING) ROW FORMAT DELIMITED FIELDS > TERMINATED BY '|' STORED AS TEXTFILE; > > > Thanks, > Manickam P > > ------------------------------ > Date: Mon, 30 Sep 2013 17:11:12 +0530 > Subject: Re: unable to create a table in hive > From: [email protected] > To: [email protected] > > > Can you share your create table ddl and hive warehouse directory setting > from hive-site.xml ? > > > On Mon, Sep 30, 2013 at 4:57 PM, Manickam P <[email protected]>wrote: > > Guys, > > when i try to create a new table in hive i am getting the below error. > *FAILED: Error in metadata: MetaException(message:Got exception: > java.io.FileNotFoundException /user)* > *FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask* > > I've created direcotries in hdfs like /home/storate/tmp and > /home/storage/user/hive/warehouse and given permission but it is not taking > up. > > I'm having hdfs federated cluster with 2 name nodes. > > > does anyone have any idea? > > > > > Thanks, > Manickam P > > > > > -- > Nitin Pawar > -- Nitin Pawar
