Re: unable to create a table in hive
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 manicka...@outlook.com 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
RE: unable to create a table in hive
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: nitinpawar...@gmail.com To: user@hive.apache.org 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 manicka...@outlook.com 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
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 manicka...@outlook.com 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: nitinpawar...@gmail.com To: user@hive.apache.org 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 manicka...@outlook.comwrote: 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
RE: unable to create a table in hive
Thanks man. I added hive site and it worked. Thanks, Manickam P From: Nitin Pawarmailto:nitinpawar...@gmail.com Sent: 30-09-2013 05:35 PM To: user@hive.apache.orgmailto:user@hive.apache.org 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 manicka...@outlook.com 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: nitinpawar...@gmail.com To: user@hive.apache.org 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 manicka...@outlook.comwrote: 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