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

Switch to Threaded View
Hadoop, mail # user - Re: (hive) Table loading with NULL values


Copy link to this message
-
Re: (hive) Table loading with NULL values
Nitin Pawar 2013-01-16, 14:21
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