subject:"left outer join and nulls"

Re: left outer join and nulls

2011-02-18 Thread Ashish Thusoo

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 Ashish On Feb 18, 2011, at 12:01 AM, Ca

left outer join and nulls

2011-02-18 Thread Cam Bazz

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.