Incremental file

CloverDX Platform
1

Hello Agata,
Incremental key is working fine for most of my graphs with the exception of one scenario.
I am getting this error
Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause

when I try to use the incremental key in this sql

SELECT lower(trim(a.email)) as email,MIN(o.order_date) AS order_date,max(address_id) FROM
address a,
order_header o,
payment p
where
a.address_id>#key01 and
lower(trim(a.email)) is not null and
p.billing_address_id=a.address_id AND
p.payment_id=o.payment_id
group by lower(trim(a.email))

Thanks and best regards,
Kasturi

2

Hello, the error message you stated is a database error message so I think your problem is in your sql query / database. Try running your query with a sample #key1 value in your database to see if you get the same error message.