You can translate the question and the replies:

Denodo Data Catalog: Having Clause

Hi, Even though Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query using the GROUP BY clause, this functionality is not available in the Data Catalog that diminishes the value of the queries. Any attempts to add filters that will resemble the HAVING clause are met with the error messages that the aggregation/aggregate functions are not allowed. What aggregated functions could be used in place of HAVING clause in the Data Catalog?

2 Answers

Hi, I have found the HAVING clause is currently not supported in the Data Catalog. This enhancement will be included in a future Denodo 7.0 update. Hope this helps.
Denodo Team
06-05-2020 17:46:13 -0400
That would be perfect! Thank you for your prompt reply!
07-05-2020 11:51:01 -0400
You must sign in to add an answer. If you do not have an account, you can register here