WHERE field in ('AAA')
and field in ('BBB');
with two non-intersecting IN clauses on the same column, which I expect to return no result, but the filter is not working properly and the query returns all rows of the target table instead. Is this a known issue?
I'm working in Ambari and Hive LLAP on Hortonworks, more details about the versions here:
Apache Ambari Version 184.108.40.206 HDP-220.127.116.11 Hive interactive LLAP 18.104.22.168.6.5.0-292 rb4e94af3e14406485e415d10711bae5c3f731948