How can i disable this only group by feature

Get Help
1

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'data.arbitrages.revenue' which is not functionally dependent on columns in
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

2

Hi @Tonyloi
It seems like it's some special MySQL configuration you're using:
https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc

I don't know how you're hitting this problem. Include more details.

3

I'm trying to sum and group revenues with the same address i only wish to group by the address

4

I would love to know how I can disable the MySQL's only_full_group_by feature in metabase please

5

@Tonyloi Metabase does not set that session variable. It is defined on your MySQL server.
I've never seen this error before, so I guess you have a very special MySQL configuration.