[jira] [Comment Edited] (IMPALA-12981) Support a column list in compute stats that is retrieved via a subquery

["Jason Fehr (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-12981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17851719#comment-17851719 ] 

Jason Fehr edited comment on IMPALA-12981 at 6/3/24 4:24 PM:
-------------------------------------------------------------

Use Case -- customers can run compute stats on the weekends for the most popular columns on the most popular tables.  This use case must be accomplished using only sql without using a scripting language.


was (Author: JIRAUSER298428):
Use Case -- customers can run compute stats on the weekends for the most popular columns on the most popular tables.

> Support a column list in compute stats that is retrieved 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
>            Priority: Major
>
> 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org