I am using MYSQL 8.0 version. When I click on "Explore" database in pentaho, it gives me below error.
1. Mysql connectors are up to date.
2.Single table "Select" query runs proper and shows data in grid.
3. Explore only shows error.
Unable to retrieve database information because of an error
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