[jira] [Created] (IMPALA-12438) Write View Expanded Query to Impala Profiles

["Manish Maheshwari (Jira)" <ji...@apache.org>]

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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org