[REVIEW] (HIVE-28910) Remove redundant IS NOT NULL predicates when expanding SEARCH

[Stamatis Zampetakis]

Can someone please take a look:
https://github.com/apache/hive/pull/5795

Best,
Stamatis