You can translate the question and the replies:

[JDBC ROUTE] [ERROR] Received exception with message 'ERROR: Grouped aggregate function calls may not be nested' i am getting this issue after adding group by clause .Note the one source is snowflake and other is netezza

on denodo 7
user
24-03-2020 22:24:46 -0400

2 Answers

Hi, The error "ERROR: Grouped aggregate function calls may not be nested" could occur during the use of aggregate functions that cannot be nested multiple times or mixing aggregation functions in a *select* that has no *group by* or even the usage of incorrect syntax of functions while creating a aggregate field. In order to resolve this error, I would perform the following checks: * Check whether the syntax of the functions used while creating a new aggregate field is correct. This can be done by navigating to Help>Functions list menu option or try stating it as a subquery. * Check the log files available under “<DENODO_HOME>/logs/vdp” folder which helps to debug any errors that occurs in the Denodo Platform. Hope this helps!
Denodo Team
25-03-2020 08:05:50 -0400
still getting the same error : #0 [JDBC ROUTE] [ERROR] Received exception with message 'ERROR: Grouped aggregate function calls may not be nested'
user
25-03-2020 16:57:21 -0400
You must sign in to add an answer. If you do not have an account, you can register here