[
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: [email protected]
For additional commands, e-mail: [email protected]
