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