You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Jeff Hammerbacher <ha...@cloudera.com> on 2009/01/23 09:49:37 UTC
Problem loading data from local file
Hey,
I've executed this "LOAD DATA" statement a number of times before and never
had this issue. When I drop into the shell, I can see the file I'm trying to
load. Hive can't, however; any ideas on what's going on? I'd love to get
tips on how to debug this problem as well.
hive > LOAD DATA LOCAL INPATH 'ml-data/u.data' OVERWRITE INTO TABLE
u_data;
FAILED: Error in semantic analysis: line 3:23 Invalid Path 'ml-data/u.data':
No files matching path
hive > !ls ml-data;
...
u.data
...
Thanks,
Jeff
RE: Problem loading data from local file
Posted by Ashish Thusoo <at...@facebook.com>.
Can you try giving the complete path instead of the relative path?
Ashish
________________________________________
From: Jeff Hammerbacher [hammer@cloudera.com]
Sent: Friday, January 23, 2009 12:49 AM
To: hive-user@hadoop.apache.org
Subject: Problem loading data from local file
Hey,
I've executed this "LOAD DATA" statement a number of times before and never had this issue. When I drop into the shell, I can see the file I'm trying to load. Hive can't, however; any ideas on what's going on? I'd love to get tips on how to debug this problem as well.
hive > LOAD DATA LOCAL INPATH 'ml-data/u.data' OVERWRITE INTO TABLE u_data;
FAILED: Error in semantic analysis: line 3:23 Invalid Path 'ml-data/u.data': No files matching path
hive > !ls ml-data;
...
u.data
...
Thanks,
Jeff
Re: Problem loading data from local file
Posted by Jeff Hammerbacher <ha...@cloudera.com>.
Hey Joy and Prasad,
The value of fs.default.name was:
hive> SET fs.default.name;
fs.default.name=hdfs://localhost:9000
After applying Joy's patch, things worked. I get it now, thanks for the
reference on where to check when this isn't working.
Later,
Jeff
On Fri, Jan 23, 2009 at 8:52 AM, Prasad Chakka <pr...@facebook.com> wrote:
> What is the value of config param fs.default.name?
>
>
> ------------------------------
> *From: *Joydeep Sen Sarma <js...@facebook.com>
> *Reply-To: *<hi...@hadoop.apache.org>
> *Date: *Fri, 23 Jan 2009 08:39:56 -0800
> *To: *<hi...@hadoop.apache.org>
> *Subject: *RE: Problem loading data from local file
>
> There was a small change to the Load command a couple of days back (to fix
> a different problem) and it's triggering this.
>
> Can you apply the attached patch and check that it works.
>
> There's no extra logging here – so looking at the code was the only option
> ..
>
>
> ------------------------------
>
> *From:* Jeff Hammerbacher [mailto:hammer@cloudera.com<ha...@cloudera.com>]
>
> *Sent:* Friday, January 23, 2009 12:50 AM
> *To:* hive-user@hadoop.apache.org
> *Subject:* Problem loading data from local file
>
> Hey,
>
> I've executed this "LOAD DATA" statement a number of times before and never
> had this issue. When I drop into the shell, I can see the file I'm trying to
> load. Hive can't, however; any ideas on what's going on? I'd love to get
> tips on how to debug this problem as well.
>
> hive > LOAD DATA LOCAL INPATH 'ml-data/u.data' OVERWRITE INTO TABLE u_data;
>
> FAILED: Error in semantic analysis: line 3:23 Invalid Path
> 'ml-data/u.data': No files matching path
> hive > !ls ml-data;
> ...
> u.data
> ...
>
> Thanks,
> Jeff
>
>
Re: Problem loading data from local file
Posted by Prasad Chakka <pr...@facebook.com>.
What is the value of config param fs.default.name?
________________________________
From: Joydeep Sen Sarma <js...@facebook.com>
Reply-To: <hi...@hadoop.apache.org>
Date: Fri, 23 Jan 2009 08:39:56 -0800
To: <hi...@hadoop.apache.org>
Subject: RE: Problem loading data from local file
There was a small change to the Load command a couple of days back (to fix a different problem) and it's triggering this.
Can you apply the attached patch and check that it works.
There's no extra logging here - so looking at the code was the only option ..
________________________________
From: Jeff Hammerbacher [mailto:hammer@cloudera.com]
Sent: Friday, January 23, 2009 12:50 AM
To: hive-user@hadoop.apache.org
Subject: Problem loading data from local file
Hey,
I've executed this "LOAD DATA" statement a number of times before and never had this issue. When I drop into the shell, I can see the file I'm trying to load. Hive can't, however; any ideas on what's going on? I'd love to get tips on how to debug this problem as well.
hive > LOAD DATA LOCAL INPATH 'ml-data/u.data' OVERWRITE INTO TABLE u_data;
FAILED: Error in semantic analysis: line 3:23 Invalid Path 'ml-data/u.data': No files matching path
hive > !ls ml-data;
...
u.data
...
Thanks,
Jeff
RE: Problem loading data from local file
Posted by Joydeep Sen Sarma <js...@facebook.com>.
There was a small change to the Load command a couple of days back (to fix a different problem) and it's triggering this.
Can you apply the attached patch and check that it works.
There's no extra logging here - so looking at the code was the only option ..
________________________________
From: Jeff Hammerbacher [mailto:hammer@cloudera.com]
Sent: Friday, January 23, 2009 12:50 AM
To: hive-user@hadoop.apache.org
Subject: Problem loading data from local file
Hey,
I've executed this "LOAD DATA" statement a number of times before and never had this issue. When I drop into the shell, I can see the file I'm trying to load. Hive can't, however; any ideas on what's going on? I'd love to get tips on how to debug this problem as well.
hive > LOAD DATA LOCAL INPATH 'ml-data/u.data' OVERWRITE INTO TABLE u_data;
FAILED: Error in semantic analysis: line 3:23 Invalid Path 'ml-data/u.data': No files matching path
hive > !ls ml-data;
...
u.data
...
Thanks,
Jeff