Manish Maheshwari created IMPALA-12981:
------------------------------------------
Summary: Support a column list in compute stats that is retrived
via a subquery
Key: IMPALA-12981
URL: https://issues.apache.org/jira/browse/IMPALA-12981
Project: IMPALA
Issue Type: Improvement
Components: Backend, Frontend
Reporter: Manish Maheshwari
Support a column list in compute stats that is retrived via a subquery -
Specifically we want to use Impala query history tables where we collect the
columns in a table that are using for joins, aggegrates, filters etc to be
passed into compute stats command -
Suggested Syntax -
{code:java}
compute stats db.tbl (
select distinct join_columns from
from sys.impala_query_log
where contains(tables_queried, "db.tbl")
and query_dttm >current_timestamp()-7
and join_columns rlike 'db.tbl'
) {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]
