Can you paste the output of the following command? $ hadoop dfs -ls /user/zhoumin/log/web_log2009010606
On 1/12/09 11:40 PM, "Jeremy Chow" <coderp...@gmail.com> wrote: > I've tried it, but failed. > > hive> LOAD DATA INPATH 'hdfs://master:9000/user/zhoumin/log/web_log2009010606' > OVERWRITE INTO TABLE log_data; > FAILED: Error in semantic analysis: line 1:18 Path is not legal > 'hdfs://master:9000/user/zhoumin/log/web_log2009010606': Cannot load data > across filesystems, use load data local > Time taken: 2.641 seconds > > > On Tue, Jan 13, 2009 at 11:04 AM, Joydeep Sen Sarma <jssa...@facebook.com> > wrote: >> Please give a full uri like hdfs://xxx.yyy.zzz:9000/user/S >> >> >> >> Where xxx.yyy.zzz is the same namenode/hdfs instance where u are planning to >> store the hive tables. >> >> >> >> >> From: Jeremy Chow [mailto:coderp...@gmail.com] >> Sent: Monday, January 12, 2009 6:17 PM >> >> To: hive-user@hadoop.apache.org >> Subject: Re: Can hive load a table from a SequenceFile? >> >> >> >> Hey Joydeep, >> >> - load data infile yyy into table xxx >> >> hive> LOAD DATA INPATH '/user/zhoumin/log/web_log2009010606' OVERWRITE INTO >> TABLE log_data; >> FAILED: Error in semantic analysis: line 1:18 Path is not legal >> '/user/zhoumin/log/web_log2009010606': Cannot load data across filesystems, >> use load data local >> Time taken: 0.039 seconds >> >> It failed, that file existed in hdfs, but can not be loaded into hive. >> >> -- >> My research interests are distributed systems, parallel computing and >> bytecode >> based virtual machine. >> >> http://coderplay.javaeye.com > >
