hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From trang van anh <anh...@vtc.vn>
Subject Re: problem with load data from local file system into RCFILE table
Date Wed, 02 Nov 2011 10:23:23 GMT
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
>
>
>
>


Mime
View raw message