You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by mahsa mofidpoor <mo...@gmail.com> on 2012/03/30 00:59:26 UTC

file creation error

Hi
When I try to create any tables, I receive this message:

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

Does anybody know how to fix it?
Thank you in advance for your reply

Mahsa

Re: file creation error

Posted by thejas murthy <th...@gmail.com>.
Hi,

If your HDFS path already exists it should be a permission issue.
Check the permissions "hadoop fs -ls /user/hive"

Thejas

On Fri, Mar 30, 2012 at 10:43 AM, Kirk True <ki...@mustardgrain.com> wrote:

> The path "/user/hive/warehouse" is usually on HDFS, not your local file
> system. Check your default FS root (can't remember the parameter name
> ottomh).
>
>
> On 3/29/12 3:59 PM, mahsa mofidpoor wrote:
>
>> Hi
>> When I try to create any tables, I receive this message:
>>
>> FAILED: Error in metadata: MetaException(message:Got exception:
>> java.io.FileNotFoundException File file:/user/hive/warehouse/**table_name
>> does not exist.)
>> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.**
>> exec.DDLTask
>>
>> Does anybody know how to fix it?
>> Thank you in advance for your reply
>>
>> Mahsa
>>
>

Re: file creation error

Posted by Kirk True <ki...@mustardgrain.com>.
The path "/user/hive/warehouse" is usually on HDFS, not your local file 
system. Check your default FS root (can't remember the parameter name 
ottomh).

On 3/29/12 3:59 PM, mahsa mofidpoor wrote:
> Hi
> When I try to create any tables, I receive this message:
>
> FAILED: Error in metadata: MetaException(message:Got exception: 
> java.io.FileNotFoundException File 
> file:/user/hive/warehouse/table_name does not exist.)
> FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.DDLTask
>
> Does anybody know how to fix it?
> Thank you in advance for your reply
>
> Mahsa