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

Make multiple COUNT(DISTINCT) message state workarounds

    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

            People

            • Assignee:
              jinchul Jinchul Kim
              Reporter:
              jrussell John Russell
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: