“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