Hi, this is the result: $ bin/hadoop dfs -ls /user/zhoumin/log/web_log2009010606 Found 1 items -rw-r--r-- 3 hadoop supergroup 204198066 2009-01-12 16:36 /user/zhoumin/log/web_log2009010606
On Tue, Jan 13, 2009 at 3:43 PM, Raghu Murthy <ra...@facebook.com> wrote: > 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 > > > > > > -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. http://coderplay.javaeye.com
