RE: problem with load data from local file system into RCFILE table

2011-11-04 Thread weimin zhu
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

Re: problem with load data from local file system into RCFILE table

2011-11-02 Thread trang van anh
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:

problem with load data from local file system into RCFILE table

2011-11-02 Thread weimin zhu
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