is :: your delimiter or : only? in any case you can try by specifing '\072' as column separator (thats for one : )
On Wed, Jan 16, 2013 at 2:49 AM, Monkey2Code <monkey2c...@gmail.com> wrote: > 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 > -- Nitin Pawar