Re: Allowing NULL as a result of an IF statement

[Ryan LeCompte]

I'm running 0.40 release. I can try trunk.

Thanks,
Ryan




On Nov 3, 2009, at 6:29 PM, Ning Zhang <nzh...@facebook.com> wrote:

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