[IMPALA-12438] Write View Expanded Query to Impala Profiles

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: workload-management
• Epic Link: Workload Management
• Epic Color: ghx-label-3
• Assignee: Jason Fehr
• Reporter: Manish Maheshwari
• Created: 11/Sep/23 11:19
• Updated: 19/Jan/24 11:28

Description

When running queries with multi level views, Currently Impala profiles do not log the expanded query with views replaced. This makes it harder to understand the actual tables involved in the query and also to understand the complxity of the views used

A change would be to write into the query profiles the original query and the same query with all the views replaced with their actual definitions - 

e.g. 

Analyzed query: SELECT * from db.table limit 10
Expanded query: Select * from (select d.c1, d.c2, e.c3 from d inner join (select c3 from f inner join .... ) e on d.c1 = e.c2 left join .....   ) limit 10