You could use the following construct if ( T.c is null, 0, T.c)
Checkout the conditional functions at http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#Conditional_Functions <http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#Conditional_Functions>Ashish On Feb 18, 2011, at 12:01 AM, Cam Bazz wrote: Hello, When we do a left outer join, and the right table does not have row, it will return NULL s for those values. is there any way to turn those nulls into 0's ? since it is cointing operation, if the right table does not have the row, it means 0's not nulls. best regards, -c.b.
