hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MiaoMiao <liy...@gmail.com>
Subject Re: How to set default value for a certain field?
Date Thu, 06 Sep 2012 03:20:12 GMT
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,  <carla.staeben@nokia.com> 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:philip.j.tromans@gmail.com]
> Sent: Wednesday, September 05, 2012 07:52
> To: user@hive.apache.org
> 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" <liy099@gmail.com> 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

Mime
View raw message