Re: How to set default value for a certain field

[mahender bigdata]

Thanks Zack. But it tries to modify the actual data which has null 
value. This might cause data issue. correct me if I'm wrong.

On 2/23/2016 11:03 AM, Riesland, Zack wrote:

“null defined as” is what we use

*From:*mahender bigdata [mailto:mahender.bigd...@outlook.com]
*Sent:* Tuesday, February 23, 2016 1:26 PM
*To:* user@hive.apache.org
*Subject:* Re: How to set default value for a certain field

Any idea on below requirement.

On 2/19/2016 2:47 PM, mahender bigdata wrote:

    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