[IMPALA-1418] Incorrect error about subquery not supported (query has no subquery)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Works for Me
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.2
• Assignee: Dimitris Tsirogiannis
• Reporter: casey
• Created: 24/Oct/14 17:57
• Updated: 29/Jan/16 15:25
• Resolved: 09/Sep/15 19:00

Description

The query below should run

Query: select 1
FROM alltypestiny
WHERE true = (1 IN (smallint_col, int_col))
ERROR: AnalysisException: IN and/or EXISTS subquery predicates are not supported in binary predicates: TRUE = (1 IN (smallint_col, int_col))

this one is good

Query: select 1
FROM alltypestiny
WHERE 1 IN (smallint_col, int_col)
+---+
| 1 |
+---+
| 1 |
| 1 |
| 1 |
| 1 |
+---+

Issue Links

• duplicates: IMPALA-1949 Analysis exception when a binary predicate contains an IN operator with values.