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 [email protected] instead of [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] On Behalf Of paradisehi
Sent: Tuesday, December 02, 2008 1:04 AM
To:[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



 

 

网易免费邮,全球最大的中文免费邮箱

Reply via email to