mySQL data loading error

[Ranakba]

I am attempting to connect mysql database to the Qlik data manager in order to analyze my data on qlik. The connection runs smoothly but once I create the connection I get this error:

ODBC Wrapper: Unable to execute SQLTables: [Qlik][MySQL] Expression #1 of ORDER BY clause is not in SELECT list, references column 'information_schema.TABLES.TABLE_SCHEMA' which is not in SELECT list; this is incompatible with DISTINCT

how do i work around this and what does it mean?

[fmarvnnt]

I would suggest you to open a support case.

Regards,

FM

[nev-21]

https://stackoverflow.com/questions/36829911/how-to-resolve-order-by-clause-is-not-in-select-list-ca...

https://stackoverflow.com/questions/37951742/1055-expression-of-select-list-is-not-in-group-by-claus...

https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html


the mysql config has "sql_mode" which has ONLY_FULL_GROUP_BY, it is better to have it enabled, cause the queries are more robust and predictable (easy to read and understand its behaviour)

I think QLIK platform queries (like the one use information_schema.TABLES.TABLE_SCHEMA) should change to embrace that sql_mode