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

Row count incorrect in summary while query running

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

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • None
    • None
    • None
    • ghx-label-8

    Description

      For a query (below) the summary is incorrect on the row count for the nested loop join, however when the query is complete its corrected:

      select g.name, g.start, g.aa, sum(case when p.pn < 125.0 then 1 else 0 end) / cast(max(lf_count) as decimal(10,6)) as lf, sum(case when p.pn >= 125.0 then 1 else 0 end) / cast(max(hf_count) as decimal(10,6)) as hff from g join p on (g.sampleid = p.sample_id) cross join (select count as lf_count from p where pn < 125.0) lff cross join (select count as hf_count from p where pn >= 125.0) hf group by g.name, g.start, g.aa order by name desc

       

      compared to the finished query

       

       

      Attachments

        Issue Links

        Activity

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

          People

            Unassigned Unassigned
            peter.ebert Peter Ebert
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment