Manish Maheshwari created IMPALA-12438:
------------------------------------------

             Summary: Write View Expanded Query to Impala Profiles
                 Key: IMPALA-12438
                 URL: https://issues.apache.org/jira/browse/IMPALA-12438
             Project: IMPALA
          Issue Type: Improvement
            Reporter: Manish Maheshwari


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. 
{code:java}
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 {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to