[jira] [Resolved] (IMPALA-2250) Make multiple COUNT(DISTINCT) message state workarounds

["Jinchul Kim (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-2250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jinchul Kim resolved IMPALA-2250.
---------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.11.0

> Make multiple COUNT(DISTINCT) message state workarounds
> -------------------------------------------------------
>
>                 Key: IMPALA-2250
>                 URL: https://issues.apache.org/jira/browse/IMPALA-2250
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>    Affects Versions: Impala 2.2.4
>            Reporter: John Russell
>            Assignee: Jinchul Kim
>            Priority: Minor
>              Labels: newbie, usability
>             Fix For: Impala 2.11.0
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)