Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive LLAP multiple IN conditions on same column bug/issue?

Highlighted

Hive LLAP multiple IN conditions on same column bug/issue?

New Contributor

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

 

 

 

Don't have an account?
Coming from Hortonworks? Activate your account here