hi , "LOAD DATA LOCAL INPATH 'test.txt' INTO TABLE text" that is actual copy text.txt file to folder in hdfs so that HIVE throws invalid format exception.
If you want to load file test.txt into hive table, you can create table with properties that is suitable format of file. On 11/2/2011 3:43 PM, weimin zhu wrote:
Hi I have problem with loading data into RCFILE table from local file system. I am using hive 0.7.1 of cloudera's distribution. 1.create table create table test(c1 int,c2 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' Stored as RCFILE; 2.load text file into table LOAD DATA LOCAL INPATH 'test.txt' INTO TABLE text; Hive command line throwing errors as the following: Loading data to table default.test Failed with exception Wrong file format. Please check the file's format. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask Can you give me any idea. thanks
