Hive Query

[Teja Kunapareddy]

Ravi,

 

Use if condition .. it works .. 

 

Use    ISNOTNULL  instead, and give the replace field as third parameter for
if condition.

 

 

NOTE: false and null are together in if condition

 

 

If(ISNOTNULL(sum(columnname), sum(columnname),0) as sumVendor

 

Regards,

Teja