I'm executing this simple query:
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 126.96.36.199 HDP-188.8.131.52 Hive interactive LLAP 184.108.40.206.6.5.0-292 rb4e94af3e14406485e415d10711bae5c3f731948
... View more