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

impala-shell reports "Fetching results" earlier than results are fetched

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • Impala 0.5
    • Product Backlog
    • Clients

    Description

      I'm running a query like so:

      [localhost:21000] > select v1, v4 from my_table where n=4 and v2 LIKE "%version";
      Query: select v1, v4 from my_table where n=4 and v2 LIKE "%version"
      Query finished, fetching results ...
      

      The schema is wide (101 columns) and the data is about 300GB across 7 machines. When I look at the web debug UI, it says:

      3072d6376a14131:b844083bdd92fe94	select v1, v4 from my_table where n=4 and v2 LIKE "%version"	QUERY	2013-02-12 12:48:36	1135 / 1437 (78.984%)	FINISHED	86	Profile
      

      Note how the state column is FINISHED whereas the query is still running. It takes about 63 seconds to run the query, whereas the "query finished" returns immediately.

      Attachments

        Activity

          People

            alan@cloudera.com Alan Choi
            philip Philip Martin
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: