hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MiaoMiao <liy...@gmail.com>
Subject How to set default value for a certain field?
Date Wed, 05 Sep 2012 04:23:10 GMT
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