[IMPALA-1989] Analysis exception when inline view has case statement with IN predicates

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.2
• Fix Version/s: Impala 2.3.0
• Labels: sql-language
• Target Version: Impala 2.5.0
• Assignee: Dimitris Tsirogiannis
• Reporter: Dimitris Tsirogiannis
• Created: 11/May/15 23:05
• Updated: 02/Dec/15 04:53
• Resolved: 02/Dec/15 04:53

Description

The following query throws an analysis exception:

select * from (select * from functional.alltypestiny case when int_col in (1,2) then 1 else 2 end as b) t where b > 0;

Error: IllegalStateException: Failed analysis after expr substitution
Cause by: AnalysisException: IN and/or EXISTS subquery predicates are not supported in binary predicates: CASE WHEN int_col in (1,2) THEN 1 ELSE 2 END <10

Issue Links

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