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

Query cancellation throws error, reports wrong query text

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • Impala 1.4
    • Impala 2.11.0
    • Backend
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: