I have connected to the db, and using the following Syntax:
I have also SET DirectUnicodeStrings=TRUE;
But the above query is not getting executed.
I am getting this error:
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: all DISTINCT aggregate functions need to have the same set of parameters as COUNT(DISTINCT <filed-name>); deviating function: COUNT(DISTINCT <field-name>)
Can anyone help me with this? Am I using the correct syntax?