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

Switch to Threaded View
Hive >> mail # user >> Re: How to set default value for a certain field?


Copy link to this message
-
Re: How to set default value for a certain field?
This will certainly work, but with 20 tables, each of 20GB size, using
insert overwrite could take up both time and space a lot.

On Wed, Sep 5, 2012 at 7:57 PM,  <[EMAIL PROTECTED]> wrote:
> Well, you could create the table and then insert overwrite from the file:
>
>
>
> Insert overwrite
>
> Select id, case when value = ‘’ then 3 else value end as value
>
> From testtest;
>
>
>
> Carla
>
>
>
> From: ext Philip Tromans [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 05, 2012 07:52
> To: [EMAIL PROTECTED]
> Subject: Re: How to set default value for a certain field?
>
>
>
> You could do something with the coalesce UDF?
>
> Phil.
>
> On Sep 5, 2012 12:24 AM, "MiaoMiao" <[EMAIL PROTECTED]> wrote:
>
> I have a file whose content is:
> 1,1
> 2,1
> 3,2
> 4,
> 5,
> Then I import in into a hive table.
> create external table testtest (id int,value int) row format delimited
> fields terminated by ',' stored as textfile location '/wtt/test/def';
> select * from testtest;
> 1       1
> 2       1
> 3       2
> 4       NULL
> 5       NULL
>
> I want to set default value for value, but seems hive simply doesn't
> have this feature, any idea?
> 1       1
> 2       1
> 3       2
> 4       3
> 5       3