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. > Thanks > Sai > > > > > -- > Nitin Pawar > > > -- Nitin Pawar
