Not the answer you need?
Register and ask your own question!

Problem with "only_full_group_by"

augusto.ferronatoaugusto.ferronato EntrantCurrent User Role Novice
Hello,
I try to run a ETL file, but i receive the error below:
In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'zabbix_reports.ft_events_ciclo.seg_month'; this is incompatible with sql_mode=only_full_group_by

The problem is, i disabled the mode on MySQL:

mysql> select @@sql_mode;
+

+
| @@sql_mode |
+
+
| |
+
+
1 row in set (0.00 sec)


in my.cnf to
[mysqld]
sql_mode = ""

Restart the MySQL, and the same error occur, how can i solve this? It's a MySQL problem? Or ETL (Spoon/Pentaho) have some problem?

Thanks so much!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.