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
