hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anja Gruenheid <anja.gruenh...@gatech.edu>
Subject Re: Create Table Error
Date Tue, 22 Mar 2011 12:54:05 GMT
Hi!

Where (and what) exactly do I have to set it? I added HADOOP_CONF_DIR to 
the path variables and to the source folders in the build path, but it 
doesn't work.

Thanks,
Anja


On 03/22/2011 04:48 AM, Thiruvel Thirumoolan wrote:
> Looks like your IDE classpath does not include HADOOP_CONF_DIR.  Your warehouse and tmp
dirs are in Hadoop and the table dir creation failures are in local file system.
>
> On Mar 22, 2011, at 4:40 AM, Anja Gruenheid wrote:
>
>> Hi!
>>
>> I've tried to run a create table statement via the HiveCLI in Eclipse
>> and it fails with the following exception:
>> FAILED: Error in metadata: MetaException(message:Got exception:
>> java.io.FileNotFoundException File file:/user/hive/warehouse/customer
>> does not exist.)
>> 11/03/21 19:05:36 ERROR exec.DDLTask: FAILED: Error in metadata:
>> MetaException(message:Got exception: java.io.FileNotFoundException File
>> file:/user/hive/warehouse/customer does not exist.)
>> org.apache.hadoop.hive.ql.metadata.HiveException:
>> MetaException(message:Got exception: java.io.FileNotFoundException File
>> file:/user/hive/warehouse/customer does not exist.)
>>
>> If I run the same create statement with the same Hive project on command
>> line, I can create the table without problems. The statement is:
>> create table customer (C_CUSTKEY INT, C_NAME STRING, C_ADDRESS STRING,
>> C_NATIONKEY INT, C_PHONE STRING, C_ACCTBAL DOUBLE, C_MKTSEGMENT STRING,
>> C_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED
>> AS TEXTFILE;
>>
>> I have set up the /tmp and /user/hive/warehouse directories in Hadoop as
>> instructed in the wiki and the access rights are also set accordingly. I
>> also set the hive.metastore.warehouse.dir parameter in my hive-site.xml
>> to /user/hive/warehouse.
>>
>> Does anyone have an idea?
>>
>> Thanks,
>> Anja


Mime
View raw message