Last Modified Date: 03 Jan 2019
- Tableau Desktop
- Cloudera Hadoop Hive
- Cloudera Impala
Option 1Remove multiple COUNT D statements.
For Impala 1.4 and earlier:
Modify your Impala server configuration by running the following command:
SET APPX_COUNT_DISTINCT=trueand 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
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.
CauseThis issue is caused by a limitation with the Cloudera database. Cloudera is unable to support multiple COUNT D statements in a query. For more information, see the Cloudera Issues web page.
Additional InformationPlease note that this issue is not confined to COUNT D, a similar issue may occur when using multiple TO_DATE(TRUNC( x)) statements in the query. If you do encounter this issue, please remove all TO_DATE(TRUNC( x)) statements.
Discuss this article...