topic Re: mySQL data loading error in Data Movement & Streaming

mySQL data loading error

Ranakba — Wed, 19 Mar 2025 23:04:08 GMT

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?

Re: mySQL data loading error

fmarvnnt — Thu, 23 Mar 2023 10:48:21 GMT

I would suggest you to open a support case.

Regards,

Re: mySQL data loading error

nev-21 — Fri, 10 Nov 2023 22:27:33 GMT

https://stackoverflow.com/questions/36829911/how-to-resolve-order-by-clause-is-not-in-select-list-caused-mysql-5-7-with-sel

https://stackoverflow.com/questions/37951742/1055-expression-of-select-list-is-not-in-group-by-clause-and-contains-nonaggr

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