hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Monkey2Code <monkey2c...@gmail.com>
Subject (hive) Table loading with NULL values
Date Tue, 15 Jan 2013 21:19:25 GMT
Hi ,
I have created a table a below
--use case 2 to test basics
DROP TABLE USER_DATA4;

CREATE  TABLE USER_dATA4
(
userid INT,
  movieid INT,
  rating INT,
  unixtime int
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;

--loading data into user_table

LOAD DATA LOCAL INPATH '/home/cloudera/ml-1m/ratings.dat'
OVERWRITE INTO TABLE USER_DATA4;

and trying to load below data

1::1193::5::978300760
1::661::3::978302109
1::914::3::978301968
1::3408::4::978300275
1::2355::5::978824291
1::1197::3::978302268
1::1287::5::978302039
================
this is probably due to delimiter specified., can someone tell how can I
overcome this  and load data with different delimiters


Thanks

Mime
View raw message