MySQL -Pentaho Error getting views from schema [null]

Question

when trying to run Insert/Update or LookUp functions in Pentaho to get my SQL tables it shows me this error, anyone knows, how can I fix it?

Error getting views from schema [null]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING TABLE_TYPE IN ('VIEW',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SCH' at line 1

Check your connection (Edit the connection, and test). When this is correct, press the SQL button. Does the error persist? — AlainD, Oct 08 '18 at 15:11

score 0 · Answer 1 · edited Jun 12 '19 at 11:45

0

Downgrade your Mysql version compatible to Pentaho version. You should get that in your Pentaho manual.

I downgraded from mysql 8.0 to 5.6/5.5 and on 5.6 its got resolved.

edited Jun 12 '19 at 11:45

Suraj Rao

29,388
11
94
103

answered Jun 12 '19 at 11:42

Rajan Kshirsagar

1

The query pentaho uses is compatible to mysql 5.6. I got resolved with this. – Rajan Kshirsagar Jun 12 '19 at 11:43

MySQL -Pentaho Error getting views from schema [null]

1 Answers1