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
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
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