[HIVE-16768] NOT operator returns NULL from result of <=>

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.1.1
• Assignee: Hui Fei
• Reporter: Alexander Sterligov
• Created: 26/May/17 07:51
• Updated: 05/Jun/17 15:05
• Resolved: 05/Jun/17 15:05

Description

SELECT "foo" <=> null;
returns false as expected.

SELECT NOT("foo" <=> null);
returns NULL, but should return true.

Workaround is
SELECT NOT(COALESCE("foo" <=> null));

Issue Links

• is related to: HIVE-15517 NOT (x <=> y) returns NULL if x or y is NULL