[IMPALA-1798] Very slow performance of Views on top of another Views

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.1, Impala 2.1.1, Impala 2.3.0
• Component/s: Perf Investigation
• Labels: performance planner
• Environment: Cluster 3 nodes Impala 2.1
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Alex Finch
• Created: 18/Feb/15 23:56
• Updated: 30/Oct/18 17:59
• Resolved: 30/Oct/18 17:59

Description

Query from a view has about the same performance as a query from the source table. If we have a VIEW on top of another VIEW (even CREATE view_2 AS SELECT * FROM view_1) the performance is much slower, for more complex queries on top of view_2, the compilation of the query actually never finishes.

Issue Links

• duplicates: IMPALA-4242 Slow planning due to equivalence class computation