Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: SemanticException Line 1:17 issue


Copy link to this message
-
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