How to set default value for a certain field

[mahender bigdata]

Hi,

is there Ideal solution in Hive to specify default values at schema 
level. Currently we are using *COALESCE *operator in converting null 
values to default value, this would require reading entire table. But it 
would be nice if some one has different approach of setting default 
values for Columns @ Schema level.

Thanks in advance