Last Modified Date: 27 Aug 2018
- 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.