Hello

I have been stuck on this issue for quite some time and was wondering if anyone sees any problem with this that i am not seeing:

I have verified the file exists here and have also manually pasted the file into the tmp folder but still running into the same issue.

I am also wondering which folder this maps to in my local drive:
hdfs://ubuntu:9000/

***********************************
hive> LOAD DATA INPATH '/tmp/o_small.tsv' OVERWRITE INTO TABLE odata ;
FAILED: SemanticException Line 1:17 Invalid path ''/tmp/o_small.tsv'': No files matching path hdfs://ubuntu:9000/tmp/o_small.tsv

***********************************
I have verified the file exists here and have also manually pasted the file here but still running into the same issue.
Please let me know if u have any suggestions will be really appreciated.
Thanks
Sai

this file /tmp/o_small.tsv is on your local filesystem or hdfs?
On Tue, Mar 5, 2013 at 5:39 PM, Sai Sai <[EMAIL PROTECTED]> wrote:

> Hello
>
> I have been stuck on this issue for quite some time and was wondering if
> anyone sees any problem with this that i am not seeing:
>
> I have verified the file exists here and have also manually pasted the
> file into the tmp folder but still running into the same issue.
>
> I am also wondering which folder this maps to in my local drive:
> hdfs://ubuntu:9000/
>
> ***********************************
>
> hive> LOAD DATA INPATH '/tmp/o_small.tsv' OVERWRITE INTO TABLE odata ;
> FAILED: SemanticException Line 1:17 Invalid path ''/tmp/o_small.tsv'': No
> files matching path hdfs://ubuntu:9000/tmp/o_small.tsv
>
> ***********************************
> I have verified the file exists here and have also manually pasted the
> file here but still running into the same issue.
> Please let me know if u have any suggestions will be really appreciated.
> Thanks
> Sai
>

--
Nitin Pawar

Yes Nitin it exists... but still getting the same issue.
________________________________
 From: Nitin Pawar <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
Sent: Tuesday, 5 March 2013 4:14 AM
Subject: Re: SemanticException Line 1:17 issue
 

this file /tmp/o_small.tsv is on your local filesystem or hdfs? 

On Tue, Mar 5, 2013 at 5:39 PM, Sai Sai <[EMAIL PROTECTED]> wrote:

Hello
>
>
>I have been stuck on this issue for quite some time and was wondering if anyone sees any problem with this that i am not seeing:
>
>
>I have verified the file exists here and have also manually pasted the file into the tmp folder but still running into the same issue.
>
>
>I am also wondering which folder this maps to in my local drive:
>hdfs://ubuntu:9000/
>
>
>***********************************
>
>
>hive> LOAD DATA INPATH '/tmp/o_small.tsv' OVERWRITE INTO TABLE odata ;
>FAILED: SemanticException Line 1:17 Invalid path ''/tmp/o_small.tsv'': No files matching path hdfs://ubuntu:9000/tmp/o_small.tsv
>
>
>***********************************
>I have verified the file exists here and have also manually pasted the file here but still running into the same issue.
>Please let me know if u have any suggestions will be really appreciated.
>ThanksSai
>
--
Nitin Pawar

it exists but where? on your hdfs or local linux filesystem ?  so if you
are checking the file with ls -l /tmp/ then add word local

ls can you provide output of $HADOOP_HOME/bin/hadoop dfs -ls /tmp/

LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename

If the keyword LOCAL is specified, then:

   - the load command will look for *filepath* in the local file
system. If a relative path is specified - it will be interpreted
relative to the current directory of the user

On Tue, Mar 5, 2013 at 5:48 PM, Sai Sai <[EMAIL PROTECTED]> wrote:

