hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cam Bazz <camb...@gmail.com>
Subject left outer join and nulls
Date Fri, 18 Feb 2011 08:01:43 GMT
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.

Mime
View raw message