Product: TIBCO Spotfire®
Cloudera Impala Connector throwing Error when using COUNT(DISTINCT) aggregate functions with multiple columns in Spotfire.
Cloudera Impala Exception - DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT transaction.column_name); deviating function: count(DISTINCT transaction.Column_name)
The following is from Cloudera - https://impala.apache.org/docs/build/html/topics/impala_query_options.html .
"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 command within the impala-shell interpreter."https://impala.apache.org/docs/build/html/topics/impala_set.html#set