Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HDFS >> mail # user >> (hive) Table loading with NULL values


Copy link to this message
-
Re: (hive) Table loading with NULL values
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