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
