Re: SemanticException Line 1:17 issue
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
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
Re: SemanticException Line 1:17 issue
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
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. Thanks Sai -- Nitin Pawar -- Nitin Pawar
Re: SemanticException Line 1:17 issue
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
Re: SemanticException Line 1:17 issue
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 saigr...@yahoo.in 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 supergroup654 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. Thanks Sai -- Nitin Pawar -- Nitin Pawar -- Nitin Pawar