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
Sai Sai 2013-03-05, 12:18
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