RE: NULL values and != operations

2014-02-09 Thread Dima Machlin
: user@hive.apache.org Subject: NULL values and != operations I have come across a strange situation in hive and I want to know if there is an explanation. The CASE operation below does not work when the operator is != but does work then the operator is =. Maybe it is true that an = operation is

NULL values and != operations

2014-02-05 Thread Blaine Elliott
I have come across a strange situation in hive and I want to know if there is an explanation. The CASE operation below does not work when the operator is != but does work then the operator is =. Maybe it is true that an = operation is valid if a value is NULL. But an != operation is invalid i