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

Query cancellation throws error, reports wrong query text

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Impala 1.4
    • Fix Version/s: Impala 2.11.0
    • Component/s: Backend
    • Labels:
    • Environment:
      impala-shell, cancelling via ^C, while displaying a billion-row result set

      Description

      I was experimenting with a SELECT DISTINCT query for a unique column with a billion values, to see if it would exceed the mem limit. It eventually did start returning results. When I hit ^C to cancel in impala-shell, the result looked like this:

      366727153
      133154612
      596104894
      242600935
      474071842
      307379041
      604906030
      61000172
      621687629

      -----------
      ERROR: Invalid query handle
      Query: use oreilly

      I think impala-shell should handle the cancellation gracefully rather than printing an "invalid query handle" error. What's really confusing is why it echoed

      Query: use oreilly

      which was the statement that immediately preceded my SELECT query. (The USE was run behind the scenes by 'impala-shell -d oreilly'.) It looks like impala-shell forgot which query it was cancelling.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gaborkaszab Gabor Kaszab
                Reporter:
                jrussell John Russell
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: