It is supported in trunk. Which version of Hive are you running? Ning
On Nov 3, 2009, at 2:35 PM, Ryan LeCompte wrote: > Hello all, > > I was trying to do something like this today and Hive didn't like it: > > SELECT AVG(IF(expression, anotherexpression, NULL)) ... > > I don't think Hive supports returning NULL as the value of the last > argument to IF(...). > > Is there any plan to support this? > > Thanks, > Ryan >
