[ https://issues.apache.org/jira/browse/HIVE-16768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16036358#comment-16036358 ]
Pengcheng Xiong commented on HIVE-16768: ---------------------------------------- Sounds the same problem. Could u try 2.1.1 and see if it reappears? thanks. > NOT operator returns NULL from result of <=> > -------------------------------------------- > > Key: HIVE-16768 > URL: https://issues.apache.org/jira/browse/HIVE-16768 > Project: Hive > Issue Type: Bug > Affects Versions: 2.1.1 > Reporter: Alexander Sterligov > Assignee: Fei Hui > > {{SELECT "foo" <=> null;}} > returns {{false}} as expected. > {{SELECT NOT("foo" <=> null);}} > returns NULL, but should return {{true}}. > Workaround is > {{SELECT NOT(COALESCE("foo" <=> null));}} -- This message was sent by Atlassian JIRA (v6.3.15#6346)