Resolution
Option 1
Remove multiple COUNT D statements.
Option 2
For Impala 1.4 and earlier:
Modify your Impala server configuration by running the following command:
SET APPX_COUNT_DISTINCT=true
and using initial SQL in your workbook.
Note: Currently, there is no way to set query options directly through the JDBC and ODBC interfaces. For JDBC and ODBC applications, you can execute queries that need specific query options by invoking impala-shell to run a script that starts with SET commands, or by defining query options globally through the impalad startup flag --default_query_options
For Impala 2.0 and later:
Use initial SQL in your workbook. For more information, see Query Options for the SET Command page (for Cloudera 5.3.x) on the Cloudera website.
Note: In Impala 2.0 and later, you can set query options directly through the JDBC and ODBC interfaces by using the SET statement. Formerly, SET was only available as a command within the Impala-shell interpreter.