Denodo Data Catalog. Version 7.0
According to https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/having_clause/having_clause the Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query using the GROUP BY clause. The 'Having' clause is the common and expected component of the Group By clause. However, this functionality is not available in the Data Catalog that diminishes the value of the queries.
Any attempts to add aggregated conditions (ex. count(*)>0) to the output columns or filters that will resemble the Having clause are met with the error messages that the aggregation/aggregate functions are not allowed
Please let us know if any other options were already provided in the Data Catalog that could potentially mimic the Having clause behavior.