hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thiruvel Thirumoolan <thiru...@yahoo-inc.com>
Subject Re: Create Table Error
Date Tue, 22 Mar 2011 08:48:45 GMT
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