[IMPALA-1417] CREATE VIEW with WHERE EXISTS / IN with subquery fails with AnalysisException

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Works for Me
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.0.1
• Component/s: Clients
• Labels: impala shell
• Environment: CDH 5.2 with Impala 2.0 - running on cluster of 3 AMD powered servers
• Assignee: Dimitris Tsirogiannis
• Reporter: Alex Finch
• Created: 24/Oct/14 17:37
• Updated: 28/Dec/15 17:43
• Resolved: 30/Oct/14 17:23

Description

Creating a view with EXISTS or IN clause and subquery fails with Analysis exception:null

create view test_view as select * from my_table where user_name IN (select user_name from my_table2);

ERROR: AnalysisException: null
CAUSED BY: NullPointerException: null