I'm executing this simple query:
SELECT *
FROM database.table
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 2.6.2.0
HDP-2.6.5.0
Hive interactive LLAP 2.1.0.2.6.5.0-292 rb4e94af3e14406485e415d10711bae5c3f731948
