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

Make multiple COUNT(DISTINCT) message state workarounds

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

Details

    Description

      The message for a query with multiple COUNT(DISTINCT) currently looks like:

      [localhost:21000] > select count(distinct x), count(distinct y) from t1;
      ERROR: AnalysisException: all DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT x); deviating function: count(DISTINCT y)

      How about adding an INFO message after the error saying something like:

      INFO: If estimated counts are OK, replace COUNT(DISTINCT) with NDV(). Enable the APPX_COUNT_DISTINCT query option to perform this rewrite automatically.

      Attachments

        Activity

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

          People

            jinchul Jin Chul Kim
            jrussell John Russell
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment