Hello all!

I tried to create simple table in hive
> create table test (a string);

But its failed:
FAILED: Error in metadata: MetaException(message:Got exception:
java.io.FileNotFoundException File file:/user/hive/warehouse/test does not
exist.)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

I set up hadoop and hive locally from couderra distribution CDH3 on Ubuntu
12.04.
And use default settings.

What I do wrong?  How can I fix it?

Thank you!
Best regards
Mezentsev Pavel
Russia

try setting up location in create table statement and provide valid hdfs
path

On Sun, Jun 3, 2012 at 12:23 PM, Павел М��зенцев <[EMAIL PROTECTED]> wrote:

> Hello all!
>
> I tried to create simple table in hive
> > create table test (a string);
>
> But its failed:
> FAILED: Error in metadata: MetaException(message:Got exception:
> java.io.FileNotFoundException File file:/user/hive/warehouse/test does not
> exist.)
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
>
> I set up hadoop and hive locally from couderra distribution CDH3 on Ubuntu
> 12.04.
> And use default settings.
>
> What I do wrong?  How can I fix it?
>
> Thank you!
> Best regards
> Mezentsev Pavel
> Russia
>

--
Nitin Pawar

Did you setup the /usr/hive/warehouse directory in hdfs and do a chmod g+w on it? That would be required before you run any queries.

On Jun 3, 2012, at 1:53 AM, Павел Мезенцев <[EMAIL PROTECTED]> wrote:

> Hello all!
>
> I tried to create simple table in hive
> > create table test (a string);
>
> But its failed:
> FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/test does not exist.)
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
>
> I set up hadoop and hive locally from couderra distribution CDH3 on Ubuntu 12.04.
> And use default settings.
>
> What I do wrong?  How can I fix it?
>
> Thank you!
> Best regards
> Mezentsev Pavel
> Russia

Hi Pavel
    
The issue is some how your hive client is pointing to lfs rather than hdfs. There could be two possible reasons for this, first one amd the most likeliest one is  that your hdfs 'fs.default.name' points to file:/// instead of hdfs:// . In default the value of this property is 'file:///' you need to override this property ��in core-site.xml.

Second possibility is less likely, it can happen if you have overridden the value of hive.metastore.warehouse.dir in your hive-site.xml and the value is prefixed with 'file:///'

Regards
Bejoy KS
________________________________
 From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Sunday, June 3, 2012 8:20 PM
Subject: Re: FileNotFoundException
 
Did you setup the /usr/hive/warehouse directory in hdfs and do a chmod g+w on it? That would be required before you run any queries.

On Jun 3, 2012, at 1:53 AM, Павел М��зенцев <[EMAIL PROTECTED]> wrote:

> Hello all!
>
> I tried to create simple table in hive
> > create table test (a string);
>
> But its failed:
> FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/test does not exist.)
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
>
> I set up hadoop and hive locally from couderra distribution CDH3 on Ubuntu 12.04.
> And use default settings.
>
> What I do wrong?  How can I fix it?
>
> Thank you!
> Best regards
> Mezentsev Pavel
> Russia