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 <nitinpawar...@gmail.com>
To: user@hive.apache.org; Sai Sai <saigr...@yahoo.in>
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 <saigr...@yahoo.in> wrote:
Yes Nitin it exists... but still getting the same issue.
>
>
>
>
>________________________________
> From: Nitin Pawar <nitinpawar...@gmail.com>
>To: user@hive.apache.org; Sai Sai <saigr...@yahoo.in>
>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 <saigr...@yahoo.in> 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
