Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB