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