> Yes Nitin it exists... but still getting the same issue.
>
>   ------------------------------
> *From:* Nitin Pawar <[EMAIL PROTECTED]>
> *To:* [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
> *Sent:* Tuesday, 5 March 2013 4:14 AM
> *Subject:* Re: SemanticException Line 1:17 issue
>
> this file /tmp/o_small.tsv is on your local filesystem or hdfs?
>
>
> On Tue, Mar 5, 2013 at 5:39 PM, Sai Sai <[EMAIL PROTECTED]> wrote:
>
> Hello
>
> I have been stuck on this issue for quite some time and was wondering if
> anyone sees any problem with this that i am not seeing:
>
> I have verified the file exists here and have also manually pasted the
> file into the tmp folder but still running into the same issue.
>
> I am also wondering which folder this maps to in my local drive:
> hdfs://ubuntu:9000/
>
> ***********************************
>
> hive> LOAD DATA INPATH '/tmp/o_small.tsv' OVERWRITE INTO TABLE odata ;
> FAILED: SemanticException Line 1:17 Invalid path ''/tmp/o_small.tsv'': No
> files matching path hdfs://ubuntu:9000/tmp/o_small.tsv
>
> ***********************************
> I have verified the file exists here and have also manually pasted the
> file here but still running into the same issue.
> Please let me know if u have any suggestions will be really appreciated.
> Thanks
> Sai
>
>
>
>
> --
> Nitin Pawar
>
>
>
--
Nitin Pawar

Thanks for your help Nitin, here is what it displays:

satish@ubuntu:~/work/hadoop-1.0.4/bin$ $HADOOP_HOME/bin/hadoop dfs -ls /tmp/
Warning: $HADOOP_HOME is deprecated.
Found 3 items

drwxr-xr-x   - satish supergroup          0 2013-03-05 04:12 /tmp/hive-satish
-rw-r--r--   1 satish supergroup        654 2013-03-04 02:41 /tmp/states.txt
drwxr-xr-x   - satish supergroup          0 2013-02-16 00:46 /tmp/temp-1850940621

**************
I have done a search for the file states.txt and it refers to 3 places 2 of em refer to
proc/2693/cwd

but none of them refer to tmp folder.

Please let me know if you have any other suggestions.
In the meantime i will try with the [LOCAL] file and let you know.

Thanks
Sai

________________________________
 From: Nitin Pawar <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
Sent: Tuesday, 5 March 2013 4:24 AM
Subject: Re: SemanticException Line 1:17 issue
 

it exists but where? on your hdfs or local linux filesystem ?  so if you are checking the file with ls -l /tmp/ then add word local

ls can you provide output of $HADOOP_HOME/bin/hadoop dfs -ls /tmp/ 
LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename
If the keyword LOCAL is specified, then:
* the load command will look for filepath in the local file system. If a relative path is specified - it will be interpreted relative to the current directory of the user

On Tue, Mar 5, 2013 at 5:48 PM, Sai Sai <[EMAIL PROTECTED]> wrote:

Yes Nitin it exists... but still getting the same issue.
>
>
>
>
>________________________________
> From: Nitin Pawar <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
>Sent: Tuesday, 5 March 2013 4:14 AM
>Subject: Re: SemanticException Line 1:17 issue
>
>
>
>this file /tmp/o_small.tsv is on your local filesystem or hdfs? 
>
>
>
>On Tue, Mar 5, 2013 at 5:39 PM, Sai Sai <[EMAIL PROTECTED]> wrote:
>
>Hello
>>
>>
>>I have been stuck on this issue for quite some time and was wondering if anyone sees any problem with this that i am not seeing:
>>
>>
>>I have verified the file exists here and have also manually pasted the file into the tmp folder but still running into the same issue.
>>
>>
>>I am also wondering which folder this maps to in my local drive:
>>hdfs://ubuntu:9000/
>>
>>
>>***********************************
>>
>>
>>hive> LOAD DATA INPATH '/tmp/o_small.tsv' OVERWRITE INTO TABLE odata ;
>>FAILED: SemanticException Line 1:17 Invalid path ''/tmp/o_small.tsv'': No files matching path hdfs://ubuntu:9000/tmp/o_small.tsv
>>
>>
>>***********************************
>>I have verified the file exists here and have also manually pasted the file here but still running into the same issue.
>>Please let me know if u have any suggestions will be really appreciated.
>>ThanksSai
>>
>
>
>
>--
>Nitin Pawar
>
>
>
--
Nitin Pawar

this file /tmp/o_small.tsv looks like is existing on your local filesystem

try load data local inpath

it should work
On Tue, Mar 5, 2013 at 6:12 PM, Sai Sai <[EMAIL PROTECTED]> wrote:

> Thanks for your help Nitin, here is what it displays:
>
> satish@ubuntu:~/work/hadoop-1.0.4/bin$ $HADOOP_HOME/bin/hadoop dfs -ls
> /tmp/
>
> Warning: $HADOOP_HOME is deprecated.
> Found 3 items
>
> drwxr-xr-x   - satish supergroup          0 2013-03-05 04:12
> /tmp/hive-satish
> -rw-r--r--   1 satish supergroup        654 2013-03-04 02:41
> /tmp/states.txt
> drwxr-xr-x   - satish supergroup          0 2013-02-16 00:46
> /tmp/temp-1850940621
>
> **************
> I have done a search for the file states.txt and it refers to 3 places 2
> of em refer to
> proc/2693/cwd
>
> but none of them refer to tmp folder.
>
> Please let me know if you have any other suggestions.
> In the meantime i will try with the [LOCAL] file and let you know.
> Thanks
> Sai
>
>   ------------------------------
> *From:* Nitin Pawar <[EMAIL PROTECTED]>
> *To:* [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
> *Sent:* Tuesday, 5 March 2013 4:24 AM
>
> *Subject:* Re: SemanticException Line 1:17 issue
>
> it exists but where? on your hdfs or local linux filesystem ?  so if you
> are checking the file with ls -l /tmp/ then add word local
>
> ls can you provide output of $HADOOP_HOME/bin/hadoop dfs -ls /tmp/
>
> LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename
>
> If the keyword LOCAL is specified, then:
>
>    - the load command will look for *filepath* in the local file system. If a relative path is specified - it will be interpreted relative to the current directory of the user
>
>
>
> On Tue, Mar 5, 2013 at 5:48 PM, Sai Sai <[EMAIL PROTECTED]> wrote:
>
> Yes Nitin it exists... but still getting the same issue.
>
>    ------------------------------
> *From:* Nitin Pawar <[EMAIL PROTECTED]>
> *To:* [EMAIL PROTECTED]; Sai Sai <[EMAIL PROTECTED]>
> *Sent:* Tuesday, 5 March 2013 4:14 AM
> *Subject:* Re: SemanticException Line 1:17 issue
>
> this file /tmp/o_small.tsv is on your local filesystem or hdfs?
>
>
> On Tue, Mar 5, 2013 at 5:39 PM, Sai Sai <[EMAIL PROTECTED]> wrote:
>
> Hello
>
> I have been stuck on this issue for quite some time and was wondering if
> anyone sees any problem with this that i am not seeing:
>
> I have verified the file exists here and have also manually pasted the
> file into the tmp folder but still running into the same issue.
>
> I am also wondering which folder this maps to in my local drive:
> hdfs://ubuntu:9000/
>
> ***********************************
>
> hive> LOAD DATA INPATH '/tmp/o_small.tsv' OVERWRITE INTO TABLE odata ;
> FAILED: SemanticException Line 1:17 Invalid path ''/tmp/o_small.tsv'': No
> files matching path hdfs://ubuntu:9000/tmp/o_small.tsv
>
> ***********************************
> I have verified the file exists here and have also manually pasted the
> file here but still running into the same issue.
> Please let me know if u have any suggestions will be really appreciated.
> Thanks
> Sai
>
>
>
>
> --
> Nitin Pawar
>
>
>
>
>
> --
> Nitin Pawar
>
>
>
--
Nitin Pawar