Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-12981

Support a column list in compute stats that is retrieved via a subquery

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Backend, Frontend
    • None

    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'
      ) 

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            myloginid@gmail.com Manish Maheshwari
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: