ailto:anh...@vtc.vn]
> Sent: Wednesday, November 02, 2011 7:23 PM
> To: user@hive.apache.org
> Subject: Re: problem with load data from local file system into RCFILE
table
>
> hi ,
>
> "LOAD DATA LOCAL INPATH 'test.txt' INTO TABLE text" that is actual copy
> tex
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:
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 't