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:
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
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
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