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

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

     [ https://issues.apache.org/jira/browse/IMPALA-12438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Manish Maheshwari updated IMPALA-12438:
---------------------------------------
    Epic Link: IMPALA-12426

> 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
>            Assignee: Jason Fehr
>            Priority: Major
>
> 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