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
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