question Re: Hive Null comparison not works properly in Archives of Support Questions (Read Only)

Hive Null comparison not works properly

gnanasekaran_g — Wed, 15 Mar 2017 16:44:45 GMT

Hi,

I have below Hive query and its not giving me "equals" as output. Why?

hive> select case when (NULL=NULL) then "equals" else "not equals" end as value;
OK
not equals

ssainath — Wed, 15 Mar 2017 16:54:49 GMT

check NULL is NULL instead of NULL = NULL. This worked for me.

mramasami — Wed, 15 Mar 2017 17:05:46 GMT

@Gnanasekaran G Use the following ( <=>) operator instead of (=) operator

SELECT CASE WHEN (NULL<=>NULL) THEN "equals" ELSE "not equals" end AS value;

Reference:

mramasami — Thu, 16 Mar 2017 11:58:17 GMT

@Gnanasekaran G if this helped, please vote/accept best answer. we can close the thread

gnanasekaran_g — Thu, 16 Mar 2017 12:39:37 GMT

mramasami — Thu, 16 Mar 2017 12:44:25 GMT

Thanks @Gnanasekaran G please accept best answer. we can close the thread