1 Reply Latest reply on Nov 15, 2017 2:30 AM by lenaic.ridinger

    Multiple countd (count distinct) alternative for Hadoop users.

    Stephen Bava

      All,

       

      If you are a Hadoop user like me, you have likely encountered the below error. Someone I work with found a great solution to this... and it is easy! Attached is an example workbook.

       

      It is simple, run a fixed LOD. E.G. {fixed [Customer Name] : max([Number of Records])} - This will give you the same result as a countd. Note that min/max/avg are interchangeable and produce the same result. You can do this as much as needed and even calculate them against each other and put them together in the same worksheet or dashboard. No more of the below 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>)