6 Replies Latest reply on Oct 8, 2015 10:06 AM by Scott Wallace

    Teiid Impala Multiple Count Distinct Issue

    Scott Wallace Newbie

      Impala does not currently support multiple count distinct on different columns in the same sql.

       

      https://issues.cloudera.org/browse/IMPALA-110

       

      If we execute such a query in Teiid against Impala, an error is received.

       

      Eg. Teiid query:

       

      select count(distinct col1), count(distinct col2)

      from table;

       

      Would it be possible for the Teiid translator to request the details and execute the aggregate count distinct on its end?

       

      Are there any hints available to force that behavior to not push down the aggregate to Impala?

       

      Much thanks,

      Scott