sorry i was wrong for the utf-8 value correct delimitor will be \u003A for a single colon
On Wed, Jan 16, 2013 at 1:20 PM, Nitin Pawar <[email protected]>wrote: > 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 <[email protected]>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 > -- Nitin Pawar
