hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Teja Kunapareddy" <tejakunapare...@gmail.com>
Subject Hive Query
Date Wed, 03 Jun 2015 06:23:45 GMT
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

 

 


Mime
View raw message