Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.

There are certain scenarios where "not in" clause gives incorrect results when type coercion cannot take place. 

These occur when the in clause contains at least one operand which cannot be type-coerced to the column on which the in clause is being applied to. 

Please refer to the attached query examples for more details.