[
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)
