[IMPALA-1797] Alter view with sub-query fails with AnalysisException

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.1, Impala 2.1.1
• Fix Version/s: Impala 2.2
• Environment: Cluster of 3 nodes Impala 2.1
• Assignee: Dimitris Tsirogiannis
• Reporter: Alex Finch
• Created: 18/Feb/15 18:36
• Updated: 20/Dec/15 00:05
• Resolved: 11/Mar/15 00:39

Description

When altering a view an AnalysisException occurs - (drop / create view works)
AnalysisException: Unsupported statement containing subqueries

Workaround
either drop / create view in impala or alter view in Hive.