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]<mailto:[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
