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

Query cancelled from Impala shell displayed as in-flight in Web UI.

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 2.0
    • Impala 2.1
    • None
    • None

    Description

      Reproduction:

      1. Run this query from the Impala shell.

      use functional;
      select sum(t1.int_col * t1.id) OVER (
      ORDER BY t1.int_col * t1.id ASC, t3.year + t3.tinyint_col ASC ROWS
      BETWEEN 66 PRECEDING AND 21 FOLLOWING) AS int_col_1
      FROM alltypes t1
      INNER JOIN alltypes t2 ON t2.month = t1.smallint_col
      INNER JOIN alltypes t3 ON t3.bigint_col = t2.bigint_col
      WHERE
      t2.id <= t3.smallint_col + t2.tinyint_col
      order by 1
      limit 5;
      

      2. Cancel the query with Ctrl+C

      3. Go to Impala Web UI and observe that the query is in the EXCEPTION state, but still in the in-flight list.

      Instead, the query should be moved to the completed queries list.

      From observing the metrics, it appears that the query is at least not consuming resources anymore.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            alex.leblang_impala_e0fc Alex Leblang
            alex.behm Alexander Behm
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment