hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: (hive) Table loading with NULL values
Date Wed, 16 Jan 2013 07:50:58 GMT
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 <monkey2code@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

Mime
View raw message