Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
ghx-label-9
Description
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 -
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' )