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
