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/… > > > > 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
