Hi Paradisehi The issue is that the default file system uri obtained from hadoop config variable fs.default.name (from hadoop-default/site.xml) does not match the uri that u are loading from.
As Zheng mentioned �C can u please use the hdfs://namenode:xxxxx/test/shixing/log �C where ‘namenode:xxxxx’ appears in fs.default.name setting? Also �C please use hive from the svn repository at http://svn.apache.org/repos/asf/hadoop/hive/trunk �C the facebook mirror distribution is out of date Joydeep ________________________________ From: paradisehi [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2008 1:46 AM To: Zheng Shao Cc: hive-user@hadoop.apache.org Subject: Re:RE: [hive-users] "LOAD DATA" From hdfs can'r work under hadoop 0.19 hive> LOAD DATA INPATH 'hdfs://xx-mapred000.xx01:54310/test/shixing/log' INTO TABLE log_stg4; FAILED: Error in semantic analysis: line 1:17 Path is not legal 'hdfs://xx-mapred000.xx01:54310/test/shixing/log': Cannot load data across filesystems, use load data local 在2008-12-02 17:22:28,"Zheng Shao" <[EMAIL PROTECTED]> 写道: Let’s use hive-user@hadoop.apache.org<mailto:hive-user@hadoop.apache.org> instead of [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> Try adding a prefix like this: LOAD DATA INPATH 'hdfs://namenode:50001/test/shixing/log' INTO TABLE log_stg2; The hdfs address can be found in hadoop/conf/hadoop-site.xml. Zheng From: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> [mailto:[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>] On Behalf Of paradisehi Sent: Tuesday, December 02, 2008 1:04 AM To: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> Subject: [hive-users] "LOAD DATA" From hdfs can'r work under hadoop 0.19 The hive is also downloads from http://mirror.facebook.com/facebook/hive/hadoop-0.19/ hive> LOAD DATA INPATH '/test/shixing/log' INTO TABLE log_stg2; FAILED: Error in semantic analysis: line 1:17 Path is not legal '/test/shixing/log': Cannot load data across filesystems, use load data local Time taken: 0.064 seconds ________________________________ 网易免费邮,全球最大的中文免费邮箱<http://www.yeah.net> ________________________________ 网易免费邮,全球最大的中文免费邮箱<http://www.yeah.net>