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

Impala Queries Executing long time (long running impala queries)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Information Provided
    • None
    • None
    • None
    • None
    • Impala Shell v2.7.0-cdh5.10.1
    • Important
    • ghx-label-5

    Description

      I'm seeing a lot of simple queries like, “SELECT * FROM DATABASE.TABLE”, “SHOW TABLES” and “DESCRIBE database.table” that hang around in the list and say they’re Executing, even 90-170 minutes after they’ve completed.

      I would like to know if there is a way to configure Impala to stop/cancel a long-running query after a certain amount of time.

      Found the below link to set time limit but were using TABLEAU so need more time for tableau(6 users) queries.

      https://www.cloudera.com/documentation/enterprise/latest/topics/impala_query_timeout_s.html

      It seems like it’s almost necessary to run two instances of Impala (one for Tableau and one for all other requests).

      Any suggestions?

      Thanks.

      Attachments

        1. impala executing time.PNG
          61 kB
          Venkat Atmuri

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vratmuri Venkat Atmuri
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: