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 >
