[ https://issues.apache.org/jira/browse/IMPALA-12438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Manish Maheshwari updated IMPALA-12438: --------------------------------------- Epic Link: (was: 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org